Sunday, June 3, 2012

Plot Normal Curve Excel?

How to plot a normal distribution/bell curve in excel?


  • Put the data in the column A which you wanna plot.
  • Lets suppose data start from A2 till A90, Calculate Mean in A91 and Standard Deviation in A92.
  • Then in Column B, B2 =NORM.DIST(A2,A$90,A$91,FALSE)
  • Plot a scatter plot using both columns A and B.
If the plot is coming positively skewed, then one can try log of the Column B i.e. 
 B2 = Log(NORM.DIST(A2,A$90,A$91,FALSE)) and check if it satisfies normal distribution.
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)