Using EXCEL attempt the following questions: Question 1: (10 marks) Ross Co., Westerfield, Inc., and Jordan Company announced a new agreement to market their respective products in China on July 18, February 12, and October 7, respectively. Given the information below, calculate the cumulative abnormal return (CAR) for these stocks as a group. Assume all companies have an expected return equal to the market return. Graph and interpret your results. Do your results support market efficiency? Ross Co. Westerfield, Inc. Jordan Company Date Market Return Company Return Date Market Return Company Return Date Market Return Company Return July 12 Feb Oct 1 July 11 3 Feb 9 Oct 2 2 X July 16 .6 8 Feb 10 6 4 Oct 3 9 13 July 17 - 4 -2 Feb 11 .8 1.0 Oct 6 -3 July 18 1.9 1.3 Feb 12 -1 1 Oct 7 -2.4 -5 July 19 -8 -6 Feb 15 1.3 1.4 Oct . 3 July 20 --- -10 Feb 16 1.7 .7 Oct 9 -3 July 23 .6 .4 Feb 17 -1 Oct 10 .1 - July 24 .1 0 Feb 18 . 4 Oct 13 - -2 .0