multiple regression on the "employee retention" spreadsheet.

You will need to copy to a separate spreadsheet and format, so numbers are clearly visible and correctly formatted.

Make Years PLE as the dependent variable and assess independent variable at 95% confidence and confirm for each variable they are explanatory in terms of dependent variable. The independent variables are: YrsEducation, College GPA, Age, Gender, College Grad and Local.

Note some of the independent variables are categories you needto translate to a numeric scale.

It is important that show the working within the separate spreadsheet i.e. ANOVA analysis testing Hypothesis of Influence at 95% confidence level,you use may use t-stat and p-stats also.

You are required to postulate hypothesis at 95% confidence level.

Formulate the multiple regression formula correctly and provide relevant statistics. Explain what the statistics mean.

https://docs.google.com/spreadsheets/d/1F-94uOh2jZr6HXapqTPOF4Jno5JsLh2UsefbziwtGbk/edit?usp=sharing