F-Test in Excel with Unistat
The Unistat statistics add-in extends Excel with F-Test capabilities.
Further documentation is available at section 6.1.5 of the manual, t- and F-Tests.
Sample output
Here we provide annotated example report output from the Unistat Excel statistics add-in for data analysis.
F-Test
| Cases | Mean | Standard Deviation | Standard Error |
|---|
| Haemoglobin | 10 | -0.5300 | 1.4629 | 0.4626 |
|---|
| Platelets | 10 | -0.0300 | 1.2193 | 0.3856 |
|---|
| Total | 20 | -0.2800 | 1.3466 | 0.3011 |
|---|
| F(9,9) | 1.4394 |
|---|
| Right-Tail Probability | 0.2981 |
|---|
| |
| 95% Confidence Interval | 0.3575 <> 5.7951 |
|---|
| Cases | Mean | Standard Deviation | Standard Error |
|---|
| Haemoglobin | 10 | -0.5300 | 1.4629 | 0.4626 |
|---|
| Systolic BP | 10 | 3.1000 | 6.1545 | 1.9462 |
|---|
| Total | 20 | 1.2850 | 4.4731 | 1.0002 |
|---|
| F(9,9) | 17.6990 |
|---|
| Right-Tail Probability | 0.0001 |
|---|
| |
| 95% Confidence Interval | 0.0140 <> 0.2275 |
|---|
| Cases | Mean | Standard Deviation | Standard Error |
|---|
| Platelets | 10 | -0.0300 | 1.2193 | 0.3856 |
|---|
| Systolic BP | 10 | 3.1000 | 6.1545 | 1.9462 |
|---|
| Total | 20 | 1.5350 | 4.4365 | 0.9920 |
|---|
| F(9,9) | 25.4764 |
|---|
| Right-Tail Probability | 0.0000 |
|---|
| |
| 95% Confidence Interval | 0.0097 <> 0.1580 |
|---|