Assignment Question
In this report, you will conduct linear regression analysis. The overall aim of this project is to conduct linear regression analysis. The specific objectives are to conduct a proper linear regression analysis. To use software for linear regression calculations. To interpret the results of the linear regression analysis. To describe the above in a report. Salary Data (Salary_Data.xlsx) is attached. The data set contains 81 observations with four independent variables (Work_experience, Education, Age, Sex), and one dependent variable (Salary). For independent variable sex: 0 = Male; 1 = female. Steps: For the data set with one response variable and four predictor variables:
1.Show scatter plot for Salary vs. all independent variables.
2.Show ANOVA table.
3.Discuss R-squared value.
4.Check model assumptions (model form, constant variance, normality, and uncorrelated errors if relevant.)
5.Check if the slope and parameters are statistically significant or not. p-value Test document attached.
6.For a future observation, calculate salary for a female with work experience = 3.2 years; Education level = 18; Age = 32. 7.Write a general discussion about your model.
