Minnesota State University Mankato Standard Deviation Excel Problems attached is the sheet and it conta 4 problem sets needs to be solved. good luck. 1. (7

Minnesota State University Mankato Standard Deviation Excel Problems attached is the sheet and it conta 4 problem sets needs to be solved. good luck. 1. (7 points) When asked on a recent survey, the general public believes there are on average μ=50 shark attacks
Construct a two-tailed hypothesis test to see whether or not the public perception of the number of shark attack
Year
# Shark Attacks
1992
40
1993
45
1994
29
1995
28
1996
33
1997
33
1998
35
1999
40
2000
30
2001
38
2002
32
2003
27
2004
35
2005
42
2006
31
H0:
H1:
N:
Mu:
Sample Average:
Sample Variance:
Sample Standard Deviation:
Level of Confidence:
Alpha Level:
t:
t-Alpha/2:
Reject H0? (Yes or no):
Interpretation:
believes there are on average μ=50 shark attacks in U.S. costal waters each year.
he public perception of the number of shark attacks is skewed.
Type Answers in the Spaces Below
When finished, go on to problem 2 in the sheet tab below that says “Problem 2”
2. (7 points) Suppose that the number of parking tickets given out each week by officers in the city of Hamptonv
Below is the parking ticket data from the overnight shift officers.
Do the overnight shift officers give out significantly fewer tickets than the average officer in Hamptonville?
Officer
Number of tickets
Jordan
23
Pippin
33
Cartwright
3
Kerr
12
Paxton
13
Livingston
9
Kukoc
7
Harper
8
Wennington
12
Longley
15
Rodman
19
Buechler
11
Brown
21
Caffey
4
Simpkins
16
Salley
22
Edwards
0
Haley
14
H0:
H1:
N:
Mu:
Sample Average:
Sample Variance:
Sample Standard Deviation:
Level of Confidence:
Alpha Level:
t:
t-Alpha:
Reject H0? (Yes or no):
Interpretation:
h week by officers in the city of Hamptonville is μ=21.
the average officer in Hamptonville?
Type Answers in the Spaces Below
When finished, go on to problem 3 in the sheet tab below that says “Problem 3”
3. (8 points) Twelve of your co-workers were subjected to an intense 4-day training seminar on job performance
Compare the number of claims processed each week by your co-workers before and after the training.
Did the training make a statistical difference in the number of claims processed by your co-workers?
Employee #
Claims before
training
Claims after
training
1
58
61
2
43
45
3
60
64
4
49
53
5
68
67
6
41
51
7
58
68
8
72
79
9
30
47
10
42
45
11
52
52
12
61
66
d = x1 – x2
ining seminar on job performance.
e and after the training.
d by your co-workers?
H0:
H1:
N:
Mu of d:
Sample Average of d:
Sample Variance of d:
Sample Standard Deviation of d:
Level of Confidence:
Alpha Level:
t:
t-Alpha/2:
Reject H0? (Yes or no):
Interpretation:
Type Answers in the Spaces Below
When finished, go on to problem 4 in the sheet tab below that says “Problem 4”
4. (8 points) Suppose that students are preparing to take a standardized test, and in the process of doing so they
All of the following students took the practice exam once before taking the test-prep course, and then they took
Did the test-prep course lead students to perform better?
Student
Score before testprep course
Score after testprep course
Lisa
91
97
Bart
42
40
Maggie
76
78
Homer
51
60
Marge
87
88
Moe
90
93
Milhouse
68
78
Nelson
80
77
Ned
88
94
Edna
92
94
d = x1 – x2
and in the process of doing so they are allowed to take a practice exam twice.
st-prep course, and then they took the practice exam after taking the test-prep course.
H0:
H1:
N:
Mu of d:
Sample Average of d:
Sample Variance of d:
Sample Standard Deviation of d:
Level of Confidence:
Alpha Level:
t:
t-Alpha:
Reject H0? (Yes or no):
Interpretation:
are allowed to take a practice exam twice.
the practice exam after taking the test-prep course.
Type Answers in the Spaces Below
Please save your file and upload it into the D2L Assignment Dropbox.

Purchase answer to see full
attachment