Data Project ( Mean and standards deviation for the data)

Use 30 stocks classified as the Dow Jones industrials as the sample. Note the amount each stock has gained or lost in the last quarter.

1-       Compute the mean and standards deviation for the data set.

2-       Compute the 95% confidence interval for the mean and the 95% confidence interval for the standard deviation.

3-        Compute the percentage of stocks that had a gain in the last quarter.

4-        Find a 95% confidence interval for the percentage of stocks with a gain.

Use Excel.