Purchase Solution

Using Excel for Simple Regression Analyses

Not what you're looking for?

Ask Custom Question

Using Excel as your processing tool, work through three simple regression analyses and use the data from the attached files.

First 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. Create a graph with the trendline displayed. What is the least squares regression line equation? What are the slope and the y-intercept? What is the R-squared value?

Finally, 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?

Attachments
Purchase this Solution
Solution Summary

The first worksheet in the attached Excel file contains a scatterplot and trendline, along with values for the regression equation, slope, y-intercept, and r-squared, for each of the three regression analyses. Included are comments on each of the analyses. A regression analysis can be run 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. A regression analysis can be run 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.

Solution Preview

See the first worksheet in the attached Excel file. It contains a scatterplot and trendline, along with values for the regression equation, slope, y-intercept, and r-squared, for each of the three regression analyses. Below are comments on each of the analyses:

(1) First 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.

The slope is -0.2335, which indicates than an increase by 1 in the BENEFITS score is associated with a decrease by 0.2335 in the INTRINSIC score. The slope is negative, which indicates a negative correlation between the two variables (being more satisfied with benefits is associated with lower intrinsic job satisfaction and vice versa).

The y-intercept is 6.6398, which indicates that a BENEFITS score of 0 is associated with an INTRINSIC score of 6.6398. This means that having no satisfaction with benefits is still associated with a relatively high intrinsic job satisfaction.

R-squared is ...

Purchase this Solution
Free BrainMass Quizzes
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.

Terms and Definitions for Statistics

This quiz covers basic terms and definitions of statistics.

View More Free Quizzes
Related BrainMass Solutions

  • Using Excel -three simple regression analyses.

    252795 Using Excel -three simple regression analyses. Using Excel as your processing tool, work through three simple regression analyses.

  • Regression analyses with Excel data analysis

    220010 Regression analyses using Excel data analysis add-in Details: Using Excel as your processing tool, work through three simple regression analyses.

  • Three simple regression analyses in Excel

    210817 Statistics: work through three simple regression analyses in Excel and comment Using Excel as your processing tool, work through three simple regression analyses.

  • Regression Analyses

    141025 Regression Analyses Using Excel as your processing tool, work through three simple regression analyses.

  • Regression Analysis:AIU Job satisfactisfaction Data Base

    287486 Three simple regression analyses Prepare a report using Excel as your processing tool to process three simple regression analyses. 1.First run a regression analysis using the BENEFITS column of all data points in the data set as the independent

  • Regression Analyses: Slope, the Y-Intercept, and R-Squared Value

    233583 Regression Analyses: Slope, the Y-Intercept, and R-Squared Value Using Excel as your processing tool, work through three simple regression analyses. Please see the attached document for the necessary data. 1.

  • Three regression analyses using Excel

    219268 Using Excel - Work through 3 Regression Analysis Please use Excel as your processing tool to work through three simple regression analyses, using the attached Data Set. 1.

  • Regression Analysis

    266780 Regression Analysis Using Excel as your processing tool, work through three simple regression analyses. 1.

  • Scatter Plot

    What are the R² values for each of the models? i). Calculate the residuals for all significant models. Create a plot (using excel) of residuals versus predicted values for each model. Is the simple linear model appropriate for these data?

View More Related Solutions