Purchase Solution

Three regression analyses using Excel

Not what you're looking for?

Ask Custom Question

Please use Excel as your processing tool to work through three simple regression analyses, using the attached Data Set.

1. First run a regression analysis using the BENEFITS column of all data points in the attached data set as the independent variable and the INTRINSIC job satisfaction column of all data points in the attached data set as the dependent variable.

a. Create a graph with the trendline displayed. (an x y scatterplot showing trendline)
b. What is the least squares regression line equation? What are the slope and the y-intercept?
c. What is the R-squared value?

2. Next, run a regression analysis using the BENEFITS column of all data points in the attached data set as the independent variable and the EXTRINSIC job satisfaction column of all data points in the attached data set as the dependent variable.

a. Create a graph with the trendline displayed. ( An x y scatterplot showing trendline.)
b. What is the least squares regression line equation?
c. What are the slope and the y-intercept?
d. What is the R-squared value?

3. Next, run a regression analysis using the BENEFITS column of all data points in the attached data set as the independent variable and the OVERALL JOB SATISFACTION column of all data points in the attached data set as the dependent variable.

a. Create a graph with the trendline displayed. (an x y scatterplot showing trendline)
b. What is the least squares regression line equation?
c. What are the slope and the y-intercept?
d. What is the R-squared value?

4. Finally, make very specific comments and give reasons regarding any similarities or differences in the output results.

a. Which regression produces the strongest correlation coefficient result? Why?

Additional instructions:

In the first three parts you will do three regression lines, that are INTRINSIC = b * BENEFITS + a, EXTRINSIC = b * BENEFITS + a, and OVERALL = b * BENEFITS + a.

Please use all 29 data rows of the three columns, no samples no extra numbers, and no partitioning!

Please be sure to present three regression equations with R-squared value and three graphs.

Provide the following summary table.
a b R2
1)
2)
3)

Write this as a coherent integrated report with an introduction, description of methods, results, interpretation of results, and conclusion.

Thank you!

Purchase this Solution

Solution Summary

This solution shows the excel ouput tables along with explanations for three regression analyses.

Purchase this Solution


Free BrainMass Quizzes
Terms and Definitions for Statistics

This quiz covers basic terms and definitions of statistics.

Measures of Central Tendency

This quiz evaluates the students understanding of the measures of central tendency seen in statistics. This quiz is specifically designed to incorporate the measures of central tendency as they relate to psychological research.

Measures of Central Tendency

Tests knowledge of the three main measures of central tendency, including some simple calculation questions.

Know Your Statistical Concepts

Each question is a choice-summary multiple choice question that presents you with a statistical concept and then 4 numbered statements. You must decide which (if any) of the numbered statements is/are true as they relate to the statistical concept.