Need to calculate a Bell Type Curve Across a line of data

%3CLINGO-SUB%20id%3D%22lingo-sub-2121960%22%20slang%3D%22en-US%22%3ENeed%20to%20calculate%20a%20Bell%20Type%20Curve%20Across%20a%20line%20of%20data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2121960%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20data%20points%20across%20a%20period%3A%202%2F1%2F2021%20-%206%2F1%2F2021.%20The%20Amount%20for%20each%20week%20during%20this%20period%20is%206.91.%20There%20are%20a%20total%20of%2022%20weeks%2C%2022*6.91%3D152.%3CBR%20%2F%3E%3CBR%20%2F%3EI%20want%20to%20create%20a%20bell%20curve%20and%20the%20underlying%20data.%20Rather%20than.%20Than%20the%20flat%20line%20that%20it%20is%2C%206.91%20for%20each%20period%2C%20I%20want%20to%20have%20Most%20of%20the%20Amount%2075%25%20of%20the%20way%20into%20the%20timeline.%20Period%201%20should%20be%20zero%20and%20Period%2022%20should%20be%20zero.%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3EWhat%20function%2Fformula%20would%20I%20utilize%20in%20order%20to%20accomplish%20this%3F%20The%20end%20result%20intent%20is%20a%20Bell%20Curve%2C%20but%20the%20data%20is%20a%20flat%20line%2C%20it%20is%20always%3A%206.91%26nbsp%3B%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3EI'm%20looking%20for%20something%20similar%20to%20the%20following%20below%20-%20there%20could%20be%20any%20different%20number%20of%20periods%2C%20and%20the%20amount%20won't%20necessarily%20be%206.91%20always%2C%20but%20the%20amount%20will%20be%20fixed%20across%20the%20periods%20and%20we%20want%20to%20conform%20that%20data%20so%20that%20most%20of%20that%20Amount%20is%20bunched%20up%20similar%20to%20what%20is%20noted%20below%20in%20green.%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22bell.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F254256i8B30F1E154859082%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22bell.png%22%20alt%3D%22bell.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2121960%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

I have data points across a period: 2/1/2021 - 6/1/2021. The Amount for each week during this period is 6.91. There are a total of 22 weeks, 22*6.91=152.

I want to create a bell curve and the underlying data. Rather than. Than the flat line that it is, 6.91 for each period, I want to have Most of the Amount 75% of the way into the timeline. Period 1 should be zero and Period 22 should be zero. 

What function/formula would I utilize in order to accomplish this? The end result intent is a Bell Curve, but the data is a flat line, it is always: 6.91  

I'm looking for something similar to the following below - there could be any different number of periods, and the amount won't necessarily be 6.91 always, but the amount will be fixed across the periods and we want to conform that data so that most of that Amount is bunched up similar to what is noted below in green.

bell.png

1 Reply

@vsslasd 

 

Use a histogram. 

Then if your histogram has the bell-curve feature with a mean m and std of s then apply this formula on values that are 3s below your average to 3s over your average

 

=norm.dist(x,m,s,0)

 

see the example