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 |

Using the accompanying Student Grades data, construct a scatter
chart for midterm versus final exam grades and add a linear
trendline. What is the model? If a student scores 7878 on the
midterm, what would you predict her grade on the final exam to
be?
Student
Midterm
Final Exam
1
75
64
2
85
91
3
80
68
4
88
83
5
76
60
6
67
80
7
78
74
8
95
94
9
67
61
10
93
87
11...

Below represent scores on an exam, each entry one score for one
student
40
99
59
98
63
63
64
65
67
35
67
67
68
70
71
71
71
46
72
72
60
73
74
74
74
75
97
75
62
76
76
76
76
76
77
57
77
98
77
63
78
78
78
79
79
80
80
80
80
80
81
81
92
81
93
82
82
83
83
83
83
83
83
83
84
84
84...

The data file ExxamScores shows the 40 students
in a TOM 3010 course exxam scores for the Middtermm and Final
exxam. Is there statistically significant evidence to show that
students score lower on their final exxam than middtermm exxam?
Provide the p-value for this analysis.ROUND TO 4 DECIMAL
PLACES.
ExxamScores
Student ID #
Middtermmm
Final
56065
97
64
79499
95
85
59716
89
72
83504
79
64
77735
78
74
57760
87
93
78204
83
70
81177
94
79
54398...

Mid Score
Final Score
80
78
87
85
72
81
69
54
86
70
83
73
78
89
75
84
74
86
75
79
84
75
73
63
74
72
73
69
80
86
75
78
72
75
77
68
76
77
66
78
74
77
71
73
85
79
74
74
76
79
76
73
84
72
77
81
78
86
86
76
81
83
78
83
85
86
73
71
83
83
83
79
72
68
83
90...

Sample scores from four different statistics class sections are
shown below. Run an ANOVA test on them and answer the following
questions:
Class 1
Class 2
Class 3
Class 4
95
79
77
81
99
68
91
96
75
84
84
68
76
78
84
89
82
74
75
78
97
93
82
75
93
95
82
88
83
88
85
98
86
95
96
59
What conclusion can we make about the hypothesis test?

TestScore
53
53
56
56
56
58
58
58
59
59
59
60
60
62
63
63
63
64
65
65
66
67
67
67
67
68
69
69
69
69
71
71
72
72
72
72
73
73
73
73
73
74
75
75
75
76
76
76
76
77
77
77
77
77
78
78
78
79
79
79
79
80
80
80
80
80
80
81
81
81
82
82
83
83
83
83
84
84
84...

Student Grades
Student
Test
Grade
1
76
62
2
84
90
3
79
68
4
88
84
5
76
58
6
66
79
7
75
73
8
94
93
9
66
65
10
92
86
11
80
53
12
87
83
13
86
49
14
63
72
15
92
87
16
75
89
17
69
81
18
92
94
19
79
78
20
60
71
21
68
84
22
71
74
23
61
74
24
68
54
25
76
97...

Use ? to approximate σ. Use a 5% level of significance.
Data:
69
62
75
66
68
57
61
84
61
77
62
71
68
69
79
76
87
78
73
89
81
73
64
65
73
69
57
79
78
80
79
81
73
74
84
83
82
85
86
77
72
79
59
64
65
82
64
70
83
89
69
73
84
76
79
81
80
74
77
66
68
77
79
78
77

The following scores on the midterm exam in a math
class were recorded. Find IQR. 93 81 59 69 82 73 61 77 95 84 88 71
85 97 63 72 89 80 60 98 91 62 78 83 76 81 94 66 83 96

As part of its freshman orientation process, a college gives a
math placement exam to incoming freshmen. The math department is
interested in whether there is a statistically significant
difference in the average exam score for students in different
programs, at a level of α=0.01 . The exam scores for random samples
of science, engineering, humanities, and business majors are shown
in the following table. The math department has confirmed that the
samples were randomly selected and independent, that the...

ADVERTISEMENT

Get Answers For Free

Most questions answered within 1 hours.

ADVERTISEMENT

asked 22 minutes ago

asked 28 minutes ago

asked 41 minutes ago

asked 45 minutes ago

asked 58 minutes ago

asked 1 hour ago

asked 1 hour ago

asked 1 hour ago

asked 1 hour ago

asked 1 hour ago

asked 1 hour ago

asked 2 hours ago