# Regression Analysis for Job Satisfaction Survey Data

Using the data set below complete the following:

TEST #1: Regression Analysis - Benefits & Intrinsic

Perform the following Regression Analysis, using a .05 significance level.

Run a regression analysis using the BENEFITS column of all data points in the AIU data set as the independent variable. and the INTRINSIC job satisfaction column of all data points in the AIU data set as the dependent variable.

Copy and paste the results of the output to your report in Microsoft Word.

Create a graph with the trendline displayed the 3 regression.

Copy and paste the results of the output to your report in Microsoft Word.

TEST #2: Regression Analysis - Benefits & Extrinsic

Perform the following Regression Analysis, using a .05 significance level.

Run a regression analysis using the BENEFITS column of all data points in the AIU data set as the independent variable. and the EXTRINSIC job satisfaction column of all data points in the AIU data set as the dependent variable.

Copy and paste the results of the output to your report in Microsoft Word.

Create a graph with the trendline displayed for the regression.

Copy and paste the results of the output to your report in Microsoft Word.

TEST #3: Regression Analysis - Benefits & Overall Job Satisfaction

Perform the following Regression Analysis, using a .05 significance level.

Run a regression analysis using the BENEFITS column of all data points in the AIU data set as the independent variable. and the OVERALL job satisfaction column of all data points in the AIU data set as the dependent variable.

Copy and paste the results of the output to your report in Microsoft Word.

Create a graph with the trendline displayed for the regression.

Copy and paste the results of the output to your report in Microsoft Word.

Overview of the Regressions

Complete the table with the following information:

Dependent Variable Slope Y-intercept Equation

Intrinsic

Extrinsic

Overall

State the slope and the y-intercept for the three regressions.

State the least squares regression line equations for the threes regressions.

State the R-squared value for each of the regressions.

Analysis of the Regressions:

Identify at least one similarity and one difference from the regression output or graphs above.

Identify the strongest correlation coefficient between the three outputs above and explain why that is the strongest. Be sure to relate this to the practical application why in the real world sense do you believe these variables have the strongest relationship.

Give a short summary of the above.

Data Set to use for assignment

Gender Age Department Position Tenure Job Satisfaction Intrinsic Extrinsic Benefits

2 1 3 2 3 5.2 5.5 6.8 1.4

1 1 1 1 3 5.5 5.5 5.5 5.4

2 3 1 1 1 4.9 5.2 4.6 6.2

1 1 2 2 1 5.5 5.3 5.7 2.3

1 1 2 1 1 5.2 4.7 5.6 4.5

1 2 2 1 1 5.5 5.5 5.5 5.4

1 3 1 1 1 4.9 5.2 4.6 6.2

1 2 1 1 1 3.9 2.1 5.7 2.3

2 2 2 1 2 5.2 4.7 5.6 4.5

1 2 2 1 2 5.5 5.4 5.6 5.4

1 2 2 2 2 5.9 6.2 5.5 6.2

1 2 1 1 1 4.9 5.2 4.6 6.2

1 3 1 2 2 5.5 5.3 5.7 2.3

2 2 2 1 1 5.2 4.7 5.6 4.5

1 2 2 1 1 5.5 5.4 5.6 5.4

2 2 2 2 3 5.4 6.2 4.6 6.2

1 1 2 2 1 5.5 5.2 5.7 6.2

2 2 2 1 2 5.5 5.3 5.6 5.4

2 3 2 1 2 5.4 5.3 5.5 6.2

2 1 1 1 3 5 5.3 4.6 2.3

1 1 2 1 1 5.2 4.7 5.7 2.3

1 1 2 2 2 5.5 5.3 5.6 4.5

1 3 2 1 1 5.1 4.7 5.5 2.3

1 2 1 2 3 4.9 5.2 4.6 6.2

1 2 1 1 2 5.5 5.3 5.7 2.3

1 3 2 1 2 5.2 4.7 5.6 4.5

1 2 2 1 3 5.5 5.4 5.5 5.4

1 1 3 2 2 5.4 6.2 4.6 6.2

1 2 1 2 1 5.5 5.2 5.7 2.3

1 2 1 2 1 5.5 5.3 5.6 4.5

2 2 2 1 2 5.5 5.4 5.6 5.4

2 3 2 2 2 5.9 6.2 5.5 6.2

2 3 1 1 1 4.9 5.2 4.6 6.2

2 2 2 1 2 5.5 5.3 5.7 2.3

2 2 2 1 2 5.2 4.7 5.6 4.5

2 2 3 2 2 5.5 5.4 5.6 5.4

KEY TO SURVEY

Demographics

Gender

1 Male

2 Female

Age

1 16 - 21

2 22 - 49

3 50 - 65

Department

1 Human Resources

2 Information Technology

3 Administration

Position

1 Hourly Employee (Overtime Eligible)

2 Salaried Employee (No Overtime)

Tenure With Company

1 Less than 2 years

2 2 to 5 years

3 Over 5 Years

Four Survey Measures

SURVEY MEASURE #1 OVERALL JOB SATISFACTION (Scale 1-7)

1 = Least Satisfied

7 = Most Satisfied

SURVEY MEASURE #2 INTRINSIC JOB SATISFACTION (Scale 1-7)

1= Least Satisfied

7= Most Satisfied

SURVEY MEASURE #3 EXTRINSIC JOB SATISFACTION (Scale 1-7)

1 = Least Satisfied

7 = Most Satisfied

SURVEY MEASURE #4 BENEFITS (Scale 1-7)

1= Least Satisfied

7= Most Satisfied

#### Solution Summary

The solution provides an Excel attachment and a Word attachment, which analyzes the information and dictates the correlational coefficients.