Employee ID	Department	Years	Ideas	Communication	Recognition	Training	Work Conditions	Tools and Information	Work/Life Balance	Satisfaction
1	Management	1	5	4	4	3	5	3	5	9
2	Administrative	16	2	3	2	2	4	5	2	3
3	Production	16	2	3	2	4	4	4	2	5
4	Production	15	2	3	1	4	4	4	2	4
5	Quality Control	1	5	5	5	5	5	5	5	10
6	Maintenance	17	5	4	3	5	5	5	3	8
7	Maintenance	15	5	5	5	5	5	5	5	9
8	Production	13	3	3	3	4	4	4	3	8
9	Quality Control	11	3	4	4	4	5	5	2	7
10	Production	3	5	5	5	5	5	5	5	10
11	Production	6	2	2	1	3	3	4	2	4
12	Production	1	5	4	4	3	4	5	5	9
13	Production	3	3	4	3	4	5	5	4	7
14	Production	2	4	4	4	4	5	5	5	8
15	Production	3	3	4	3	3	2	4	4	6
16	Shipping / Receiving	21	3	2	2	3	2	4	3	5
17	Production	2	4	3	4	3	3	4	4	6
18	Production	2	4	5	4	4	4	4	4	8
19	Production	15	5	4	3	4	3	5	3	7
20	Management	3	3	4	3	3	4	5	5	8
21	Production	5	4	5	3	2	3	5	4	7
22	Shipping / Receiving	8	3	2	2	2	2	4	2	4
23	Management	3	2	2	2	2	3	5	3	3
24	Administrative	2	4	4	3	4	4	5	3	9
25	Production	8	5	5	3	5	3	5	3	8
26	Shipping / Receiving	32	2	3	2	4	2	5	3	5
27	Production	17	4	3	4	3	3	5	2	6
28	Shipping / Receiving	2	5	5	5	5	5	5	5	10
29	Production	15	5	3	4	5	5	5	5	9
30	Production	5	2	4	2	2	2	5	3	3
31	Administrative	14	4	3	2	2	5	5	5	6
32	Shipping / Receiving	18	4	4	4	5	5	5	5	8

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

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).

5. All your answers should be put in one Word or PDF file