The data set "Computer_Exercise3.xlsx" contains the monthly ex-dividend net return (i.e. proportionate change in prices) that could have be obtained by buying a company's stock on July 31, 2008 and selling it on August 29, 2008 for (almost) all stocks traded on the NYSE, NYSE MKT, NASDAQ, Arca, and other exchanges.

Please complete the following set of exercises.

1. From the data provided, select/generate a random sample of 210 companies.
2. Generate a series with the same number of observations as the return series. Each observation of the new series corresponds to the outcome of a Bernoulli random variable,Y. The outcome is 1 if the net stock return in the same month is (strictly) larger than 0.015 and zero otherwise.
3. Based on your random sample of Bernoulli variables, compute the sample average/sample mean of the outcomes in question 2. above. Is this value an unbiased estimate for the population's probability of success (i.e. for the probability that returns are larger than 0.015)? Explain!
4. Compute an unbiased estimate of the population variance of the Bernoulli random variableY. Compare this value to the sample variance (i.e. the descriptive/summary statistic discussed in Appendix A). Are the two values different and - if yes - how do they differ?
5. Now consider the observations on net returns. Make a histogram that summarizes the distribution of returns in your sample by counting the number of observations in each bin (i.e. frequency). Let Excel automatically generate the bins.
6. Make a histogram that summarizes the distribution of returns in your sample by counting the number of observations in each bin (i.e. frequency). Plot the distribution in 20 bins of equal size.
7. For the same 20 bins as in question 6. above, make a histogram that summarizes the distribution of returns in your sample by reporting the proportion of outcomes that fall into each bin.
8. Based on your random sample of net returns, which is assumed to represent the population well, would you be inclined to conclude that returns are normally distributed? Explain!

The data for this exercise can be found above: "Computer_Exercise3.xlsx".

You are asked to complete the assignment (individually) and submit itbeforethe following lecture. The assignment should be submitted in Excel (saved as "Excel Workbook", i.e. "YOURNAME.xlsx" or "YOURNAME.xls") and should be uploaded to this folder. Please ensure that Excel formulas/procedures used to obtain solutions are traceable for the grader, and kindly highlight final results.