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 companys 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 From the data provided, select generate a random sample of 210 companies 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 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 populations probability of success (i e for the probability that returns are larger than 0 015) Explain Compute an unbiased estimate of the population variance of the Bernoulli random variable Y 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 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 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 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 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 Answer is in the image, click to view ...

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Sep 21, 2024

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 companys stock

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 companys 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.

From the data provided, select/generate a random sample of 210 companies.
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.
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 populations probability of success (i.e. for the probability that returns are larger than 0.015)? Explain!
Compute an unbiased estimate of the population variance of the Bernoulli random variable Y. 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?
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.
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.
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.
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!