UNISTAT - the ultimate
Excel statistics add-in
Expected Frequencies in Excel with Unistat
The Unistat statistics add-in extends Excel with Expected Frequencies capabilities.
Further documentation is available at section 5.2.5 of the manual, Expected Frequencies.
Sample output
Here we provide annotated example report output from the Unistat Excel statistics add-in for data analysis.
Expected Frequencies
For Room Averages
Student's t Distribution
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 |
Expected Frequencies
For Room Averages
Student's t Distribution
Mean = 722.2976, Standard Deviation = 142.6569, Degrees of Freedom = 2.0001
| 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 | *****+ |