Help with the following business question.
- Click on Data→Data Analysis→Regression→OK. Highlight your data (including your two headings) and input the correct columns into Input Y Range and Input X Range, respectively. Make sure to check the box entitled "Labels".
What is the Coefficient of Correlation between square footage and listing price?
Does your Coefficient of Correlation seem consistent with your answer to #2 above? Why or why not? What proportion of the variation in listing price is determined by variation in the square footage? What proportion of the variation in listing price is due to other factors?