The current no-smoking regulations in office buildings require workers who smoke to take breaks and leave the building in order to satisfy their habits. A study indicates that such workers average 32 minutes per day taking smoking breaks. The standard deviation is 8 minutes. To help reduce the average break, rooms with powerful exhausts were installed in the buildings. To see whether these rooms serve their designed purpose, a random sample of 110 smokers was taken. The total amount of time away from their desks was measured for 1 day. Test to determine whether there has been a decrease in the mean time away from their desks. Compute the p-value and interpret it relative to the costs of Type I and Type II errors. Use a 5% significance level for all tests. ONLY USE EXCEL AND PLEASE SHOW ALL STEPS AND EXCEL COMMANDS. Minutes 28 24 37 32 34 32 31 34 25 23 32 24 23 39 24 40 23 35 31 26 27 36 27 21 25 34 24 33 28 27 38 35 36 28 36 38 34 33 32 30 31 30 30 19 30 24 28 22 30 21 21 28 33 24 39 38 27 35 34 28 18 19 29 31 38 28 33 22 25 49 24 33 21 38 31 32 26 31 33 30 32 31 31 31 39 34 39 28 32 36 30 29 29 27 24 34 26 20 32 32 34 25 21 32 37 28 25 22 41 28
The current no-smoking regulations in office buildings require workers who smoke to take breaks and leave the building in order to satisfy their habits. A study indicates that such workers average 32 minutes per day taking smoking breaks. The standard deviation is 8 minutes. To help reduce the average break, rooms with powerful exhausts were installed in the buildings. To see whether these rooms serve their designed purpose, a random sample of 110 smokers was taken. The total amount of time away from their desks was measured for 1 day. Test to determine whether there has been a decrease in the mean time away from their desks. Compute the p-value and interpret it relative to the costs of Type I and Type II errors. Use a 5% significance level for all tests. ONLY USE EXCEL AND PLEASE SHOW ALL STEPS AND EXCEL COMMANDS.
Minutes |
28 |
24 |
37 |
32 |
34 |
32 |
31 |
34 |
25 |
23 |
32 |
24 |
23 |
39 |
24 |
40 |
23 |
35 |
31 |
26 |
27 |
36 |
27 |
21 |
25 |
34 |
24 |
33 |
28 |
27 |
38 |
35 |
36 |
28 |
36 |
38 |
34 |
33 |
32 |
30 |
31 |
30 |
30 |
19 |
30 |
24 |
28 |
22 |
30 |
21 |
21 |
28 |
33 |
24 |
39 |
38 |
27 |
35 |
34 |
28 |
18 |
19 |
29 |
31 |
38 |
28 |
33 |
22 |
25 |
49 |
24 |
33 |
21 |
38 |
31 |
32 |
26 |
31 |
33 |
30 |
32 |
31 |
31 |
31 |
39 |
34 |
39 |
28 |
32 |
36 |
30 |
29 |
29 |
27 |
24 |
34 |
26 |
20 |
32 |
32 |
34 |
25 |
21 |
32 |
37 |
28 |
25 |
22 |
41 |
28 |
Step by step
Solved in 2 steps