USA: +1(669)289-8683
USA: +1(669)289-8683

BUSIN QUANTATITIVE 5

TEST #1: Regression Analysis- Benefits &

Save Time On Research and Writing
Hire a Pro to Write You a 100% Plagiarism-Free Paper.
Get My Paper

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 &

Save Time On Research and Writing
Hire a Pro to Write You a 100% Plagiarism-Free Paper.
Get My Paper

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

Make very specific comments and give reasons regarding any similarities or differences in the output results.

Which regression produces the strongest correlation coefficient result? Why? What does it mean to a manager?

The report should be well written and should flow well with no grammatical errors. It should include proper citation in APA formatting in both the in-text and reference pages and include a title page, be double-spaced, and in Times New Roman, 12-point font. APA formatting is necessary to ensure academic honesty.

Running head: BUSN311 – Quantitative Methods and Analysis
1

Unit 5 – Regression Analysis

Type your Name Here

American InterContinental University

Abstract

This is a single paragraph, no indentation is required. The next page will be an abstract; “a brief, comprehensive summary of the contents of the article; it allows the readers to survey the contents of an article quickly” (Publication Manual, 2010). The length of this abstract should be 35-50 words (2-3 sentences). NOTE: the abstract must be on page 2 and the body of the paper will begin on page 3.

Introduction

Remember to always indent the first line of a paragraph (use the tab key). The introduction should be short (2-3 sentences). The margins, font size, spacing, and font type (italics or plain) are set in APA format. While you may change the names of the headings and subheadings, do not change the font or style of font.

Benefits and Intrinsic Job Satisfaction

Regression output from Excel

Copy and paste the results of the regression analysis from Excel using Intrinsic as the dependent variable and Benefits as the independent variable here:

Graph

Copy and paste the graph including the trend line. Be sure that you have labeled your graph correctly.

Benefits and Extrinsic Job Satisfaction

Regression output from Excel

Copy and paste the results of the regression analysis from Excel using Extrinsic as the dependent variable and Benefits as the independent variable here:

Graph

Copy and paste the graph including the trend line. Be sure that you have labeled your graph correctly.

Benefits and Overall Job Satisfaction

Regression output from Excel

Copy and paste the results of the regression analysis from Excel using Overall Job Satisfaction as the dependent variable and Benefits as the independent variable here:

Graph

Copy and paste the graph including the trend line. Be sure that you have labeled your graph correctly.

Key components of the regression analysis

Complete the following chart to identify key components of each regression output.

Dependent Variable

Slope

Y-intercept

Equation

Intrinsic

Extrinsic

Overall

Similarities and Differences

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

Correlation coefficients

Identify the strongest correlation coefficient between the three outputs above and explain why that is the strongest. What does it mean to a manager?

Conclusion

Add some concluding remarks in about 2-3 sentences.

References

NOTE: The reference list starts on a new page after your conclusion.

For help with formatting citations and references using rules outlined in the APA Manual’s 6th Edition, please check out the AIU APA guide located under the Interactive Learning section on the left side of the course.

Examples:

American Psychological Association [APA]. (2010) Publication manual of the American

Psychological association (6th ed.). Washington, DC: Author.

Association of Legal Writing Directors (ALWD) (2005). ALWD citation manual: A professional

system of citation (3rd ed.). New York: Aspen Publishers.

2

>SURVEY

1 1 1

1 3 3 1 1 4.9

1 1 2 2 1 4.9

1 1 3 1 1 5.2

1 3 3 1 1 4.9 5.2 4.6 4.2
1 2 2 1 1 5.2 4.7 5.6 4.5 Gender
1 2 1 1 2 5.2 4.7 5.6 4.5 1

1 3 3 1 2 4.9 5.4 5.6 5.4 2

1 2 2 1 3

5.5 4.2 Age

1 1 3 2 1 4.9 5.2 4.6 4.2 1

1 1 1 1 3

6.4 5.5

2

1 3 3 1 1 4.9 5.2 4.6 4.2 3

1 1 2 2 1 4.9 5.3 5.7 2.3

1 1 3 1 3 5.2 4.7 5.6 4.5 1

1 2 2 1 3 4.9 6.4 5.5 5.4 2

1 3 3 1 1 4.9 5.2 4.6 4.2 3

1 2 2 1 1 5.2 4.7 5.6 4.5 Position
1 2 2 1 3 4.9 5.4 5.6 5.4 1

1 1 1 1 3 3.2 6.4 4.6 4.2 2

1 2 1 1 2 5.2 4.7 5.6 4.5

1 3 3 1 1 4.9 5.2 5.7 4.2 1

1 1 1 1 2 4.9 5.3 5.6 5.4 2

1 1 1 1 2 4.9 5.3 5.6 5.4 3

1 1 1 1 3 4.9 6.4 5.5 5.4

1 3 3 1 1 4.9 5.2 4.6 4.2

1 1 2 2 1 4.9 5.2 4.6 4.2
1 1 3 1 1 5.2 6.4 5.5 3.5

1 3 3 1 1 4.9 5.2 4.6 4.2

1 2 2 1 1 5.2 5.3 5.7 2.3

1 2 1 1 2 5.2 4.7 5.6 4.5

1 3 3 1 2 4.9 6.4 5.5 5.4

1 2 2 1 3 5.9 5.2 4.6 4.2

1 1 3 2 1 4.9 4.7 5.6 4.5

1 1 1 1 3 3.2 5.4 5.6 5.4 1 = Least Satisfied
1 3 3 1 1 4.9 6.4 4.6 4.2 7 = Most Satisfied
1 1 3 2 1 4.9 4.7 5.6 4.5

1 1 3 1 3 5.2 5.2 5.7 4.2 1= Least Satisfied
1 2 3 1 3 4.9 5.2 4.6 4.2 7= Most Satisfied
1 3 2 1 1 4.9 6.4 5.5 3.5
1 2 2 1 1 5.2 4.7 5.6 4.5
1 2 2 2 3 4.9 5.4 5.6 5.4
1 1 3 2 3 4.9 5.2 4.6 4.2
1 2 2 1 2 5.2 6.4 5.5 3.5

1 3 3 1 1 4.9 5.2 4.6 4.2

1 1 1 1 2 5.2 5.3 5.7 2.3
1 3 2 1 1 5.2 4.7 5.6 4.5
1 1 3 1 2 4.9 6.4 5.5 5.4
1 2 1 2 3 5.9 5.2 4.6 4.2
1 2 1 1 1 4.9 4.7 5.6 4.5
1 1 1 2 3 4.9 6.4 5.5 5.4

1 3 3 1 1 4.9 5.2 4.6 4.2
1 1 2 2 1 4.9 5.3 5.7 2.3
1 3 3 1 1 4.9 5.2 4.6 4.2
1 2 2 1 1 5.2 4.7 5.6 4.5

1 2 2 1 3 4.9 5.4 5.6 5.4
1 1 1 1 3 3.2 6.4 4.6 4.2
1 2 1 2 2 5.2 4.7 5.6 4.5
1 2 2 1 3 4.9 6.4 5.5 5.4

1 3 3 1 1 4.9 5.2 4.6 4.2
1 2 2 1 1 5.2 4.7 5.6 4.5
1 2 2 1 3 4.9 5.4 5.6 5.4
1 1 1 1 3 3.2 6.4 4.6 4.2

1 1 3 1 1 5.2 4.7 5.6 4.5
1 3 3 2 1 4.9 5.2 4.6 4.2

1 2 2 1 1 5.2 4.7 5.6 4.5

1 2 3 2 3 4.9 4.7 5.5 5.4
1 2 2 2 1 3.2 5.4 4.6 4.2
1 2 2 1 1 4.9 6.4 5.4 4.5

1 1 2 2 1 4.9 5.3 5.7 2.3
1 1 3 1 1 5.2 4.7 5.6 4.5
1 3 3 1 1 4.9 5.2 4.6 4.2
1 2 2 1 1 5.2 4.7 5.6 4.5

1 2 1 1 2 5.2 4.7 5.6 4.5
1 3 3 1 2 4.9 5.4 5.6 5.4
1 2 2 1 3 5.9 3.7 5.5 4.2
1 1 3 2 1 4.9 5.2 4.6 4.2
1 1 1 1 3 3.2 6.4 5.5 3.5

1 3 3 1 1 4.9 5.2 4.6 4.2
1 1 2 2 1 4.9 5.3 5.7 2.3

1 1 3 1 3 5.2 4.7 5.6 4.5

1 2 2 1 3 4.9 6.4 5.5 5.4
1 3 3 1 1 4.9 5.2 4.6 4.2
1 2 2 1 1 5.2 4.7 5.6 4.5
1 2 2 1 3 4.9 5.4 5.6 5.4
1 1 1 1 3 3.2 6.4 4.6 4.2
1 2 1 1 2 5.2 4.7 5.6 4.5

1 3 3 1 1 4.9 5.2 5.7 4.2

1 1 3 2 1 4.9 5.2 4.6 4.2
1 1 1 1 3 3.2 6.4 5.5 3.5
1 3 3 1 1 4.9 5.2 4.6 4.2
1 1 2 2 1 4.9 5.3 5.7 2.3
1 1 1 1 3 3.2 6.4 5.5 3.5
1 3 3 1 1 4.9 5.2 4.6 4.2
1 1 2 2 1 4.9 5.3 5.7 2.3
1 1 3 1 3 5.2 4.7 5.6 4.5

2 2 2 1 3 4.9 6.4 5.5 5.4
2 3 3 1 1 4.9 5.2 4.6 4.2
2 2 2 1 1 5.2 4.7 5.6 4.5
2 2 2 1 3 4.9 5.4 5.6 5.4
2 1 1 1 3 3.2 6.4 4.6 4.2
2 2 1 1 2 5.2 4.7 5.6 4.5
2 3 3 1 1 4.9 5.2 5.7 4.2
2 1 3 2 1 4.9 5.2 4.6 4.2
2 1 1 1 3 3.2 6.4 5.5 3.5

2 2 2 1 1 5.2 4.7 5.6 4.5
2 2 2 1 3 4.9 5.4 5.6 5.4
2 1 1 1 3 3.2 6.4 4.6 4.2
2 2 1 1 2 5.2 4.7 5.6 4.5
2 3 3 1 1 4.9 5.2 5.7 4.2
2 1 3 2 1 4.9 5.2 4.6 4.2
2 1 1 1 3 3.2 6.4 5.5 3.5
2 3 3 1 1 4.9 5.2 4.6 4.2

2 1 2 2 1 4.9 5.3 5.7 2.3

2 1 1 1 3 3.2 6.4 5.5 3.5
2 3 3 1 1 4.9 5.2 4.6 4.2
2 1 2 2 1 4.9 5.3 5.7 2.3

2 1 3 1 3 5.2 4.7 5.6 4.5

2 2 2 1 3 4.9 6.4 5.5 5.4
2 3 3 1 1 4.9 5.2 4.6 4.2
2 2 2 1 1 5.2 4.7 5.6 4.5

2 1 3 2 3

4.7 5.7

2 3 3 2 1

6.4

3.5

2 2 2 2 1 3.1 5.2 3.1 3.7
2 2 2 2 3 4.5 5.3 2.3 4.2
2 1 1 1 3 5.1 5.2

2 2 1 1 1 5.7 4.7

2 2 1 1 1 5.1 5.4

2 3 2 1 1 3.1 6.4

2.5

2 2 2 2 3 2.3 4.7

3.1

2 2 2 2 1 2.8 6.4

5.5

2 1 2 2 1 6.9 5.2 6.9 5.7
2 1 2 2 1 6.8 4.7 6.8

2 3 3 1 1 2.2 5.4 2.2 4.6
2 2 3 1 1 3.4 6.4 3.4 2.2
2 2 3 1 1 6.5 4.7 6.5 2.5
2 2 3 1 2 4.8 5.2 5.5

2 2 3 1 2

4.7

2.8

2 1 1 1 3 5.2 4.7 3.5

2 1 1 2 1 3.4 5.4 6.9 5.4
2 3 1 2 3 5.7 6.4 5.5 3.1
2 2 1 2 1 5.1 5.3 5.2 2.5
2 2 1 2 1 3.1 2.3 5.7 3.8
2 3 1 2 3 2.3 4.5 5.5 3.4
2 2 2 2 3 2.8 5.4 2.8

2 1 2 2 1 6.9 4.2 3.4 2.5
2 1 2 2 1 6.8 4.5

2 3 2 2 3 2.2 3.1 2.2 6.8
2 1 2 1 3 3.4 3.5 5.4 6.5
2 1 3 1 2 6.5 3.7 2.3 6.5
2 1 3 1 1 4.8 4.2 2.5 6.6
2 2 3 1 1 3.8 5.8 2.1 6.8
2 3 3 1 3 5.2 6.7 4.5 4.5
2 3 3 1 3 3.4 2.1

4.2

2 2 3 1 2 5.5 2.5 4.8

2 1 1 1 3 2.4 3.1 4.7 4.8
2 1 1 1 2 3.5 5.5 5.4 2.8
2 2 1 1 2 6.9 5.7 2.9 2.9
2 3 1 2 1 5.5 4.8 5.5 5.4
2 3 2 2 1 5.2 4.6 3.9 3.1
2 3 2 2 3 5.7 4.7 5.8 2.5
2 2 2 2 3 5.5 5.2 5.2 3.8
2 1 2 2 1 2.8 4.7 5.8 3.4
2 2 2 2 2 3.4 4.7 5.9 3.6
2 3 2 2 2 3.9 5.4 6.4 2.5
2 3 1 2 1 4.8 3.7 5.7 6.6
2 1 1 2 1 3.8 5.2 5.8 6.8
2 2 1 2 3 5.2 6.4 5.6 6.5
2 3 1 2 3 3.4 5.2 5.4 6.5
2 3 2 1 1 5.7 5.3 5.4 6.6
2 2 2 1 3 5.1 4.7 2.3 6.8
2 2 2 1 2 3.1 6.4 2.5 4.5
2 1 2 1 1 2.3 5.2 2.1 4.2
2 1 2 1 3 2.8 4.7 4.5 4.3
2 1 2 1 2 6.9 5.4 4.1 4.8
2 1 1 1 3 6.8 6.4 4.8 4.7
2 1 2 1 2 2.2 4.7 4.7 4.7
2 1 1 1 3 3.4 5.2 5.4 5.4
2 2 2 1 2 6.5 5.3 2.9 3.7
2 2 1 1 3 4.8 5.3 5.5 5.2
2 2 2 1 3 3.8 6.4 3.9 6.4
2 2 1 1 2 5.2 5.2 5.8 5.2
2 2 2 1 2 3.4 5.2 5.2 5.3
2 3 1 1 1 5.5 6.4 5.8 4.7
2 3 2 1 1 2.4 5.2 5.9 6.4
2 3 3 1 1 3.5 5.3 6.4 5.2
2 3 3 1 2 6.9 4.7 5.7 4.7
2 3 3 1 2 5.5 6.4 5.8 5.4
2 3 3 1 2 5.2 5.2 5.6 6.4
2 3 3 1 2 5.7

5.4 4.7

2 1 3 1 2 5.5 2.4 2.3 5.2
Gender Age Department Position Tenure Job Satisfaction Intrinsic Extrinsic Benefits
1 3 4.9 6.4 5.5 5.4
5.2 4.6 4.2 KEY TO SURVEY
5.3 5.7 2.3
4.7 5.6 4.5 Demographics
Male
Female
5.9 3.7
16 – 21
3.2 3.5 22 – 49
50 – 65
Department
Human Resources
Information Technology
Administration
Hourly Employee (Overtime Eligible)
Salaried Employee (No Overtime)
Tenure With Company
Less than 2 years
2 to 5 years
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)
SURVEY MEASURE #4 BENEFITS (Scale 1-7)
1.3 3.1
2.5 5.1
2.8 5.8
6.9 6.7
6.8 2.1
2.2
3.4
6.5
4.8
2.6
3.8 2.4
2.9
3.6
3.9 6.6
4.1
4.3
1.2

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

Make very specific comments and give reasons regarding any similarities or differences in the output results.

Which regression produces the strongest correlation coefficient result? Why? What does it mean to a manager?

The report should be well written and should flow well with no grammatical errors. It should include proper citation in APA formatting in both the in-text and reference pages and include a title page, be double-spaced, and in Times New Roman, 12-point font. APA formatting is necessary to ensure academic honesty.

NEED HELP?

Still stressed from student homework?
Get quality assistance from academic writers!
Order now

Order your essay today and save 25% with the discount code LAVENDER

Order Now