MATH 302 Week 7 Discussion | American Public University System

MATH 302 Week 7 Discussion | American Public University System

 Week 7 Forum / Topic: Regression and Correlation


Look back to the raw data you collected in week 1. There are 7 variables listed:

Vehicle type/class





MPG (city)

MPG (highway)

Choose TWO variables that you feel are correlated and explain why you feel that they are correlated. Do you suspect the relation is positive or negative? Why? Which would be considered the independent variable, which the dependent variable? Why?

Run a regression analysis in Excel and provide the results in your post. Looking at the r squared value, explain what this indicates about the strength of the relation. 

I encourage you to review the Week 7 Regression PDF  at the bottom of the discussion forums.  This will give you a step by step example on how to calculate a correlation and run a Regression using Excel. I DO NOT recommend doing this by hand.  Let Excel do the heavy lifting for you.  You can also use this PDF in RealizeIT.

There are additional PDFs that were created to help you with the Homework, Lessons and Tests in RealizeIT.  While they won't be used to answer the questions in the discussion forum, they are just as useful and beneficial.  I encourage you to review these ASAP!  These PDFs are also located at the bottom of the forum.

Instructions: Your initial post should be at least 150 words. Make sure you include your data set in your initial post as well.  You must also respond to at least 2 other students. Responses should be a minimum of 50 words and may include direct questions.

Peer response #1 - Looking at your peer's Excel output, create an equation for the linear regression line for their expression. Write a problem you could use to make a prediction and show the work for your predicted value based on your expression. *For example, if your peer wrote a regression equation relating vehicle make to price, I may write a problem asking to predict the selling price of a 2017 Dodge Charger.*

Peer response #2 - It is important to remember that typically a two-factor regression model cannot accurately describe the entire situation. Look at the dependent variable that your peer chose. What other factors do you think are related to this variable aside from the independent factor they have listed? Name at least 2 factors and explain why you feel they are related.



Answer Detail

Get This Answer

Invite Tutor