# Statistical analysis

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.

Â© BrainMass Inc. brainmass.com December 15, 2022, 7:54 pm ad1c9bdddfhttps://brainmass.com/statistics/regression-analysis/statistical-analysis-258493

#### 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 Summary

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