A Marketing Firm Is Developing a New Television Advertisement for a Large

A marketing firm is developing a new television advertisement for a large discount retail chain. A sample of 30 people is shown two potential ads and asked their preference. The results for ad #1 follow. Use Excel to develop a 95% confidence interval estimate of the proportion of people in the population who will prefer ad #1. $\text { Prefer Advertis ement \# }$
$\begin{array}{llllll}\text { yes } & \text { no } & \text { no } & \text { yes } & \text { yes } & \text { no } \\\text { no } & \text { no } & \text { no } & \text { yes } & \text { no } & \text { yes } \\\text { no } & \text { no } & \text { yes } & \text { yes } & \text { yes } & \text { no } \\\text { yes } & \text { yes } & \text { no } & \text { no } & \text { no } & \text { yes } \\\text { yes } & \text { no } & \text { yes } & \text { yes } & \text { no } & \text { no }\end{array}$