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?

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

Daughter's Performance on a Stanardized Math
Test
Mother's Performance on a Stanardized Math
Test
Father's Performance on a Stanardized Math
Test
84
90
72
65
70
85
91
86
81
75
82
83
81
84
84
79
93
72
83
72
70
92
90
88
61
74
68
73
60
82
85
83
72
90
93
94
54
64
69
70
78
62
Daughter -Mother Correlation:
Instructions: Indicate the correlation between
daughters and mothers' scores on the standardized math test...

Test score of 40 students are listed below. Find the percentile for
the test score of 66.
30 35 43 44 47 48 54 55 56 57
59 62 63 65 66 68 69 69 71 72
72 73 74 76 77 77 78 79 80 81
81 82 83 85 89 92 93 94 97 98

ADVERTISEMENT

Get Answers For Free

Most questions answered within 1 hours.

ADVERTISEMENT

asked 6 minutes ago

asked 14 minutes ago

asked 19 minutes ago

asked 20 minutes ago

asked 22 minutes ago

asked 25 minutes ago

asked 28 minutes ago

asked 29 minutes ago

asked 31 minutes ago

asked 40 minutes ago

asked 43 minutes ago

asked 45 minutes ago