UNISTAT - the ultimate Excel statistics add-in

5.2.2. Critical Value

This is a single-entry probability calculator, which accepts one probability input at a time. If you have a large number of probabilities and their corresponding parameter values already entered into spreadsheet columns, then use the Probabilities and Critical Values procedure.

After selecting the distribution, enter the probability value and the necessary distribution parameters (e.g. the two degrees of freedom for the F-distribution, number of trials and probability of success for the distribution (which are calculated from the given parameters) and the calculated critical value.

Example

Select Statistics 1Distribution Functions → Critical Value and from the list of distributions select Normal. At the next dialogue enter 0.025 for the probability and enter 0 and 1 for the mean and standard deviation at the next to obtain the following results:

Critical Value

Normal Distribution

Probability =

 0.0250

Mean =

 0.0000

Standard Deviation =

 1.0000

Mean =

 0.0000

Variance =

 1.0000

Frequency =

 0.0584

Critical Value =

-1.9600