The same data as in the previous problem are stored in a different format in the last

Question:

The same data as in the previous problem are stored in a different format in the last two sheets of the P08_15.xlsx file.
a. Use StatTools to find a 95% confidence interval for the proportion who favor Crest from the data in the Counts sheet. Using this same data on counts, calculate the confidence interval directly from the appropriate formulas, without using StatTools.
b. Use StatTools to find a 95% confidence interval for the proportion who favor Crest from the data in the proportions sheet. Using this same data on proportions, calculate the confidence interval directly from the appropriate formulas, without using StatTools.