Math Homework

Ask Math Questions. Get Help With Your Math Homework

Connect one-on-one with {0} who will answer your question

Customer Question

Using Excel as your processing...

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?

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

Instructor Comments: Unit 5 IP: In the first three parts you will do three regression lines, that are INTRINSIC = b * BENEFITS + a, EXTRINSIC = b * BENEFITS + a, and OVERALL = b * BENEFITS + a. Page 546 has directions on how to compute correlations and regression lines in Excel. Use all 29 data rows of the three columns, no samples no extra numbers, and no partitioning!

Be sure to present three regression equations with R-squared value and three graphs. Provide the following summary table.

a b R2

1)

2)

3)

Make an XY (scatter) plot and include the trendline. In Excel, you need to highlight the two columns you want to graph to make the scatter gram. In Office 2007 which is the official AIU version, under insert is all of the graphs. You need to have the graph highlighted then under layout is trendline. In Office 2003, after you have made the scatter plot, there is an “add trendline” option under the Chart menu. Don’t forget to do the fourth part. Write this as a coherent integrated report with an introduction, description of methods, results, interpretation of results, and conclusion, with references.

If you tell me how I will upload the Excel AIU data set that you need to do this.

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?

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

Instructor Comments: Unit 5 IP: In the first three parts you will do three regression lines, that are INTRINSIC = b * BENEFITS + a, EXTRINSIC = b * BENEFITS + a, and OVERALL = b * BENEFITS + a. Page 546 has directions on how to compute correlations and regression lines in Excel. Use all 29 data rows of the three columns, no samples no extra numbers, and no partitioning!

Be sure to present three regression equations with R-squared value and three graphs. Provide the following summary table.

a b R2

1)

2)

3)

Make an XY (scatter) plot and include the trendline. In Excel, you need to highlight the two columns you want to graph to make the scatter gram. In Office 2007 which is the official AIU version, under insert is all of the graphs. You need to have the graph highlighted then under layout is trendline. In Office 2003, after you have made the scatter plot, there is an “add trendline” option under the Chart menu. Don’t forget to do the fourth part. Write this as a coherent integrated report with an introduction, description of methods, results, interpretation of results, and conclusion, with references.

If you tell me how I will upload the Excel AIU data set that you need to do this.

Show More

Show Less

Was this answer helpful?

Describe your issueThe assistant will guide you

Chat 1:1 with a math tutor or teacherLicensed Experts are available 24/7

100% satisfaction guaranteeGet all the answers you need

Related Math Homework Questions

Using survey responses from the AIU data set, complete the

Using survey responses from the AIU data set, complete the following requirements in the form of a 3-page report: TEST #1: Regression Analysis- Benefits & Intrinsic Perform the following Regression An… read more

TEST #1: Regression Analysis- Benefits & Intrinsic Perform

TEST #1: Regression Analysis- Benefits & Intrinsic Perform the following Regression Analysis, using a .05 significance level •Run a regression analysis using the BENEFITS column of all data points in … read more

Perform the following Regression Analysis, using a .05 significance

Perform the following Regression Analysis, using a .05 significance level •Run a regression analysis using the BENEFITS column of all data points in the AIU data set as the independent variable and th… read more

This is some of the question I have a data key to attach as

This is some of the question I have a data key to attach as well. Prepare a 3-page report using Excel as your processing tool to process 3 simple regression analyses. Create a graph with the trendline… read more

Prepare a 3-page report using Excel as your processing tool

Prepare a 3-page report using Excel as your processing tool to process 3 simple regression analyses. Create a graph with the trendline displayed for each of the 3 different regressions. First run a re… read more

Prepare a report using Excel as your processing tool to process

Prepare a report using Excel as your processing tool to process three simple regression analyses. First run a regression analysis using the BENEFITS column of all data points in the AIU data set as th… read more

First run a regression analysis using the BENEFITS column of

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 dat… read more

1.First run a regression analysis using the BENEFITS column

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 d… read more

First run a regression analysis using the BENEFITS column of

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 dat… read more

Prepare a report using Excel as your processing tool to process

Prepare a report using Excel as your processing tool to process three simple regression analyses. First run a regression analysis using the BENEFITS column of all data points in the AIU data set as th… read more

Prepare a report using Excel as your processing tool to process

Prepare a report using Excel as your processing tool to process three simple regression analyses. First run a regression analysis using the BENEFITS column of all data points in the AIU data set as th… read more

Using Excel as your processing tool, work through three simple

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 … read more

Greg I posted another questions! Can you please help! I needed

Greg I posted another questions! Can you please help! I needed by tomorrow! Here is the question? Using Excel as your processing tool, work through three simple regression analyses. First run a regres… read more

Using Excel as your processing tool, work through three simple

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 … read more

First run a regression analysis using the BENEFITS column of

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 dat… read more

I would like Greg Michaelson to answer this for me please.Using

I would like Greg Michaelson to answer this for me please.Using Excel as your processing tool, work through three simple regression analyses. 1. First run a regression analysis using the BENEFITS colu… read more

Using Excel as your processing tool, work through three simple

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 independe… read more

Using Excel as your processing tool, work through three simple

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 … read more

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.

Ask-a-doc Web sites: If you've got a quick question, you can try to get an answer from sites that say they have various specialists on hand to give quick answers... Justanswer.com.

JustAnswer.com...has seen a spike since October in legal questions from readers about layoffs, unemployment and severance.

Web sites like justanswer.com/legal

...leave nothing to chance.

...leave nothing to chance.

Traffic on JustAnswer rose 14 percent...and had nearly 400,000 page views in 30 days...inquiries related to stress, high blood pressure, drinking and heart pain jumped 33 percent.

Tory Johnson, GMA Workplace Contributor, discusses work-from-home jobs, such as JustAnswer in which verified Experts answer people’s questions.

I will tell you that...the things you have to go through to be an Expert are quite rigorous.

Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help.

Freshfield, Liverpool, UK

This expert is wonderful. They truly know what they are talking about, and they actually care about you. They really helped put my nerves at ease. Thank you so much!!!!

Los Angeles, CA

Thank you for all your help. It is nice to know that this service is here for people like myself, who need answers fast and are not sure who to consult.

Hesperia, CA

I couldn't be more satisfied! This is the site I will always come to when I need a second opinion.

Kernersville, NC

Just let me say that this encounter has been entirely professional and most helpful. I liked that I could ask additional questions and get answered in a very short turn around.

Woodstock, NY

Thank you so much for taking your time and knowledge to support my concerns. Not only did you answer my questions, you even took it a step further with replying with more pertinent information I needed to know.

Elkton, Maryland

He answered my question promptly and gave me accurate, detailed information. If all of your experts are half as good, you have a great thing going here.

Dallas, TX

< Previous | Next >

Manal Elkhoshkhany

Bachelor's Degree

380 satisfied customers

I have completed my BA degree in 1988, and graduated with a GPA of 4.0.

Jabi

Tutor

171 satisfied customers

I've been an Expert on JustAnswer since July 2010

Mr. Gregory White

Master's Degree

115 satisfied customers

M.A., M.S. Education / Educational Administration

Dr Arthur Rubin

Doctoral Degree

77 satisfied customers

Ph.D. in Mathematics, California Institute of Technology

JACUSTOMER-yrynbdjl-

Master's Degree

49 satisfied customers

I have taught college Mathematics for the past 10 years.

SusanAthena

Master's Degree

41 satisfied customers

Tutor for Algebra, Geometry, Statistics. Explaining math in plain English.

Don

Master's Degree

17 satisfied customers

M.S. Astronautical Engineering. Math/Science/Comp Tutor

< Previous | Next >

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.