Question: The data in the tab labeled 'Problem 3' are ACT scores from 2011 and 2016.ACT scores are normally distributed. Use Excel to perform the appropriate
The data in the tab labeled 'Problem 3' are ACT scores from 2011 and 2016.ACT scores are normally distributed. Use Excel to perform the appropriate hypothesis test to see if ACT scores have changed from 2011 to 2016.
alpha= 0.05
One Tail or Two?
Test Statistic =
p-value =
Decision =
Have ACT Scores Changed?
Data:
2011 2016
27 32
19 24
19 19
31 23
22 18
26 34
18 20
18 32
18 29
25 27
26 20
15 18
17 28
30 25
21 27
31 31
19 16
31 18
20 26
19 30
27 30
23 34
22 27
16 26
16 20
28 19
30 32
25 21
27 23
21 23
22 29
29 20
27 16
20 35
25 17
16 28
22 24
15 20
18 22
18 29
29 26
24 27
17 19
18 35
24 35
29 34
16 34
24 29
16 16
18 28
31 24
16 27
24 17
27 34
28 33
29 25
31 34
27 19
18 16
19 21
31 20
23 21
19 27
32 20
18 25
15 20
17 24
27 18
31 20
19 29
26 35
31 29
21 21
28 32
16 30
24 16
28 29
25 18
28 19
31 35
21 19
20 36
16 19
17 36
25 20
31 19
31 28
21 28
26 36
32 23
21 28
21 32
24 23
15 18
24 16
15 30
19 36
22 26
22 21
17 17
24 32
26 26
19 36
23 30
18 19
20 16
28 17
23 21
30 18
32 33
22 23
15 21
32 24
20 21
20 29
16 16
19 24
29 34
15 35
19 27
16 36
21 36
22 21
19 22
24 22
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
Study Help