Please show all steps USING ONLY EXCEL FORMULAS The brand manager for a brand of toothpaste must plan a campaign designed to increase brand recognition. He wants to first determine the percentage of...

Please show all steps
USING ONLY EXCEL FORMULAS

The brand manager for a brand of toothpaste must plan a campaign designed to increase brand recognition. He wants to first determine the percentage of adults who have heard of the brand. How many adults must he survey in order to be 80​% confident that his estimate is within five percentage points of the true population​ percentage?

a) Assume that nothing is known about the percentage of adults who have heard of the brand.

n=?

b) Assume that a recent survey suggests that about 76​%

of adults have heard of the brand.

n=?

c) Given that the required sample size is relatively​ small, could he simply survey the adults at the nearest​ college?