Probabilities and Critical Values in Excel with UNISTAT

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

For further information visit UNISTAT User's Guide section 5.2.3. Probabilities and Critical Values.

Here we provide a sample output from the UNISTAT Excel statistics add-in for data analysis.

Probabilities and Critical Values

For Cumulative Probability

Normal Distribution

	Cumulative Probability	Mean	Standard Deviation	Mean	Critical 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 Value	Mean	Standard Deviation	Mean	Cumulative Probability	Complementary 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 Value	Number of Trials	Probability of Success	Mean	Variance	Frequency	Cumulative Probability	Complementary 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