Expected Frequencies in Excel with UNISTAT
The UNISTAT statistics add-in extends Excel with Expected Frequencies capabilities.
For further information visit UNISTAT User's Guide section 5.2.5. Expected Frequencies.
Here we provide a sample output from the UNISTAT Excel statistics add-in for data analysis.
Expected Frequencies
Student’s t Distribution
Observed: Room Averages
Mean: 722.2976
Standard Deviation: 142.6569
Degrees of Freedom: 2.0001
| Class | Mid-Point | Observed | Expected |
|---|---|---|---|
| 1 | 480.0000 | 7 | 8.8637 |
| 2 | 560.0000 | 28 | 15.9337 |
| 3 | 640.0000 | 36 | 26.3081 |
| 4 | 720.0000 | 39 | 32.6673 |
| 5 | 800.0000 | 30 | 26.8991 |
| 6 | 880.0000 | 11 | 16.4631 |
| 7 | 960.0000 | 8 | 9.1668 |
| 8 | 1040.0000 | 6 | 5.2059 |
| 9 | 1120.0000 | 3 | 3.1213 |
| Chi-Square Statistic | 11.1877 |
|---|---|
| Degrees of Freedom | 5 |
| Right-Tail Probability | 0.0478 |
Expected Frequencies
Gamma Distribution
Observed: Room Averages
Alpha: 25.6358
Beta: 0.0355
| Class | Mid-Point | Frequency | 0.0000 39.0000 |
|---|---|---|---|
| 1 | 480.0000 | 7 | ********** + |
| 2 | 560.0000 | 28 | ****************************+******* |
| 3 | 640.0000 | 36 | ********************************************+* |
| 4 | 720.0000 | 39 | ***********************************************+** |
| 5 | 800.0000 | 30 | *************************************+* |
| 6 | 880.0000 | 11 | *************** + |
| 7 | 960.0000 | 8 | ***********+ |
| 8 | 1040.0000 | 6 | *****+*** |
| 9 | 1120.0000 | 3 | **+** |
| Chi-Square Statistic | 7.5912 |
|---|---|
| Degrees of Freedom | 6 |
| Right-Tail Probability | 0.2696 |