Research designs and measurement strategies

Research designs and measurement strategies

ÿWhich variable is the independent variable (x) and which is the dependent variable (y)?ÿÿClick on any cell.Click on Insert??Scatter??Scatter with markers (upper left).To add a trendline, click Tools??Layout??Trendline??Linear TrendlineDoes the scatterplot indicate observable correlation?If so, does it seem to be strong or weak?In what direction?ÿÿÿ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?ÿÿÿCheck the coefficients in your summary output. What is the regression equation relating square footage to listing price?ÿÿÿTest the significance of the slope. What is your t-value for the slope?Do you conclude that there is no significant relationship between the two variables or do you conclude that there is a significant relationship between the variables?ÿÿÿÿUsing the regression equation that you designated in #3(d) above, what is the predicted sales price for a house of 2100 square feet? ÿ