Question: please fill in red question marks with excel formulas, please keep cell number/letter as is. 700 B D E F 4 Date market index li
please fill in red question marks with excel formulas, please keep cell number/letter as is.

700 B D E F 4 Date market index li stock A price in d market index percei stock A percentage return 1/1/2019 1499.4200 22.8653 2/1/2019 1575.5500 21.5525 ? ? 3/1/2019 1539.7400 20.8917 ? ? 4/1/2019 1591.2100 20.7930 ? ? 5/1/2019 1465.4900 18.1695 ? ? 10 6/1/2019 1566.5699 18.9557 ? ? 11 7/1/2019 1574.6100 20.4376 ? ? 12 8/1/2019 1494.8400 13.2714 ? ? 13 9/1/2019 1523.3700 13.9728 ? ? 14 10/1/2019 1562.4500 13.9262 ? ? 15 11/1/2019 1624.5000 14.0731 ? ? 16 12/1/2019 1668.4700 15.6164 ? ? 17 1/1/2020 1614.0601 15.0133 ? ? 18 2/1/2020 1476.4301 12.4531 ? ? 19 3/1/2020 1153.1000 4.6217 ? ? 20 4/1/2020 1310.6600 5.7447 ? ? 21 5/1/2020 1394.0400 6.2348 ? ? 22 6/1/2020 1441.3700 6.7446 ? ? 23 7/1/2020 1480.4301 5.9408 ? ? 24 8/1/2020 1561.8800 6.8328 ? ? 25 9/1/2020 1507.5899 5.5878 ? ? 26 10/1/2020 1538.4800 6.0878 ? ? 27 11/1/2020 1819.8199 10.0091 ? ? 28 12/1/2020 1974.8600 11.0286 ? ? 29 30 31 beta of market ind ? 32 beta of stock A
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
