Instructions:

You must use Excel or a similar statistical software package, such as SPSS, for your assignment.Handwritten papers will not be accepted.

Tasks:

1.Select thirty stocks (at least 3 different industries) that are listed on the Toronto Stock Exchange.

2.Track each stock's closing price at the end of the trading day.These closing prices will appear on Internet.Collect the stock closing price data from January 2016 to December 2018.

3.Present a complete record of the day-to-day listings of your stocks in a tabular form. (This data must be uploaded to D2L: Please note that you have to upload the data only, not the analysis. Again, upload once only.)

4.For each stock, use your data to calculate and interpret:

a)the mean price

b)the median price

c)the standard deviation

d)the range

e)the interquartile range

f)the coefficient of variation

g)95% confidence interval of mean price using t as the sampling distribution.

5.Which stock's prices are more consistent?Explain.

6.If you are not very risk tolerant, which stock would you choose? Explain.

7.A mutual fund is a pool of several stocks. Assume that you are a fund manager and decide to set up two mutual funds (one with a very low risk and another one with high risk). Based on the selected thirty stocks, set up two mutual funds with a pool of 15 stocks in each. Explain.

8.Pick any one of the stocks and calculate the increment of the closing price within each year of 2016, 2017 and 2018, respectively. You now have three years data for the increment of closing price. Assuming independent populations, run statistical tests to see if there is a significant difference among the mean value of increment of closing price at 5% significance level.Basically, you have to compare the mean values for each pair of data.