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

Click For Summary
To overlay a normal distribution curve on a histogram in Excel, users need to calculate the normal distribution values based on their data set. The function NORMDIST can be used to generate these values, but it requires proper input parameters such as the mean and standard deviation. Users should ensure they are applying the function correctly to the corresponding data points in the histogram. Additionally, it's important to plot the normal distribution curve on the same chart as the histogram for visual comparison. Properly executing these steps will allow for an accurate overlay of the normal distribution curve.
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?
 

Thread 'Hypothesis testing: Defining H0, HA hypotheses so that ( H_A)_A' makes sense'

The standard _A " operator" maps a Null Hypothesis Ho into a decision set { Do not reject:=1 and reject :=0}. In this sense ( HA)_A , makes no sense. Since H0, HA aren't exhaustive, can we find an alternative operator, _A' , so that ( H_A)_A' makes sense? Isn't Pearson Neyman related to this? Hope I'm making sense. Edit: I was motivated by a superficial similarity of the idea with double transposition of matrices M, with ## (M^{T})^{T}=M##, and just wanted to see if it made sense to talk...
View full post »

Similar threads

Undergrad Variable transformation for a multivariate normal distribution
  • · Replies 1 ·
Replies
1
Views
2K
Undergrad Proving a multivariate normal distribution by the moment generating function
  • · Replies 5 ·
Replies
5
Views
3K
MHB Stats question about a bell curve
  • · Replies 1 ·
Replies
1
Views
2K
Bivariate normal distribution- converse question
  • · Replies 3 ·
Replies
3
Views
3K
Fitting distribution to histogram with low number of counts
  • · Replies 8 ·
Replies
8
Views
4K
Undergrad Adding random numbers: Tolerance analysis
  • · Replies 11 ·
Replies
11
Views
3K
Need help with normal distribution
  • · Replies 6 ·
Replies
6
Views
1K
Graduate What exactly is a "rare event"? (Poisson point process)
  • · Replies 12 ·
Replies
12
Views
4K
How to tell if data is normally distributed?
  • · Replies 7 ·
Replies
7
Views
252K
Undergrad Rotation curve of a gas disk in an elliptical galaxy
  • · Replies 5 ·
Replies
5
Views
3K