How Do You Overlay a Normal Distribution Curve on a Histogram in Excel?

Click For Summary
SUMMARY

The discussion focuses on overlaying a normal distribution curve on a histogram using Microsoft Excel, specifically in Office XP. The user initially attempted to use the NORMDIST function but encountered difficulties in its application. Key insights include the necessity of correctly utilizing the NORMDIST function to generate values for the normal distribution and the importance of understanding how to plot these values on the histogram for accurate representation.

PREREQUISITES
  • Familiarity with Microsoft Excel Office XP
  • Understanding of the NORMDIST function
  • Basic knowledge of histogram creation in Excel
  • Concept of normal distribution in statistics
NEXT STEPS
  • Research how to correctly apply the NORMDIST function in Excel
  • Learn the process of creating histograms in Microsoft Excel
  • Explore techniques for plotting multiple data series in Excel charts
  • Study the principles of normal distribution and its graphical representation
USEFUL FOR

This discussion is beneficial for data analysts, statisticians, and Excel users who need to visualize data distributions effectively, particularly those working with statistical data in Microsoft Excel.

dynamics
Messages
8
Reaction score
0
Hello i need help on generating a normal distribution curve. I need to generate this curve in excel and put it on top of my histogram . i have already tried using normdist but nothing is happening . i am using excel in office xp and haven't got a clue please help!
 
Physics news on Phys.org
How, exactly, have you "used" normdist? It will certainly give a value for a normally distributed random variable but how are you using that variable?
 

Similar threads

  • · Replies 25 ·
Replies
25
Views
6K
Replies
1
Views
4K
  • · Replies 4 ·
Replies
4
Views
15K
  • · Replies 10 ·
Replies
10
Views
3K
  • · Replies 3 ·
Replies
3
Views
2K
Replies
2
Views
3K
  • · Replies 3 ·
Replies
3
Views
2K
  • · Replies 1 ·
Replies
1
Views
2K
  • · Replies 17 ·
Replies
17
Views
6K
  • · Replies 2 ·
Replies
2
Views
1K