Please answer questions a and b using Excel and show formulas.

Incomes		The data in cells A2 through A101 represent salaries of randomly sampled individuals in a particular corporation.
89916.92		(a) (2 points) Using the data from column A, make a 95% confidence interval for the true mean salary for an employee at this corporation.
117660.8		(In addition to creating the lower and upper bounds for the CI, please enter in values for beta, c, n, x-bar, and s to help you
117517		along the way and to show work. Your CI bounds should reference these values)
136976.7
106624.9		Beta	?
132818.9		c	?
87242.34		x-bar	?
137644.2		s	?
58426.79		n	?
47717.23
106573.6		lower bound of CI	?
93959.14		upper bound of CI	?
111637.6
83466.15
122948.5
95019.85		(b) (1 point) Experimental design: Taking this sample to be a pilot sample,
103444.2		determine how large of a sample you should collect if you are targeting your 95% CI for the mean to have a tolerance level of L = 2000, i.e.
141480.8		if you want your 95% CI to look like x-bar plus/minus 2000.
103204.8
102968.5		n	?
72719.05
75172.47
105903.1
84806.84
140789.8
75836.11
72380.18
63158.35
117136.1
57865.84
99424.67
143834
100779
62872.92
113070.5
82002.36
97094.84
150033.1
96796.88
79849.11
74081.8
119453.7
145499.9
117760.5
116201.7
89954.74
85171.21
87081.32
108259.8
92786.12
37296.65
93486.29
83260.36
136264.1
93355.87
88675.79
134353.6
78010.78
115497.3
38790.72
134318.7
47694.06
131252
88409.57
110164.1
112705.3
81539.74
116861.2
107872.6
156848.8
78529.38
77625.38
118128.9
103038.1
99990.13
142299.5
112562.5
109149.2
168567.4
111606.4
95491.07
97482.64
126268.8
121830.7
87010.66
109551.1
94657.96
70991.89
161109.1
144654
122657.1
103753.8
80489.46
51543.68
96937.38
105221.7
74320.26
125688.4
141477.5
52415.73