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

Homework Answers

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



Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Using the accompanying Student Grades​ data, construct a scatter chart for midterm versus final exam grades...
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...
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 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...
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...
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...
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...
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...
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...
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...
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
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT