Regression Analysis Report-Conduct linear regression analysis-Discuss R-squared value.

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.