ECON7300: Statistical Project Assignment (Part IIIa), Semester 1, 2023
Hello, dear friend, you can consult us at any time if you have any questions, add WeChat: daixieit
ECON7300: Statistical Project Assignment (Part IIIa), Semester 1, 2023
Instruction:
(A) Questions in this paper should be answered by students whose surnames fall within the range G-M.
(B) Use the Excel file ‘Dataset2_part3a to answer the questions asked.
(C) A heavy penalty will be applied if your answers are not based on dataset assigned to you.
Instructions for Dataset2_part3a: Multiple Regression Analysis
Absenteeism is a series employment problem in most countries. An economist launched a research project to learn more about the problem. She randomly selected 45 organisations to participate in a one year study. For each organisation, she recorded the average number of days absent, average employee wage and availability of shift work,
and saved the data in Dataset2_part3a.
The variables saved in Dataset2_part3a are:
• ada (Y, average number of days absent per employee)
• awage (X1, average employee wage in $)
• asw (X2, availability of shift work, coded 1 if yes and 0 if no)
The dependent variable for your analysis is ada.
Answer the following questions using Dataset2_part3a.
(a) Estimate a regression model using X1 and X2 to predict Y (state the multiple regression equation).
(b) Interpret the meaning of the slope of Y with X2.
(c) What are the estimated values of the intercept when X2 = 0 and X2 = 1?
(d) At the 5% level of significance, test whether the intercepts differ by availability of shift work. Follow all the necessary steps and use t-test.
(e) Estimate a regression model using X1, X2 and an interaction between X1 and X2 to predict Y (state the multiple regression equation).
(f) Interpret the meaning of the slope Y with the interaction term.
(g) At the 5% level of significance, test whether the slope of Y with X1 differs by availability of shiftwork. Follow all the necessary steps and use t-test.
2023-05-06