Topic: Computer Excercise
Number of math problems: 1, Double spaced
Order type: Math/Physics/Economics/Statistics Problems
Language: English (U.S.)
complete the following set of exercises.
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.
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 larger than or equal to 0.03 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 population’s probability of success (i.e. for the probability that returns are larger than or equal to 0.03)? 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 18 bins of equal size.
For the same 18 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!