mparison.xlsx The DATAfile StockComparison contains monthly adjusted stock prices for technology company Apple, Inc., and consumer-goods...

Transcribed Image Text:

mparison.xlsx The DATAfile StockComparison contains monthly adjusted stock prices for technology company Apple, Inc., and consumer-goods company Procter & Gamble (P&G) from 2013-2018. (a) Develop a scatter diagram with Apple stock price on the horizontal axis and P&G stock price on the vertical axis. 200 Apple Adjusted Stock Price P&G Adjusted Stock Price 200 150 100 50 100p 80 60 40 20 0 50 100 150 200 Apple Adjusted Stock Price 0 20 40 60 80 100 P&G Adjusted Stock Price Apple Adjusted Stock Price 150 100 50 0 20 40 60 80 100 P&G Adjusted Stock Price (b) What appears to be the relationship between these two stock prices? The scatter diagram shows -Select-relationship with --Select-- Apple stock prices associated with higher P&G stock prices. (c) Compute the sample covariance. (Round your answer to two decimal places.) Interpret the sample covariance. P&G Adjusted Stock Price 100 80 60 40 20 .. 0 50 100 150 200 Apple Adjusted Stock Price @ mparison.xlsx The DATAfile StockComparison contains monthly adjusted stock prices for technology company Apple, Inc., and consumer-goods company Procter & Gamble (P&G) from 2013-2018. (a) Develop a scatter diagram with Apple stock price on the horizontal axis and P&G stock price on the vertical axis. 200 Apple Adjusted Stock Price P&G Adjusted Stock Price 200 150 100 50 100p 80 60 40 20 0 50 100 150 200 Apple Adjusted Stock Price 0 20 40 60 80 100 P&G Adjusted Stock Price Apple Adjusted Stock Price 150 100 50 0 20 40 60 80 100 P&G Adjusted Stock Price (b) What appears to be the relationship between these two stock prices? The scatter diagram shows -Select-relationship with --Select-- Apple stock prices associated with higher P&G stock prices. (c) Compute the sample covariance. (Round your answer to two decimal places.) Interpret the sample covariance. P&G Adjusted Stock Price 100 80 60 40 20 .. 0 50 100 150 200 Apple Adjusted Stock Price @