Spreadsheet, Pg. A --Probability Distribution Functions

$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.

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]$