UNISTAT - the ultimate
Excel statistics add-in
Random Numbers in Excel with Unistat
The Unistat statistics add-in extends Excel with Random Numbers capabilities.
Further documentation is available at section 5.2.4 of the manual, Random Numbers.
Sample output
Here we provide annotated example report output from the Unistat Excel statistics add-in for data analysis.
Random Numbers
F Distribution
d.f. Numerator = 12.0000, d.f. Denominator = 355.0000
| F-Rand | |
|---|---|
| 1 | 0.6786 |
| 2 | 1.5251 |
| 3 | 0.7515 |
| 4 | 0.9441 |
| 5 | 0.9861 |
| 6 | 0.3991 |
| 7 | 0.7644 |
| 8 | 1.7890 |
| 9 | 1.4032 |
| 10 | 1.0889 |
| 11 | 0.9079 |
| 12 | 1.2407 |
| 13 | 0.5897 |
| 14 | 0.8293 |
| 15 | 1.0054 |
| 16 | 1.2533 |
| 17 | 1.2987 |
| 18 | 1.0524 |
| 19 | 0.8973 |
| 20 | 1.2974 |
Random Numbers
Erlang Distribution
Alpha = 11.0000, Beta = 3.7500
| ErlngRand | |
|---|---|
| 1 | 2.2724 |
| 2 | 2.0249 |
| 3 | 3.5204 |
| 4 | 2.3354 |
| 5 | 3.0249 |
| 6 | 2.7626 |
| 7 | 1.6749 |
| 8 | 2.1373 |
| 9 | 2.3669 |
| 10 | 2.8918 |