Question

Your professor wants to know if all tests are created equal.

What is the F-Stat? Use Excel.

EXAM1	EXAM2	EXAM3	FINAL
73	80	75	65.86667
93	88	93	80.16667
89	91	90	78
96	98	100	84.93333
73	66	70	61.53333
53	46	55	43.76667
69	74	77	64.56667
47	56	60	49.83333
87	79	90	75.83333
79	70	88	71.06667
69	70	73	61.1
70	65	74	61.1
93	95	91	79.73333
79	80	73	65.86667
70	73	78	64.13333
93	89	96	83.2
78	75	68	63.7
81	90	93	79.3
88	92	86	76.7
78	83	77	68.9
82	86	90	76.7
86	82	89	75.83333
78	83	85	75.83333
76	83	71	64.56667
96	93	95	83.2

Answer 1

Run Anova single factor analysis to find whether all means are equal or not.

1. Bring data in to excel sheet.

2. Go to data tab -- > choose data analysis --> choose Anova single factor

Output:

F-stat: 4.52

P-value 0.005

so, P-value is less tha the significance level 0.05

If the p-value is less than 0.05, we reject the null hypothesis that there's no difference between the means and conclude that a significant difference does exist