The data file attached is collected from an employee survey conducted by the HR department of a company. It is designed to understand how employee's satisfactions are influenced by various factors.

Please analyze the data and find the best multiple regression model to predict the overall satisfaction as a function of other variables (except for Department).

Note:

There are two tabs in the Excel file: the raw data and the variable description. Read the variable description to understand the variables.

You need to control for multi-collinearity during your analysis.

Your task:

1. Run linear regressions with a hierarchical approach using SPSS or the software of your choice, and address potential multi-collinearity concerns. (It is suggested to go with the automatic method in SPSS)

2. Attach your regression results (only report the coefficent tables and the adjusted R-square).

3. State which model is the best prediction model.

4. Briefly summarize the managerial conclusions (which factors have influences on satisfaction and what management can do accordingly).

\begin{tabular}{|c|c|c|} \hline Variable Name & Variable Description & Measurement \\ \hline Department & Company Department & Categorical \\ \hline Years & Years of Service & Ratio \\ \hline Ideas & I am able to express ideas for improving my job & \multirow{7}{*}{\begin{tabular}{l} Scale: 1= Strongly Disagree, \\ 2= Disagree, 3= Neutral, 4= Agree, \\ 5= Strongly Agree \end{tabular}} \\ \hline Communication & I have good communication with my supervisor & \\ \hline Recognition & My supervisor recognizes a job well done & \\ \hline Training & I receive the proper training to do my job & \\ \hline Work Conditions & My work conditions are good & \\ \hline Tools and Informatio & \begin{tabular}{l} I have the tools and information needed to do my \\ job well \end{tabular} & \\ \hline Work/Life Balance & \begin{tabular}{l} I have a good balance between work and my \\ personal life \end{tabular} & \\ \hline Satisfaction & Overall Job satisfaction & 1= Low, 10= High \\ \hline \end{tabular}