Southern Textiles wishes to predict employee wages by using the employee's experience X1 and the employee's education X2. Employees are categorized as having a college degree or not having a college degree in their personnel files, so the variable "education" is a qualitative variable. Thus, X2 is an indicator (0, 1) variable.
Data for the employees are given attached.
(a) Copy and paste the data from this document to an Excel file. Select Wages as the dependent variable and experience and education as the independent variables. Conduct multiple regression using Excel. Paste the output report below. Note: Follow the instructions given in module 5 to conduct simple regression. At the step where you specify the input data range, instead of selecting the data for one independent variable, select data for all the independent variables.
(b) Write the equation for the regression output report. If you are using symbols in the equation for the variables, do define the symbols before using the symbols in the equation.
(c) Provide a clear and complete interpretation of the coefficients b1 and b2 in the equation. There is no need to interpret b0. Note: Use actual variable names and numbers in answering your question. b1 and b2 are slopes is not a sufficient answer.
(d) What is the value of R2 for this model? Do you think that the model does a good job of explaining the variation in wages? Why or why not?
(e) Set up the hypotheses to test whether the model is significant. Is the regression model significant at 0.05 as the level of significance? What does this mean?
(f) Set up the hypotheses to test for each of the regression coefficients individually and perform the test at the 0.05 level of significance.
(g) What average wages do you predict for employees with college degrees and experience = 40 months? Interpret your prediction.
Please see the attached files for solutions.
a) See the data in the spreadsheet "sheet 1" of the file: data.xls.
b) From the output, we get the regression equation: Y=0.00749 + 0.485183 X1 + 5.532144 X2.
c) The coefficient b1 =0.485183 means that increasing the experience by 1 month will increase the wage by 0.485183 thousand dollars. The coefficient b2 =5.532144 means that from getting a college degree will increase the wage by 5.532144 thousand dollars.
d) The value of ...
The solution is given in brief as 373 words in the response section and then a further report is attached in a multi-paged Word document that addresses all the question parts together with an Excel spreadsheet.