A biologist wants to know the highest likely proportion of squirrels in the area that are infected with a particular disease. A random sample of 100

squirrels was tested. Use Sheet 9 of the Excel file linked above to calculate p^

and the 95%confidence interval.

EXCEL SHEET DATA:

Infected Yes No Yes No Yes Yes No No Yes Yes Yes No Yes Yes Yes Yes Yes Yes No Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes No Yes Yes No Yes Yes Yes Yes Yes Yes No No Yes No Yes Yes Yes Yes No Yes Yes Yes Yes Yes Yes Yes No Yes Yes Yes Yes Yes Yes No Yes No No Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes No Yes No No No Yes No Yes Yes No Yes No No Yes No Yes Yes Yes Yes Yes No

p^=

Upper bound for 95%

confidence interval =

Lower bound for 95%

confidence interval =

The biologist can say with 95%

confidence that the true population proportion of the local squirrel population that is infected with the disease is in the interval [000000000,000000000]

.

The highest likely proportion is .