Last Class Class Home spread sheet notes Class Table Next Class

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


Your Computer's Spreadsheet  
  
 

    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)



Last Class Class Home spread sheet notes Class Table Next Class

[MC,i. Home] [MSH! Home] [Transcription] [Table] [Words] Classes [last] [next]

© 2008, A. Azzolino, www.mathnstuff.com/math/spoken/here/2class/cspreda.htm