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

4.521 ( A )

Explanation:

The determine the F-STAT employ the use of one way anova in excel to solve the problem. the way to solve this using one way anova by excel is

• enter the data given in excel
• after entering the Data , click on Data analysis, click One way anova, Select data,click on label in first row, then click ok

Attached is the image of the excel solution