Please answer these question and put them in Excel.

The following data were collected in a clinical trial to compare a new drug to a placebo for its effectiveness in lowering total serum cholesterol.

	New Drug ()	Placebo ()	Total Sample ()
Mean (SD) Total Serum Cholesterol	185.0 (24.5)	204.3 (21.8)	194.7 (23.2)
% Patients with Total Cholesterol < 200	78.0%	65.0%	71.5%

In Problem 2 of this project, you generated a 95% confidence interval for the difference in mean total cholesterol levels between treatments. Now, using this same data,

Generate a 95% confidence interval for the proportion of all patients with total cholesterol < 200.

How many patients would be required to ensure that a 95% confidence interval has a margin of error not exceeding 5%?