Question
Choose TWO variables ( price and MPG(city)and explain why you feel that they are correlated. Do you suspect the relation is positive or negative? Why?
Choose TWO variables ( price and MPG(city)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 along with your raw data. Looking at theR2value, explain what this indicates about the strength of the relation. Then write out your Regression Equation, state if your p-value and conclusion.
MPG (city) 25 25 23 28 28 28 27 29 27 24
Price 29,200 37,280 36,370 24,595 36,270 25,695 22,620 21,965 21,540 22,090
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started