     ## MSH! Spreadsheet, Pg. A -- Probability Distribution Functions

 Your Computer's Spreadsheet On this page learn how to: Normal Distribution Statistical Functions Area Under a Normal curve Picture of A Spread Sheet in use     Go to the index page for other spreadsheet techniques.

 Statistic Spread Sheet Functions  NORMDIST(x,mean, standard_dev,cumulative) Returns the normal cumulative distribution for the specified mean and standard deviation. Note: Cumulative is either true for less than or equal to or false for greater than or equal to.   NORMINV(probability,mean,standard_dev) Returns the inverse of the normal curve distribution for the specified mean and standard deviation.   NORMSDIST(z) Returns the standard normal cumulative distribution (has a mean of zero and a standard deviation of one).   NORMSINV(probability) Returns the inverse of the standard normal cumulative distribution (has a mean of zero and a standard deviation of one).   PROB(x_range,prob_range,lower_limit.Upper_limit) Returns the probability that values in a range are between two limits or equal to a lower limit.

 Area Under the Curve -- The Probability a Score is Below a Score, Above a Score, or Between Two Scores             The area below a score is p(x < a) and is computed with:       =NORMDIST(a,mean,standard deviation,true) The area above a score is p(x > a) and is computed with:       =1-NORMDIST(a,mean,standard deviation,true)or       =NORMDIST(a,mean, standard deviation,false) The area between two score is p(b < x < a) and is computed with: =NORMDIST(a,mean, standard deviation,true) -     NORMDIST(b,mean,standard deviation,true)                © 2008, A. Azzolino, www.mathnstuff.com/math/spoken/here/2class/cspreda.htm