Forum Discussion
vsslasd
Feb 11, 2021Copper Contributor
Need to calculate a Bell Type Curve Across a line of data
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 unde...
Ramiz_Assaf
Feb 12, 2021Iron Contributor
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