Series1	Series2
10	-16
18	-80
8	-40
4	-32
2	-16
4	-80
2	-48
12	-56
12	-96
22	-40
22	-72
14	-32
8	-96
18	-8
20	-16
16	-64

Transcribed Image Text:

Problem 10: For the data series provided and in the order they are provided (Series 1 asx- axis/Series2 as y-axis): a) Create a scatter diagram of Series1 and Series2 using Excel. b) Using the Excel's Correl function, which of the following is True: X) the data is very slightly positively correlated Y) there is absolutely no correlation between the Series1 and Series2 Z) none of the above c) Add a linear trendline to the Scatter Diagram in a). d) What can we say, in a statistical sense, about the relationship between Series 1 and Series 2? Problem 10: For the data series provided and in the order they are provided (Series 1 asx- axis/Series2 as y-axis): a) Create a scatter diagram of Series1 and Series2 using Excel. b) Using the Excel's Correl function, which of the following is True: X) the data is very slightly positively correlated Y) there is absolutely no correlation between the Series1 and Series2 Z) none of the above c) Add a linear trendline to the Scatter Diagram in a). d) What can we say, in a statistical sense, about the relationship between Series 1 and Series 2?

Answer rating: 100% (QA)

a The scatter diagram of series 1 and series 2 using excel is show... View the full answer