UNISTAT - the ultimate
Excel statistics add-in
Frequency Distributions in Excel with Unistat
The Unistat statistics add-in extends Excel with Frequency Distributions capabilities.
Further documentation is available at section 5.1.5 of the manual, Frequency Distributions.
Sample output
Here we provide annotated example report 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 | ****** |