Suppose the following data set contains the monthly adjusted stock prices for technology company A, and a comer goods co

[answerhappygod]

Suppose The Following Data Set Contains The Monthly Adjusted Stock Prices For Technology Company A And A Comer Goods Co 1 (23.73 KiB) Viewed 74 times

Suppose the following data set contains the monthly adjusted stock prices for technology company A, and a comer goods company from 2013-2018. Copy and paste the data into Excel and use the Excel functions for covariance and correlation to solve the question Date А B 4/1/2013 444 66.73 7/1/2013 49.71 69.54 11/2013 59.60 67.00 9/1/2013 54.00 66.00 10/1/2013 60.40 70. 11/1/2013 14327 12/1/2013 67.60 71.55 1/1/2014 60.19 67:40 2/1/2014 6343 6.68 371/2014 67.57 4/1/2014 1439 7100 /1/2014 72.11 61/2014 547 2017 71/2014 7.95 79.00 11/2014 943 6/5/2014 33 16/1/2014 99,99 7.0 11/1/2014 110.21 13/1/2014
12/1/2014 102.56 02.43 1/1/2015 11/2015 109.03 75.35 2/1/2015 119.547764 3/1/2015 116.32 74.72 4/1/2015 117.00 72.58 5/1/2015 121.84 72.14 01/2015 6/1/2015 117.76 72.01 7/1/2015 113.35 70.61 1/1/2015 105.91 65.66 9/1/2015 103.91 10/1/2015 112.06 70.89 11/1/2015 111.51 90.00 12/1/2015 ICW 1/1/2016 91.96 76.42 2/1/2010 91.35 75.73 3/1/2016 103.67 77.65 4/1/2016 90.02 7561 51/2016 94.90 27.09 6/1/2016 91.7 10.40 7/1/2016 99.69 80.30 0/1/2016 101:51 9/1/2016 109.62 2650 10/1/2016 10930 CT EX
8/1/2016 101.51 63.63 9/1/2016 108.62 85.92 10/1/2016 109.30 13.13 11/1/2016 106,36 79.63 12/1/2016 112.09 01.17 1/1/2017 117:49 64.53 2/1/2017 132.76 38.53 3/1/2017 139.00 37.35 4/1/2017 139.0734.93 5/1/2017 140.00 6/1/2017 140.625.00 7/1/2017 145.45 87.95 1/1/2017 160.40 91.00 9/1/2017 151.30 00.00 10/5/2017 166.11 13.27 11/1/2017 167.88 16.40 19/1/2017 166,00 9135 1/1/2016 165.11 85.90 2/1/2018 175.72 75.80 3/1/2010 166.14 76.55 4/1/2018 163.63 74.68 5/1/2018 186.50 35:31