Question

# The Test Scores for a Statistics course are given in the Excel below. The data (X1,...

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

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

#### Earn Coins

Coins can be redeemed for fabulous gifts.