What are statistical capabilities of excel

Question

Assignment:

Discuss te below:

I have created 95% confidence interval estimates of the population mean µ from your data in columns E and F. I have used the fact that I know σ is 6.5, that the sample was from a normal population, and that you all took samples of size 10. Therefore, the interval becomes sample mean ± 1.96*6.5/3.16. (3.16 is the approximate square root of 10.) I have higlighted the one interval that did NOT cover the true value of µ, which is 76.06.

In columns H and I generate 80% confidence intervals for µ, in a manner similar to the way I generated the 95% intervals. Indicate those which do not contain the true value of the mean in some way.

In columns K and L, generate 95% confidence intervals based on the t statistic. and in columns N and O, generate 80% intervals based on the t statstics. Again, indicate in some way the intervals that fail to include the (true) mean.

We have also said that the (collection of all) sample means, should have a mean itself that is the same as the population mean and a standard deviation that is equal to the population standard deviation divided by the square root of the sample size. That implies that the mean of all sample means should be about 76.06 and the standard deviation about 6.5/(square root 10). Use the statistical capabilities of Excel to find the mean and standard deviation of our sample means (all the data in column B) and compare them to these values. Are they close?

name	sample mean	sample std dev		95%  LL	95%  UL		80%  LL	80%  UL		95%  LL	95%  UL		80%  LL	80%  UL
					normal			normal			t			t
Pickett	71.7	5.79		67.67	75.73		69.07	74.33		67.05	75.84		69.17	74.23
Hussain	72.8	6.74		68.77	76.83		70.17	75.43		68.15	77.62		69.85	75.75
Robert	72.9	6.87		68.87	76.93		70.27	75.53		68.25	77.82		69.89	75.91
Mutava	73.0	4.83		68.97	77.03		70.37	75.63		68.35	76.46		70.89	75.11
Smith	73.9	10.03		69.87	77.93		71.27	76.53		69.25	81.08		69.51	78.29
Brijwani	74.0	9.26		69.97	78.03		71.37	76.63		69.35	80.63		69.95	78.05
Rao	74.0	5.93		69.97	78.03		71.37	76.63		69.35	78.24		71.4	76.6
Martel	74.1	8.67		70.07	78.13		71.47	76.73		69.45	80.31		70.31	77.89
Black	74.4	8.81		70.37	78.43		71.77	77.03		69.75	80.71		70.54	78.26
Devlin	74.4	5.73		70.37	78.43		71.77	77.03		69.75	78.5		71.89	76.91
Nightingale	74.5	8.59		70.47	78.53		71.87	77.13		69.85	80.65		70.74	78.26
Grauer	74.8	5.29		70.77	78.83		72.17	77.43		70.15	78.59		72.48	77.12
Pradhan	74.8	8.03		70.77	78.83		72.17	77.43		70.15	80.55		71.29	78.31
Taylor	75.0	7.76		70.97	79.03		72.37	77.63		70.35	80.55		71.6	78.4
Subramanian	75.1	4.7		71.07	79.13		72.47	77.73		70.45	78.46		73.04	77.16
Thorne	75.4	5.34		71.37	79.43		72.77	78.03		70.75	79.22		73.06	77.74
Saini	75.5	5.38		71.47	79.53		72.87	78.13		70.85	79.35		73.15	77.85
Wenke	75.6	7.57		71.57	79.63		72.97	78.23		70.95	81.02		72.29	78.91
Parsons	75.7	7.134		71.67	79.73		73.07	78.33		71.05	80.81		72.58	78.82
Statham	75.8	5.92		71.77	79.83		73.17	78.43		71.15	80.04		73.21	78.39
Knetter	75.9	6.7		71.87	79.93		73.27	78.53		71.25	80.7		72.97	78.83
Rzodkiewicz	75.9	7.48		71.87	79.93		73.27	78.53		71.25	81.25		72.63	79.17
Case	76.1	7.26		72.07	80.13		73.47	78.73		71.45	81.3		72.92	79.28
Abdel-Karim	76.3	5.49		72.27	80.33		73.67	78.93		71.65	80.23		73.9	78.7
Kamal	76.4	6.65		72.37	80.43		73.77	79.03		71.75	81.16		73.49	79.31
Sullivan	76.5	4.5		72.47	80.53		73.87	79.13		71.85	79.72		74.53	78.47
Hackett	76.8	6.795		72.77	80.83		74.17	79.43		72.15	81.66		73.83	79.77
Swain	76.8	5.79		72.77	80.83		74.17	79.43		72.15	80.94		74.27	79.33
Weber	76.8	5.41		72.77	80.83		74.17	79.43		72.15	80.67		74.43	79.17
Hatesohl	77.1	4.61		73.07	81.13		74.47	79.73		72.45	80.4		75.08	79.12
McDaniel	77.1	4.89		73.07	81.13		74.47	79.73		72.45	80.6		74.96	79.24
Harper	77.2	7.48		73.17	81.23		74.57	79.83		72.55	82.55		73.93	80.47
Artzer	77.3	5.1		73.27	81.33		74.67	79.93		72.65	80.95		75.07	79.53
Veith	77.9	9.338		73.87	81.93		75.27	80.53		73.25	84.58		73.81	81.99
Mullins	78.2	5.16		74.17	82.23		75.57	80.83		73.55	81.89		75.94	80.46
Nkwantabisa	78.3	5.22		74.27	82.33		75.67	80.93		73.65	82.04		76.02	80.58
Sindelar	78.3	5.66		74.27	82.33		75.67	80.93		73.65	82.35		75.82	80.78
Propheter	78.7	7.83		74.67	82.73		76.07	81.33		74.05	84.3		75.27	82.13
Schulz	79.4	8.03		75.37	83.43		76.77	82.03		74.75	85.15		75.89	82.91