A B D E F G H J M N 0 Question 5 (20 points): 1 2 3 The "Question 5" tab in the Excel spreadsheet has data on the salaries from a sample of Halifax public sector employees. (a) (5 points) At the 90% level of confidence, test the hypothesis that the average salary of male public sector employees in Halifax is $100,000. Explain your conclusion. 4 5 6 7 8 9 9 10 11 12 13 14 15 16 17 18 (b) (5 points) Construct a 90% confidence interval for the average salary of male public sector employees in Halifax. Are your results consistent with part (a) above? ) 19 20 21 22 23 24 25 26 27 28 29 30 Annual salary (s thousands) FEMALES MALES 98.1 96.3 89.7 92.1 93.6 101.1 106.5 105.9 90.6 92.1 97.2 95.1 75.1 98.4 116.7 115.5 113.6 121.5 76.5 75.9 84.0 85.8 105.3 107.4 101.3 118.4 88.8 98.4 98.2 100.1 100.7 103.5 93.6 91.5 105.0 105.3 102.6 107.1 97.2 94.5 92.3 103.2 104.4 102.6 106.1 118.8 79.6 122.9 121.2 102.9 118.1 104.6 81.0 108.0 88.5 96.0 109.8 109.8 105.8 111.6 93.3 99.0 102.7 107.7 105.2 107.1 98.1 123.3 109.5 127.4 107.1 107.4 101.7 109.1 96.8 112.5 108.9 100.5 110.6 114.3 84.1 116.1 125.7 103.5 122.6 112.2 85.5 111.6 93.0 127.8 114.3 131.9 110.3 111.9 97.8 113.6 107.2 117.0 (c) (10 points) Your friend looks at this data and concludes that there is a gender pay gab for public sector employees in Halifax. How would you respond based on the information available here? 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 97.8 107.2 109.7 102.6 114.0 111.6 106.2 101.3 113.4 115.1 88.6) 130.2 127.1 90.0 97.5 85.3 94.7 97.2 90.1 101.5 99.1 93.7 88.8) 100.9 105.8 117.9 119.6 93.1 134.7 131.6 94.5 102.0 98.2 93.3 105.4| 110.3 122.4 124.1 97.6) 113.6) 117.0 105.0) 118.8 120.6 108.0) 116.7 116.1 132.3 136.4 116.4 118.1 121.5 109.5 123.3 100.0 108.7 108.1 124.3 128.4 108.4 110.1 113.5 101.5 114.0 127.8 104.5 113.2 112.6 128.8 132.9 112.9 105.6 113.2 112.6 128.8 132.9 112.9 114.6 74 75 76 77 78 79 80 81 |82 83 84 85 86 |87 88