normal distribution chart

  • Thread starter Thread starter Rene
  • Start date Start date
Well, the question is - is your data normally destributed? Show us a sample
of the data.

I think you will first need to sort on the x-axis data then use a formula
such as

=NORMDIST(A1,AVERAGE($B$1:$B$18),STDEVP($B$1:$B$18),FALSE)

depending on the data you would need to plot this on a secondary axis or
normalize it.
 
My data looks like this
A1:A25 (Jan 1 - Jan 31)
B1:B25 (25, 75, 125, blank, 200, 10, etc)

mean 10, std dev 2 (bell curve from www.tushar-tehta.com)
-4 2 6.69151E-05
-3.75 2.5 0.000176298
-3.5 3 0.000436341

The average is 99 and standard deviation is 9.3. I would like to see it
visually on a chart (normal distribution) so when it is out of whack it will
jump out at me. When the standard deviation is more than 1/3 of the average.


Do I resign myself to the standard deviation formula and color code the
result to stand out?

Hopefully this is clearer than mud.

Thanks again.
 
Back
Top