Monday, June 2, 2014

An Important Difference Between t and Normal Distribution Graphs

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

 

An Important Difference

Between t and Normal

Distribution Graphs

 

t-Distribution

The t-Distribution is a family of distribution curves that are all symmetrical about a mean of zero. Each unique curve of the t-Distribution is completely described and fully differentiated from all other t-Distribution curves by its degrees of freedom, which is designated by either df or v (Greek letter “nu”). Degrees of freedom is related to sample size by df = n – 1.

The t-Distribution’s PDF formula calculates the PDF at the t Value of point X. The t Value of point X is the number of standard errors that point X is from the sample mean. When calculating the t-Distribution’s PDF (or CDF) at point X, the t Value of point X must be computed for that point X. The t Value of point X is the required input of the t-Distribution’s PDF (and CDF) formula.

The t Value of point X must be determined as follows:

normal distribution, t distribution, statistics, excel, excel 2010, excel 2013
(Click On Image To See a Larger Version)

before the t-Distribution’s PDF can be calculated by the following formula:

normal distribution, t distribution, statistics, excel, excel 2010, excel 2013
(Click On Image To See a Larger Version)

The Excel formula to calculate the t-Distribution’s PDF is shown here as well.

f(t,v) = T.DIST(t, df, FALSE)

The t Value of the point X must also be calculated before calculating the t-Distribution’s CDF, which can be found with the following Excel formula:

F(t,v) = T.DIST(t, df, TRUE)

 

Normal Distribution

The normal distribution is also a family of distribution curves. Each distribution curve is fully described and completely differentiated from all other normal curves by only two parameters: its mean, μ, and standard deviation, σ.

The normal distribution’s PDF at point X is calculated directly by using point X as one of the inputs of the normal distribution’s PDF formula as follows:

normal distribution, t distribution, statistics, excel, excel 2010, excel 2013
(Click On Image To See a Larger Version)

The Excel formula to calculate the normal distribution’s PDF is shown here as well.

f(X,μ,σ) = NORM.DIST(X, μ, σ, FALSE)

The t-Distribution requires that point X be converted to a t Value before calculating the PDF or CDF at point X. The normal distribution does not require such a conversion because point X is one of the inputs to and part of its PFD and CDF formulas.

The normal distribution’s CDF formula in Excel is as follows:

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

 

 

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!

3 comments:

  1. Students can choose their own deadlines and choose their preferred experts, as there is a lot of professional research and experts give many specifications to ensure that the work complies with their standards.Many research paper services also sell bespoke papers and offer other types of academic assistance. Such sites are very popular with students who are hesitant to buy research papers and do not know what to expect. The problem is not that the writing services are reliable, but that many legal services sell first-class papers.If you realize that scientific papers can save you a lot of time for exam preparation and semester papers, you should definitely try them out. Students often ask for help writing research papers because they prefer to pursue a career by studying various theories, which is a legitimate reason to use professor prefer essayservices.

    Our specialists do cheap research for most college subjects. If you want to write custom research, you will be provided with everything you need to know about the subject. Some students do not know where to start their research research and in such cases our work can be a source of inspiration.

    ReplyDelete