Math

Ask a Math Question, Get an Answer ASAP!

Have your own Math question?

7 Math Tutors are Online Now

characters left:

Not a Math Question?

Question

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

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

Submitted: 94 days and 19 hours ago.

Category: Math

Value: $15

Status: AWAITING CUSTOMER ACTION

Subject: Statistical Analysis

Already Tried:
Using Excel as your processing tool, work through three simple regression analyses.

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

Construct charts and diagrams to interpret data.
Calculate and interpret the correlation between variables.

Accepted Answer

Dear XXXXXXXXXXXX,

Great question! Here's how I'd answer it:

Here's a file that contains the regression analyses and the answers to the first few questions.

Here is the answer to the last questions:
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?

None of the three analyses produce significant output. Therefore, none of the models are informative at all. Hence, while we could talk about how two of the lines have a negative slope, while only 1 has positive slope, this would be inappropriate since the statistical analysis shows that the slope of the regression coefficient is not significantly different from 0.

While OVERALL produces the strongest correlation, none of the correlations, according to the p-value are different from 0 in a statistically significant way.

----

Let me know if you have questions about this. I'm happy to clarify any details!

Accepts:
Expert:	Greg
Pos. Feedback:	99.6 %
Answered:	8/19/2009

Graduate Student

I teach math and statistics at a college level as a graduate teaching assistant

94 days and 17 hours ago.

Reply

i lost everying can you send it to me again?
garry

Posted by Greg 94 days and 17 hours ago.

Info Request

It's still posted here. You're welcome to get it again. Be sure to leave positive feedback if you're happy!

Disclaimer: Information in questions, answers, and other posts on this site ("Posts") comes from individual users, not JustAnswer; JustAnswer is not responsible for Posts. Posts are for general information, are not intended to substitute for informed professional advice (medical, legal, veterinary, financial, etc.), or to establish a professional-client relationship. The site and services are provided "as is" with no warranty or representations by JustAnswer regarding the qualifications of Experts. To see what credentials have been verified by a third-party service, please click on the "Verified" symbol in some Experts' profiles. JustAnswer is not intended or designed for EMERGENCY questions which should be directed immediately by telephone or in-person to qualified professionals.