Question: The following 20 observations are for two quantitative variables, x and y. Click on the datafile logo to reference the data. Observation x y 1
The following 20 observations are for two quantitative variables, x and y. Click on the datafile logo to reference the data. Observation x y 1 -22 22 2 -33 49 3 2 8 4 29 -16 5 -13 10 6 21 -28 7 -13 27 8 -23 35 9 14 -5 10 3 -3 11 -37 48 12 34 -29 13 9 -18 14 -33 31 15 20 -16 16 -3 14 17 -15 18 18 12 17 19 -20 -11 20 -7 -22 (a) Create a scatter chart in Excel for these 20 observations. Choose the correct scatter chart below. (i) (ii) (iii) (iv) - Select your answer - (b) Fit a linear trendline to the 20 observations. What can you say about the relationship between the two quantitative variables? The trendline confirms that there appears to be a - Select your answer - - Select your answer - relationship between the x and y variables
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
