• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

How to create bell curve in Excel 2013 from my data

Hi ,

The description of the above equation is a normal distribution.

The parameter μ in this definition is the mean or expectation of the distribution (and also its median and mode). The parameter σ is its standard deviation; its variance is therefore σ 2. A random variable with a Gaussian distribution is said to be normally distributed and is called a normal deviate.

If μ = 0 and σ = 1, the distribution is called the standard normal distribution or the unit normal distribution, and a random variable with that distribution is a standard normal deviate.

Narayan
 
Narayan, really thanks for explaining it to me and making the correlation to the formula. I did not know and I couldn't recognize from reading the Wiki article that the formula iferror gave me to use in excel, was 'the normal deviation'.
Friends, this is the NORM.DIST excel function!
But it is even better to understand what is behind it with the formula.
 
Last edited:
You must log in or register to reply here.
Back
Top