Create the line charts for each of 83?, Boeing and IBM series using Close prices against time in Excel and comment on your observations {focusing on different features a time series can exhibit]. 3. Calculate returns for these three series in Excel using the transformation: r, = we ln[P,fF',_,] Hints: - We performed a similar task in Tutorial 01. i If there are say "n+1\" observations on prices, then the return series would have \"n\" observations. 0 These numbers would represent percentages after multiplication with 1m in the formula above. However, you would not put a percentage sign in your data. For example, returns for two periods are [1.35% and {141 \"In but we omit \"fa sign in our excel worksheet and use H.515 and Bull. b. Obtain the summary statistics for returns series in your sample and briefly discuss the risk and average return relationship in each stock. Which stock {Boeing or IBM} is relatively riskier than the other? c. Perform the .Jarque-Berra test of normally distributed returns for each of Boeing and IBM. Discuss your findings and also explain why do you test normality test. Test the hypothesis that average return on Boeing stock is at least 3%. Which test Statistic would you use to perform this hypothesis test and why? Also, specify the distribution of the test statistic under the null