Purchase Solution

Statistical analysis

Not what you're looking for?

Using Excel as your processing tool, work through three simple regression 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. 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?

2. Next, 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. 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?

3. Next, 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. 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?

4. 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?

Be sure to provide references in APA format for any resources you may use.

Solution Summary

The response address the queries posted in 699 words with references.

Solution Preview

The response address the queries posted in 699 words with references.

//Before writing about the 'Regression Analysis' of the selected variables from the job satisfaction survey of the AIU population, we will write about the different 'Variables' included in the data set. Then, we will provide the regression analysis of the benefits and intrinsic job satisfaction.//

The data set provided by the American Intellectual Union comprise of the job satisfaction survey. The job satisfaction survey is based on the different factors, gender, age, department; and job position, tenure with the company, overall job satisfaction, extrinsic job satisfaction, intrinsic job satisfaction ; also the benefits. The survey comprises of the analysis of different factors for assessing the job satisfaction level of the population. The analysis will focus on the description about the trend line and least square regression line equation. Along with this, the 'R-squared' value will also be described and the best fit output results will be evaluated for the selected variables (Bernstein, 1999).

By considering benefits as the 'independent variable' and intrinsic job satisfaction as the 'dependent variable' on ...

Solution provided by:
Education
• MBA (IP), International Center for Internationa Business
• BBA, University of Rajasthan
Recent Feedback
• "Thank You so much! "
• "Always provide great help, I highly recommend Mr. Sharma over others, thanks again. "
• "great job. I will need another help from you. "
• "first class!"
• "Thank you for your great notes. Will you be willing to help me with one more assignment? "

Measures of Central Tendency

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

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.