QNT351 Week 5 Question 1 and 2
Click Link Below To Buy:
http://hwaid.com/shop/qnt351-week-5-question-1-and-2/
You are consulting for a large real estate firm. You have been asked to construct a model that can predict listing prices based on square footages for homes in the city you’ve been researching. You have data on square footages and listing prices for 100 homes.
1. Which variable is the independent variable (x) and which is the dependent variable (y)?
The listing price is based on the square footage, so the listing price is the dependent variable (y) and the square footage is the independent variable (x).
2. Click on any cell. Click on Insert→Scatter→Scatter with markers (upper left).
To add a trendline, click Tools→Layout→Trendline→LinearTrendline
Does the scatterplot indicate observable correlation? If so, does it seem to be strong or weak? In what direction?
The scatter plot indicates that there is a strong positive linear relationship between the variables. As the square feet increase so does the price.
QNT351 Week 5 Question 1 and 2
Click Link Below To Buy:
http://hwaid.com/shop/qnt351-week-5-question-1-and-2/
You are consulting for a large real estate firm. You have been asked to construct a model that can predict listing prices based on square footages for homes in the city you’ve been researching. You have data on square footages and listing prices for 100 homes.
1. Which variable is the independent variable (x) and which is the dependent variable (y)?
The listing price is based on the square footage, so the listing price is the dependent variable (y) and the square footage is the independent variable (x).
2. Click on any cell. Click on Insert→Scatter→Scatter with markers (upper left).
To add a trendline, click Tools→Layout→Trendline→LinearTrendline
Does the scatterplot indicate observable correlation? If so, does it seem to be strong or weak? In what direction?
The scatter...