For each of the problems unless stated otherwise. First state what is given in the problem and the formula needed to calculate the problem. Then calculate the problem both by hand and in excel. Copy and past the formula used in excel. Make sure the answers are easy to identify in both sections. By completing the questions by hand and in excel it provides a double check on your work.

A sales and marketing management magazine conducted a survey on salespeople cheating on their expense reports and other unethical conduct. In the survey on 200 managers, 58% of the managers have caught salespeople cheating on an expense report, 50% have caught salespeople working a second job on company time, 22% have caught salespeople listing a "strip bar" as a restaurant on an expense report, and 19% have caught salespeople giving a kickback to a customer. Construct a 95% confidence interval estimate of the population proportion of managers who have caught salespeople cheating on an expense report. (only figure by hand not compatible with excel)(2pts)

Given

Formula to solve problem

Hand calculation