Briey describe the broad historical evolution of the SPSOO since 2017. Calculate means and standard deviation of the return Use the same Excel functions as in Exercise 1. Create a frequency table for the data Create a frequency table for this data using the Excel function "Frequency", explained at the end of this handout. Use the following bins: -10,-9.5,-9,-8.5,-8, -7.5, - 7 etc... 7, 7.5, 8, 8.5, 9,9.5,10. Create a similar frequency table for the normal distribution Create a frequency table assuming that the data is generated by a normal distribution. That is, for each bin, calculate the probability of falling in that bin according to a normal distribution with the same mean and standard deviation as calculated above. How do the two distributions differ? Provide numerical answer to the following questions: What is the ratio of the true probability and of the normal probability of observing a daily return less than -5%? Harder question: What is the true probability and the normal probability of observing at least one daily return of less than -5%over a year? To answer this question, assume that returns are independently and identically distributed over the year. From your calculations, do you conclude that the two distributions assign similar probabilities to extreme events