9.It might reasonably be assumed that income and the results on the test are related to each other. Fully describe the relationship between those two variables. What income would you expect a person who scored a perfect 225 to be earning?

(6 Marks)

10.In developing an overall understand of income payments, each of the factors included in the data set might be considered to have an impact. Conduct a regression analysis to determine the extent to which income can be explained by the other variables as well. Fully describe the results including all necessary tests. Do you believe there is anything in the relationship between the independent variables which may affect these results? Are the results consistent with the other tests you have conducted?

Please share excel file

Table 1: Sample Results Higher Employee Test Income Degree Number Result Gender ($000) (Y=1, N=0) Age GPA 1 163 F 94.1 0 21 3.07 2 148 F 69.4 30 2.82 3 163 M 83.1 1 30 2.89 4 142 F 81.7 0 26 3.02 5 173 F 72.1 O 31 2.98 6 168 F 90.1 0 29 3.02 7 178 M 95.4 O 35 3.04 8 154 M 128.2 49 3.55 LO 155 F 84.4 39 3.35 10 163 F 77.5 O 29 2.9