How To...Plot a Normal Frequency Distribution Histogram in Excel 2010

Learn how to plot a frequency distribution histogram in Microsoft Excel 2010. This helps you to see if your data are distributed normally.

Note - MAC keyboard commands differ from PC.

Category:

Education

Tags:

• Excel
• 2010
• Normal
• Frrequency
• Distribution
• Histogram

[siddsam]

Thanks. Very clear. Very precise for what it sets out to do. How about if you want to fit a normal distribution curve for your data? This would of course mean calculating the appropriate bin intervals going three standard devs on either side.

[eoloughlin]

@siddsam Thanks for viewing the video, and for your kind comments. How to fit a curve - now there's an idea for a new video!

[powdershredder32]

How would you go about creating a line of best fit?

[eoloughlin]

@powdershredder32 A line of best fit is normally a straight line used as a best approximation of a summary of all the points in a scatter-plot - not a histogram. If you simply want a line instead of columns - change the chart type (right click on chart for options).

[everton66ish]

Thanks Eugene, all at once the Frequency function seems a lot easier!

[valkendal]

thank you!

[aragornbob]

Thank you. It was very helpful.

[robertneville777]

Great job! Thank you so much, and thank you for mentioning the Mac keyboard combo. Works great for me!

[seacowkilla]

Amazing Job , Thanks so much ! Very clear and concise !

[c2a0r0o0l1]

Easy, and to the point!! Love the simple explanations! Thank you so very much!

[MrCypher100]

After an hour of searching I finally found the right guide to do this. Thank you so much!!!

[lipsinker34]

Thanks Doc really helped