Tuesday, June 3, 2014

Normal Distribution’s CDF in Excel 2010 and Excel 2013

This is one of the following eight articles on the normal distribution in Excel

Overview of the Normal Distribution

Normal Distribution’s PDF (Probability Density Function) in Excel 2010 and Excel 2013

Normal Distribution’s CDF (Cumulative Distribution Function) in Excel 2010 and Excel 2013

Solving Normal Distribution Problems in Excel 2010 and Excel 2013

Overview of the Standard Normal Distribution in Excel 2010 and Excel 2013

An Important Difference Between the t and Normal Distribution Graphs

The Empirical Rule and Chebyshev’s Theorem in Excel – Calculating How Much Data Is a Certain Distance From the Mean

Demonstrating the Central Limit Theorem In Excel 2010 and Excel 2013 In An Easy-To-Understand Way

The Normal Distribution’s

CDF (Cumulative

Distribution Function)in

Excel

The normal distribution’s CDF (Cumulative Distribution Function) equals the probability that sampled point from a normal-distributed population has a value UP TO X given the population’s mean, µ, and standard deviation, σ.

The normal distribution’s CDF is expressed as F(X,µ,σ).

normal distribution, cdf, cumulative distribution function, excel, excel 20101, excel 2013, statistics
(Click on Image To See a Larger Version)

Unlike the normal distribution’s PDF, the CDF has no convenient closed form of its equation, which is the integral just shown.

In Excel 2010 and beyond, the normal distribution’s CDF must be calculated by the following Excel formula:

F(X,µ,σ) = NORM.DIST(X,µ,σ,TRUE)

The Excel formula parameter “TRUE” indicates that the formula is cumulative, i.e., it is calculating the normal distribution’s CDF (Cumulative Distribution Function) and not its PDF (Probability Density Function).

Prior to Excel 2010, the normal distribution’s PDF was calculated in Excel by this formula:

F(X,µ,σ) = NORMDIST(X,µ,σ,TRUE)

Statistical formulas that worked in Excel versions prior to 2010 will also work in Excel 2010 and 2013.

Note that the CDF has asymptotic values of 0 as X decreases and an asymptotic value of 1 as X increases as shown in the following Excel-generated image:

normal distribution, cdf, cumulative distribution function, excel, excel 20101, excel 2013, statistics
(Click on Image To See a Larger Version)

The normal distribution’s CDF has a value of exactly 0.5 when X equals the population mean. This indicates that 50 percent of the entire area under the normal distribution’s PDF is contained under the curve before X reaches a value of the population mean. The underlying meaning is that a randomly-sample point from a normally-distributed population has a 50 percent chance of having a value less than or equal the population mean. This can be seen in the Excel-generated graph of the normal distribution’s PDF as follows:

normal distribution, cdf, cumulative distribution function, excel, excel 20101, excel 2013, statistics
(Click on Image To See a Larger Version)

This CDF always has a value of 0.15866 when X is one standard deviation below the mean. This indicates that 15.866 percent of the area under the normal distribution’s PDF curve occurs before X reaches the value of the point that is one standard deviation below the population’s mean. The underlying meaning is that a randomly-sample point from a normally-distributed population has a 15.866 percent chance of having a value less than or equal the value that is one standard deviation below the population mean.

This CDF always has a value of 0.84135 when X is one standard deviation above the mean. This indicates that 84.135 percent of the area under the normal distribution’s PDF curve occurs before X reaches the value of the point that is one standard deviation below the population’s mean. The underlying meaning is that a randomly-sample point from a normally-distributed population has an 84.135 percent chance of having a value less than or equal the value that is one standard deviation below the population mean.

A randomly-selected point from a normally-distributed population has a 68.269 percent chance of having a value X that is within one standard deviation above or below the mean (84.135 – 15.866 = 68.269). In other words, 68.269 percent of normally-distributed data lie within one standard deviation of the mean. Similar analysis shows that approximately 95 percent of all normally-distributed data lie within two standard deviations of the mean and 99.7 percent of the data are within three standard deviations of the mean. This rule is often referred to as the Empirical Rule or the 68-95-99.5 Rule.

 

Normal Distribution CDF Example in

Excel

Determine the probability that a randomly-selected variable X taken from a normally-distributed population has the value of UP TO 5 if the population mean equals 10 and the population standard deviation equals 5.

X = 5

µ = 10

σ = 5

F(X,µ,σ) = NORM.DIST(X,µ,σ,TRUE)

F(X=5,µ=10,σ=5) = NORM.DIST(5,10,5,TRUE) = 0.15866

There is a 15.866 percent chance that randomly-selected X equals UP TO 5 if X is taken from a normally-distributed population with a population mean µ = 10 and population standard deviation σ = 5. The CDF diagram of this normal distribution curve also shows the probability of X at X = 5 to that value in the following Excel-generated image.

normal distribution, cdf, cumulative distribution function, excel, excel 20101, excel 2013, statistics
(Click on Image To See a Larger Version)

The following PDF diagram of this normal distribution curve shows 15.866 percent of the total area under the bell-shaped curve that is to the left of X = 5.

.normal distribution, cdf, cumulative distribution function, excel, excel 20101, excel 2013, statistics
(Click on Image To See a Larger Version)

 

Excel Master Series Blog Directory

 

Click Here To See a List Of All

Statistical Topics And Articles In

This Blog

 

You Will Become an Excel Statistical Master!

26 comments:

  1. very informative content, thanks for sharing

    ReplyDelete
  2. I am not so good at math and it is quite hard for me to complete my task. Thanks to the source I found online I managed to complete my excel homework https://mid-terms.com/do-my-excel-assignment/ and my math project

    ReplyDelete
  3. Very nice post, keep up the great work on the site. I love it. Could use some more frequent updates, but i am sure you have got more or better stuff to do like we all have to do unfortunately.

    ReplyDelete
  4. understudies in the UK and all around the world are attempting to adjust to this new change calmly. Notwithstanding, they are inquiring "Would I be able to pay somebody to can i pay someone to write my research paper take my web-based test"? Indeed, you do. We are taking tests of numerous understudies on the web and guaranteeing them to accomplish higher grades helpfully. Thus, if you need to score An or B grade on the internet-based tests, then, at that point, you can get our assistance accessible all day, every day at modest costs.

    ReplyDelete
  5. You have never got reasonable tasks in excellent elsewhere. In any case, you can purchase i need help writing an essay modest task composing today and get exceptional quality that won't ever be frustrating.

    ReplyDelete
  6. Cowhide coats have been around for quite a while, and seeing why is simple. They look great, and they keep going for Mens Classic Real Leather Biker Jacket Black quite a while. A genuine cowhide coat can cost you a lot of cash, however any man with one can let you know that it's definitely worth the venture.

    ReplyDelete
  7. I am reading all about this, but I first read about excel 2010 and 213. I am already using excel 2007, which is very useful for my work. I think you have cleared the details of distributions CDF in excel, which is very helpful for the students of phd dissertation writing services

    ReplyDelete
  8. Excellent article. Very interesting to read. I really love to read such a nice article. Thanks! keep rocking. Owen Grady Cotton Jacket

    ReplyDelete
  9. soil modification company that specializes in bringing organic matter SOIL MODIFICATION in Houstonand beneficial microorganisms to soil to improve its physical and biological properties.

    ReplyDelete
  10. Whether you're a hardcore enthusiast or just trying out something new, we'veEsports Dubai got the perfect event for you. Register today and join the fun!

    ReplyDelete
  11. TACB can aid the firm in a professional manner because of their strong relationships with prominent banks and financial institutions, as well as their significant experience in drafting such proposals.

    ReplyDelete
  12. We offer notary services and procedures that are intended to be as quick, easy, and straightforward for our clients as possible.

    ReplyDelete
  13. Thanks for sharing beautiful content. I got information from your blog. keep sharing
    abogado de accidentes de moto

    ReplyDelete
  14. We administer tests to a large number of students online while promising Top Auditing Firms In Dubai them that they will earn better grades in an efficient manner. Therefore if you need to get an A or B on the online tests you may get our help at reasonable prices which is available all day, every day.

    ReplyDelete
  15. The basic idea is that there is a 50% chance that Winnie The Pooh Letterman Jacket a randomly selected point from a population with a normally distributed distribution will have a value that is lower than or equal to the population mean.

    ReplyDelete
  16. Therefore, if you need our assistance to get an A or B on your online tests, it is affordable and available 24/7. A real cowhide coat might be rather expensive, but every man who has one will tell you that it is absolutely worth the investment. General Trade License Dubai

    ReplyDelete
  17. Even though a genuine cowhide coat can be very expensive, any man who owns one will tell you that the investment was well worth it. Boston Celtics Finals Champions Jacket

    ReplyDelete
  18. So if you need to earn an A or B on your online tests, you may receive our support all day, every day, for a reasonable charge. digimarketinginc.com

    ReplyDelete
  19. What an interesting post. I find this post so informative. fence company Spring Hill, FL

    ReplyDelete
  20. Transform your home into a masterpiece with santander home improvement loans, giving you the financial support to achieve your renovation goals.

    ReplyDelete
  21. Due to its simplicity of use and learning, familiar user interface, and wide range of features and capabilities, Excel is a well-liked option for data analysis. editing help academic essay writing

    ReplyDelete
  22. First of all, thanks for sharing . very informative blog and always keep sharing. We focus on creating places that radiate elegance, comfort, and individuality as an established interior design company Dubai and the United Arab Emirates. Tossround Decor, with its stellar reputation, is your go-to partner for creating the interiors of your dreams. Further more details contact Tossround Decor & Technical Services.
    Interior Design Company Dubai

    ReplyDelete
  23. Delve into comparisons between Excel 2010 and Excel 2013, highlighting any differences or updates in their functionalities for computing the normal distribution's CDF. We strive to ensure that regardless of the Excel version you're using, you'll find guidance tailored to your specific software environment.
    attorney for bankruptcy near me

    ReplyDelete
  24. This comment has been removed by the author.

    ReplyDelete
  25. I appreciate you sharing this informative blog with us. The point you discussed holds great importance. Keep up the good work and continue blogging.

    ReplyDelete