In: Statistics and Probability
Consider Dataset C for answering the questions that follows below.
| A | Male | 4.80 | |
| 5 | A | Male | 4.24 |
| 3 | A | Male | 3.45 |
| 4 | A | Male | 1.78 |
| 2 | A | Male | 1.06 |
| 9 | B | Male | 4.12 |
| 6 | B | Male | 3.91 |
| 7 | B | Male | 3.42 |
| 10 | B | Male | 2.92 |
| 8 | B | Male | 1.25 |
| 15 | C | Female | 4.84 |
| 11 | C | Female | 4.45 |
| 13 | C | Female | 4.13 |
| 12 | C | Female | 1.84 |
| 14 | C | Female | 1.64 |
ANOVA
| A | B | C |
| 4.8 | 4.12 | 4.84 |
| 4.24 | 3.91 | 4.45 |
| 3.45 | 3.42 | 4.13 |
| 1.78 | 2.92 | 1.84 |
| 1.06 | 1.25 | 1.64 |
Using Excel, go to Data, select Data Analysis, choose Anova: Single Factor. Group by columns at alpha 0.05.
H0: µ1 = µ2 = µ3, Mean responses of the three teams are same
H1: Mean responses of the three teams are different
| ANOVA | ||||||
| Source of Variation | SS | df | MS | F | P-value | F crit |
| Between Groups | 0.279 | 2 | 0.140 | 0.068 | 0.935 | 3.885 |
| Within Groups | 24.699 | 12 | 2.058 | |||
| Total | 24.979 | 14 |
p-value = 0.935
Since p-value is more than 0.05, we do not reject the null hypothesis and conclude that µ1 = µ2 = µ3.
So, mean responses of the three teams are same.
t-test
Using Excel, go to Data, select Data Analysis, choose t-Test: Two-Sample Assuming Unequal Variances at alpha 0.01.
| t-Test: Two-Sample Assuming Unequal Variances | ||
| Male | Female | |
| Mean | 3.095 | 3.380 |
| Variance | 1.719 | 2.310 |
| Observations | 10 | 5 |
| Hypothesized Mean Difference | 0 | |
| df | 7 | |
| t Stat | -0.358 | |
| P(T<=t) one-tail | 0.365 | |
| t Critical one-tail | 2.998 | |
| P(T<=t) two-tail | 0.731 | |
| t Critical two-tail | 3.499 |
H0: µ1 = µ2, Mean male responses is same as the mean female responses
H1: µ1 ≠ µ2, Mean male responses is different from the mean female responses
p-value = 0.731
Since p-value is more than 0.01, we do not reject the null hypothesis and conclude that µ1 = µ2.
So, mean male responses is same as the mean female responses.