CHALLENGE ACTIVITY

$5\mathrm{.}1\mathrm{.}2$: Excel: Income and house prices.

Click this link to download the spreadsheet for use in this activity. Create scatterplots using the income and housing data in the spreadsheet linked above. Adjust the range of values in the horizontal and vertical axes, and create a trendline.

$550238\mathrm{.}2651030.$qx$3$zqy$7$

The following scatterplot is created using one of the datasets in the income and housing data in the spreadsheet linked above.Which variables are used in the scatterplot above?What is the direction of the correlation?What is the strength of the correlation?

Pick

Pick

Pick

$1$

$2$