Question
Incomes 89916.92 117660.8 117517 136976.7 106624.9 132818.9 87242.34 137644.2 58426.79 47717.23 106573.6 93959.14 111637.6 83466.15 122948.5 95019.85 103444.2 141480.8 103204.8 102968.5 72719.05 75172.47 105903.1 84806.84
Incomes |
89916.92 |
117660.8 |
117517 |
136976.7 |
106624.9 |
132818.9 |
87242.34 |
137644.2 |
58426.79 |
47717.23 |
106573.6 |
93959.14 |
111637.6 |
83466.15 |
122948.5 |
95019.85 |
103444.2 |
141480.8 |
103204.8 |
102968.5 |
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 |
The data in cells A2 through A101 represent salaries of randomly sampled individuals in a particular corporation.
(a) (2 points) Using the data from column A, create- a 95% confidence interval for the true mean salary for an employee at this corporation. (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 along the way and to show work. Your CI bounds should reference these values)
Beta = |
C = |
x-bar = |
S = |
N = |
lower bound of CI =
upper bound of CI =
(b) (1 point) Experimental design:Taking this sample to be a pilot sample, 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. if you want your 95% CI to look like x-bar plus/minus 2000.
N =
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started