StartingSalary
68974
63241
65902
65268
67090
70534
71454
66370
65607
68435
68880
67178
68685
68006
68413
68601
66643
69833
67617
66372
64285
68347
67939
64058
65836
68809
68573
66808
68243
68276
71177
66102
71557
70008
68455
67222
71227
67116
63563
70202
64599
67361
71464
67246
69874

The Cadetship Program offers a unique opportunity for Macquarie's Aboriginal and Torres Strait Islander students to gain paid practical work experience relevant to their degree and their chosen field of study. The starting salary ranges between $56, 923 to $80, 000. The Excel file StartingSalary.xlsx contains 45 indigenous graduates' starting salaries, randomly selected from those indigenous students who participated in the program. Use EXCEL and an appropriate hypothesis test to answer the following research question, assuming assumptions are satisfied. Do indigenous students who participated in the Cadeiship Program earn on average $70,962 as their starting salary? 1. (1 mark) What is the sample mean? $ (2dp) 2. (1 mark) What is the sample standard deviation? 3 (de) 3. (1 mark) The most appropriate hypothesis test for these data is c 4. (1 mark) The null hypothesis is that the mean starting salary for indigenous students who participated in this program equals A v (Hint: this is the value of #0 in the H0: ,u. 2 pg) 5. (2 mark) What is the absolute value of the test statistic ? (3d p) 6. (2 mark) Is the pvalue for this test statistic greater or less than 0.05? 0 7. {3 mark) Calculate a 95% confidence interval to estimate the population mean starting salary for indigenous students who participate in this program. The Absolute Value of the Critical Value for a 95% confidence interval is (3dp) Lower Bound = $ {2dp) Upper Bound = $ (2dp) 8. {1 mark) What is the most appropriate conclusion for this test? A. The starting salary for indigenous students who participated in this program is significantly different than the hypothesised value, possibly greater. B. The starting salary for indigenous students who participated in this program is significantly different the hypothesised value, possibly lower. C. The starting salary for indigenous students who participated in this program is not significantly different than the hypothesised value