(solution) ANOVA questions Using the data in the table below answer the

(solution) ANOVA questions Using the data in the table below answer the

ANOVA questions – 6 short questions to answer from data in the attached Excel spreadsheet.

ANOVA questions
Using the data in the table below answer the following questions.
1. Based on output from ANOVA, who is the better bowler? Show the step-by-step calculation of ANOVA.
2. What type of ANOVA test did you conduct? one way?
3. State the independent and dependent variables.
4. Why is the use of ANOVA good for analyzing this data set?
5. State the null and alternate hypotheses
6. Suggest another statistical method that could be used to analyze this data set and explain why (50 words)
Bowlers
John
157
148
150
140
160
167 Mark
180
175
165
195
185
170 Kathy
156
158
145
151
166
161