Random Numbers in Excel with UNISTAT
The UNISTAT statistics add-in extends Excel with Random Numbers capabilities.
For further information visit UNISTAT User's Guide section 5.2.4. Random Numbers.
Here we provide a sample 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 |