Create a scatter chart in Excel for these 20 observations. Choose the correct scatter chart below....

  

 

Transcribed Image Text:

Create a scatter chart in Excel for these 20 observations. Choose the correct scatter chart below. (1) € (ii) Y 40 30 20 10 0 -10 -20 -30 -40 -50 50 40 30 20 10 0 -10 -20 -30 -40 8 -50 -40 -20 -30 -20 -10 -10 O 10 10 20 20 30 30 40 40 Du 40 30 20 10 10 -10 -20 -30 -40 -50 -10 0 10 20 30 40 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. - Observation 1 2 3 4 5 6 7 8. 6 10 11 12 CONSERR 14 15 16 17 IN 19 20 X BBB303-5882328 (1 21 (1- 12: 14 37 34 6 $1 12 -7 y 23 38 3 -22 14 -19 18 27 6 1 40 -29 6 33 -16 N 17 14 2 Create a scatter chart in Excel for these 20 observations. Choose the correct scatter chart below. (1) € (ii) Y 40 30 20 10 0 -10 -20 -30 -40 -50 50 40 30 20 10 0 -10 -20 -30 -40 8 -50 -40 -20 -30 -20 -10 -10 O 10 10 20 20 30 30 40 40 Du 40 30 20 10 10 -10 -20 -30 -40 -50 -10 0 10 20 30 40 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. - Observation 1 2 3 4 5 6 7 8. 6 10 11 12 CONSERR 14 15 16 17 IN 19 20 X BBB303-5882328 (1 21 (1- 12: 14 37 34 6 $1 12 -7 y 23 38 3 -22 14 -19 18 27 6 1 40 -29 6 33 -16 N 17 14 2

Answer rating: 100% (QA)

Solutions Step 1 To plot scatter graph and find best f... View the full answer