Please tell me how you do it, and not just the answer. There's more to the excel sheet, so I want to be able to apply the formulas to get the true answer

1. Using the CEO Pay worksheet to calculate the confidence intervals for the following:
   • Calculate the confidence intervals for the following alpha values, for the true population mean of CEO pay. Assume the population variance is 19,500,000,000,000.
     1. a=0.10
     2. a=0.05
     3. a=0.01
   • Calculate the confidence intervals for the following alpha values, for the true population proportion of CEOs who are male:
     1. a=0.10
     2. a=0.05
     3. a=0.01

Median Worker	CEO
Annual Pay	Annual Pay
(Cash)	(Cash)	Gender	Gender (1 if Male)
$27,900	$12,105,481	M	1
$59,900	$23,652,883	M	1
$71,400	$26,208,003	M	1
$22,400	$7,330,584	F	0
$54,800	$17,047,636	M	1
$55,800	$16,819,942	M	1
$33,900	$9,665,925	F	0
$81,600	$22,767,851	M	1		2a)	Mean CEO Comp.
$50,100	$11,930,391	M	1			Sample Size
$54,700	$12,779,784	M	1			Population Variance	19,500,000,000,000
$92,900	$21,565,325	M	1
$79,400	$18,263,525	M	1		2b.)	Sample Portion
$62,000	$13,649,028	M	1			Sample Size
$51,100	$10,947,607	M	1