UNISTAT - the ultimate Excel statistics add-in

Probabilities and Critical Values in Excel with Unistat

The Unistat statistics add-in extends Excel with Probabilities and Critical Values capabilities.

Further documentation is available at section 5.2.3 of the manual, Probabilities and Critical Values.

Sample output

Here we provide annotated example report output from the Unistat Excel statistics add-in for data analysis.

Probabilities and Critical Values

For Cumulative Probability

Normal Distribution

Cumulative ProbabilityMeanStandard DeviationMeanCritical Value
1 0.0250 0.0000 1.0000 0.0000-1.9600
2 0.0500-2.0000 2.0000-2.0000-5.2897
3 0.1000 1.0000 0.5000 1.0000 0.3592

Probabilities and Critical Values

For Critical Value

Normal Distribution

Critical ValueMeanStandard DeviationMeanCumulative ProbabilityComplementary Probability
1-1.9600 0.0000 1.0000 0.0000 0.0250 0.9750
2-5.2897-2.0000 2.0000-2.0000 0.0500 0.9500
3 0.3592 1.0000 0.5000 1.0000 0.1000 0.9000

Probabilities and Critical Values

For Critical Value

Binomial Distribution

Critical ValueNumber of TrialsProbability of SuccessMeanVarianceFrequencyCumulative ProbabilityComplementary Probability
1 0.0000 5.0000 0.5000 2.5000 1.2500 0.0313 0.0313 0.9687
2 1.0000 5.0000 0.5000 2.5000 1.2500 0.1562 0.1875 0.8125
3 2.0000 5.0000 0.5000 2.5000 1.2500 0.3125 0.5000 0.5000
4 3.0000 5.0000 0.5000 2.5000 1.2500 0.3125 0.8125 0.1875
5 4.0000 5.0000 0.5000 2.5000 1.2500 0.1562 0.9687 0.0313
6 5.0000 5.0000 0.5000 2.5000 1.2500 0.0313 1.0000 0.0000