Question

Athletes performing in bright sunlight often smear black eye grease under their eyes to reduce glare. Does eye grease work? In one study, 16 student subjects took a test of sensitivity to contrast after three hours facing into bright sun, both with and without eye grease. (Greater sensitivity to contrast improves vision and glare reduces sensitivity to contrast.) This is a matched pairs design. Here are the differences in sensitivity, with eye grease minus without eye grease.

0.06	0.63	−0.11	−0.05	−0.17	0.14	−0.15	0.04
0.06	0.02	0.43	0.23	−0.11	0.28	0.05	0.29

How much more sensitive to contrast are athletes with eye grease than without eye grease? Give a 99% confidence interval to answer this question. (Round your answer to three decimal places.)

If possible explain how to do in excel.

Answer 1

from excel:average(array) function: mean=0.1025

from excel:stdev(array) function: standard deviation =0.2219

99% confidence interval lower bound = mean-margin of error =0.1025-confidence.T(0.01,0.2219,16)=-0.061

99%confidence interval upper bound = mean+margin of error =0.1025+confidence.T(0.01,0.2219,16)=0.266

from above 99% confidence interval for population mean =(-0.061 , 0.266)