Question

The Test Scores for a Statistics course are given in the Excel below.

The data (X1, X2, X3, X4) are for each student.
X1 = score on exam #1
X2 = score on exam #2
X3 = score on exam #3
X4 = score on final exam

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

What is the F-Stat?

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

• 
  A.

  4.521

• B.

  5.532

• C.

  3.331

• D.

  4.87
  2

Answer 1

We can directly use here one way anova by Excel.

Step 1 ) Enter data in Excel.

Step 2) Data >>Data analysis >> One way anova >>Select data >>click on label in first row >>ok

A. 4.521