Frequency Distributions in Excel with UNISTAT
The UNISTAT statistics add-in extends Excel with Frequency Distributions capabilities.
For further information visit UNISTAT User's Guide section 5.1.5. Frequency Distributions.
Here we provide a sample output from the UNISTAT Excel statistics add-in for data analysis.
Frequency Distributions
For Room Averages
| Class | Mid-Point | Frequency | Cumulative | Percentage | Cumulative |
|---|---|---|---|---|---|
| 1 | 480.0000 | 7 | 7 | 4.2% | 4.2% |
| 2 | 560.0000 | 28 | 35 | 16.7% | 20.8% |
| 3 | 640.0000 | 36 | 71 | 21.4% | 42.3% |
| 4 | 720.0000 | 39 | 110 | 23.2% | 65.5% |
| 5 | 800.0000 | 30 | 140 | 17.9% | 83.3% |
| 6 | 880.0000 | 11 | 151 | 6.5% | 89.9% |
| 7 | 960.0000 | 8 | 159 | 4.8% | 94.6% |
| 8 | 1040.0000 | 6 | 165 | 3.6% | 98.2% |
| 9 | 1120.0000 | 3 | 168 | 1.8% | 100.0% |
Frequency Distributions
For Room Averages
| 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 | ****** |