MSUM Springfield Games Scoring Runs Data Analysis Excel Sheet i want you to solve the attached sheet. Problem 1 (15 points). The cities of Springfield and

MSUM Springfield Games Scoring Runs Data Analysis Excel Sheet i want you to solve the attached sheet. Problem 1 (15 points). The cities of Springfield and Shelbyville both have softball teams.
The players on these two teams care more about scoring runs than they do about actually winning
Statistically speaking, did one team score significantly more runs than the other?
Note that Shelbyville played more games because two of Springfield’s games were cancelled becau
Shelbyville
7
12
9
5
6
15
6
8
4
13
11
10
9
Springfield
4
2
4
8
4
5
14
2
8
0
10
es of Springfield and Shelbyville both have softball teams.
ms care more about scoring runs than they do about actually winning the games (they don’t really play any de
team score significantly more runs than the other?
more games because two of Springfield’s games were cancelled because of rain.
Your Name
Question Hypothesis H0
Question Hypothesis H1
Intermediate Hypothesis H0
Intermediate Hypothesis H1
Level of Confidence
Alpha Level
Variance for x1
Variance for x2
Did you reject H0 in your Intermediate Hypothesis?
Did you reject H0 in your Question Hypothesis?
Interpretation
y winning the games (they don’t really play any defense).
led because of rain.
Type answers below.
Go on to the second problem –>
Problem 2 (15 points). Suppose hypothetical two police departments are comparing t
Each police department randomly selects a sample of 15 squad cars and notes the age
Can we say with 95% confidence that Burlington has an older set of squad cars than M
Burlington
1
15
6
9
2
1
11
12
8
8
7
3
5
9
10
Manchester
2
3
3
6
3
3
1
5
5
2
3
5
3
1
2
ypothetical two police departments are comparing the average age of their squad cars.
selects a sample of 15 squad cars and notes the age of each vehicle.
that Burlington has an older set of squad cars than Manchester?
Question Hypothesis H0
Question Hypothesis H1
Intermediate Hypothesis H0
Intermediate Hypothesis H1
Level of Confidence
Alpha Level
Variance for x1
Variance for x2
Did you reject H0 in your Intermediate Hypothesis?
Did you reject H0 in your Question Hypothesis?
Interpretation
rage age of their squad cars.
ch vehicle.
Type answers below.

Purchase answer to see full
attachment

Submit a Comment