Which Regression Produces the Strongest Correlation Coefficient and Why?
Not what you're looking for?
Prepare a 3-page report using Excel as your processing tool to process 3 simple regression analyses. Create a graph with the trend line displayed for each of the 3 different regressions.
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.
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.
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.
Then answer the following questions:
What are the least squares regression line equations for each of the 3 different regressions?
What are the slopes and the y-intercepts?
What are the R-squared values for the 3 different regressions?
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?
Purchase this Solution
Solution Summary
The solution is attached as an Excel document where three tabs show the regression and answer the three questions about each regression. Some comments on the graph in a separate sheet are also included.
Solution Preview
I created tabs in Excel for you. Three tabs show the regression and answer the three ...
Education
- BSc, University of Virginia
- MSc, University of Virginia
- PhD, Georgia State University
Recent Feedback
- "hey just wanted to know if you used 0% for the risk free rate and if you didn't if you could adjust it please and thank you "
- "Thank, this is more clear to me now."
- "Awesome job! "
- "ty"
- "Great Analysis, thank you so much"
Purchase this Solution
Free BrainMass Quizzes
Organizational Leadership Quiz
This quiz prepares a person to do well when it comes to studying organizational leadership in their studies.
Balance Sheet
The Fundamental Classified Balance Sheet. What to know to make it easy.
Academic Reading and Writing: Critical Thinking
Importance of Critical Thinking
MS Word 2010-Tricky Features
These questions are based on features of the previous word versions that were easy to figure out, but now seem more hidden to me.
Basics of corporate finance
These questions will test you on your knowledge of finance.