Critical Value in Excel with UNISTAT
The UNISTAT statistics add-in extends Excel with Critical Value capabilities.
For further information visit UNISTAT User's Guide section 5.2.2. Critical Value.
Here we provide a sample output from the UNISTAT Excel statistics add-in for data analysis.
Critical Value
Student’s t Distribution
| Probability | 0.1000 |
|---|---|
| Mean | 0.0000 |
| Standard Deviation | 1.0000 |
| Degrees of Freedom | 5.0000 |
| Mean | 0.0000 |
| Variance | 1.0000 |
| Frequency | 0.1283 |
| Critical Value | -1.4759 |
Critical Value
Gamma Distribution
| Probability | 0.1000 |
|---|---|
| Alpha | 7.0000 |
| Beta | 3.0000 |
| Mean | 2.3333 |
| Variance | 0.7778 |
| Frequency | 0.0000 |
| Critical Value | 1.2983 |
Critical Value
Binomial Distribution
| Probability | 0.1000 |
|---|---|
| Number of Trials | 13.0000 |
| Prob of Success | 0.4000 |
| Mean | 5.2000 |
| Variance | 3.1200 |
| Frequency | 0.1107 |
| Critical Value | 3.0000 |