+1 (208) 254-6996 [email protected]
  

3 excel need to do it , i want to know the work in e-xcel.

A sample of 400 orders for take-out food at a local pizzeria found that the average cost of an order was $25 with s=$18.

Don't use plagiarized sources. Get Your Custom Essay on
Finish This E-Xcel Problem
Just from $13/Page
Order Essay

(a) Find the margin of error, if we use a 95% confidence interval, for the average cost of an order.

(b) Interpret for management the margin of error.

(c) If we need to be 99% confident, does the confidence interval become wider or narrower?

(d) Find the 99% confidence interval.

Data

EmployeeGender
Christopher J. Zappe, Ph.D.: CODING: 1 for female, 0 for male.
Age
Christopher J. Zappe, Ph.D.: Age at last birthday (in years).
Prior Experience
Christopher J. Zappe, Ph.D.: Number of years of relevant professional experience prior to hiring at Beta Technologies.
Beta Experience
Christopher J. Zappe, Ph.D.: Number of years of professional experience at Beta Technologies.
Education
Christopher J. Zappe, Ph.D.: Number of years of post-secondary education.
Annual Salary
1139512457700
2044128676400
302402444000
412521441600
50565258163900
6141910472700
713362660300
8037116463500
915112166131200
1002301439200
1103154662900
1212708026200
13047119474500
1413555664800
1512954021600
16046415681900
1715010174115400
1803036457800
19134101455800
20142118476100
2115110158135700
2206316204140400
2302805455400
2413241449700
2505511166134800
26145202476900
27034212228700
2803327458800
2912301443100
30040413682400
31148615480100
3212706027000
3313655658800
340589224133100
3503111653700
3612101226700
37047516481300
3813537455400
3915212148139900
4002933233200
41142117475000
4206010214128200
43150813476800
4413312654200
4502605232600
4603866659200
47144712474800
4802503445500
4913785446500
5005313136136300
51046718486900
5212001023900
5313451652700
541601213492700
5513667459500
5604163669400
5713331646600
5802938461700
59048119488200
6014304645000
61161105052200
6203051661400
63136519487500
641487234103700
6512956454000
6602611234125100
67149511245900
68028102679300
691442056108600
70148013668200
71050021265200
721481214495600
7313016124103100
7414120234143500
75035115478200
7612833440200
7713385460500
7816107440500
79153108473800
8014844445300
8104791461400
8214847664800
83155113675600
84032119695800
850601148126700
86050102467000
8714916124102600
8802243452000
89151910476000
9012203883000
91147813480800
921411010691100
9302431030100
9416457455700
95143011451400
9602231443800
9715901425000
980321015280600
9914585239600
10004701213400
101129618488200
1020619156109100
10315731434200
10416549457800
10503467468100
106054613694900
10713055663200
108139616482700
10903278685600
11012427227100
111040103469800
112052134481300
113028115478400
1140532096127300
115043024493700
11603056674400
11704633448300
1181381013698900
119028016473300
12014611196117300
12113055037800
122143614477400
1231291118111200
124048114475300
125042717496900
12601810196123600
12703562455200
12812201012400
129144415473900
130147204494100
131134108474300
132137114466900
13314904212500
134032018690200
13513758459000
13612910196114700
137024715271700
13804320180125500
13915411174100200
14012604645400
141047104472200
142131512469500
143033111467900
14404227667500
14513421431800
146159010227800
14714354660200
14813022434500
149145712687000
15015004212500
1510230158122700
15214457456200
153048106256900
154147412466000
155020114476000
156131016244100
157030018478500
158142513471800
15912597680700
160124215247800
16103613134105000
1620326156100700
16312721018300
16405512126110600
16503602436800
16612204645500
167125014671400
168147514474300
16904316118160600
17015307652500
17103857465000
17203912144104500
173135518485000
1741233108110200
175043107480100
17613333440000
177144101455900
178133016464600
179131013668600
18013678465100
18114513194111700
182145121462000
18303927455800
184045511254600
18502511437600
18613407441200
18715306649900
18803546459400
189152313465500
190133103673200
19114903430500
192159617484800
193135169495200
1941441111484900
19516111184102600
196143111459000
19703005444800
198032112470500
199057104683700
20014410184100000
20114424439300
20214507220400
203043012674300
20403311194114500

This is fictitious data.

Data

QuarterAdvertisingRevenue
1$30,000$1,200,000
2$20,000$880,000
3$15,000$1,800,000
4$40,000$1,050,000
5$10,000$1,700,000
6$50,000$350,000
7$5,000$2,500,000
8$40,000$760,000
9$20,000$2,300,000
10$10,000$1,000,000
11$60,000$1,570,000
12$5,000$2,430,000
13$35,000$1,320,000
14$15,000$1,400,000
15$70,000$1,890,000
16$25,000$3,200,000
17$30,000$2,200,000
18$60,000$1,440,000
19$80,000$4,000,000
20$50,000$4,100,000

This is fictitious data.

Data

StudentA201A202E201E202E270K201L201M118M119W131Core
13.73.3333.33.33.74232.76667
22.322.32.332.72.33.3331.66667
3223.322.72.732332.1
444233.73.72.7222.73.66667
52.72.32.732.72.32.33.7432.03333
6343.733.343.33.343.33.1
733.733.33.73.72.73.7222
83.33.32.7343.33.733.733.56667
92.32.333.33.7333.33.73.72.66667
102.73.332.32.732.732.732.43333
1142432.323333.32
123.73.31.723.74421.732.56667
1344444443.7443.9
1443.73.72.73.73.73.33.73.742.53333
15433.33.3333343.32.9
163.333.73.33.73.333.7442.8
17443.72.332.33.3343.33
183.332.32.32.72.72.33.7441.86667
1943.33.322232.333.72.8
2032.74233.32.33.343.73
2132.3442.72.73.32.32.33.71.9
223.32.73.32.32.3333341.86667
233.33.733333.33.73.33.33
2423.33.333.3443.343.72.76667
2543.7333.333.73332.43333
263341.733.72.71.33.342.66667
273.33433.3334432.56667
282.32.331.73.32.32.7343.71.86667
292.73.333.3443.73342.96667
3043.73.74444443.33.33333
313.33.3332.72.72.33.743.72.86667
3233.73.343.744443.72.76667
3343.342.3333.33.3332.46667
342.333.72.73323.73.73.32.76667
353.33.33.72.73.73423.342.86667
363.73.73.73.72.33.742.72.72.73.66667
373.73.732.333.73.743.73.32.66667
383332.324333.333.33333
393.333.343.742.74432.56667
403.743.33.32.72.73.72.733.33.23333
41222.332.32.334332
422.33.73.33.33343.32.33.32.56667
432.332.732.333.73.33.72.71.76667
44332333.343.333.31.96667
452.34333.32.72.32.333.32.33333
4632.73.33.32.32.32.73422
473432.72.32.734231.23333
4843433334432
4922.3333332432.43333
5033.7333.73.72.7443.33.1
511.723.322.72.72.74331.46667
523.73.72.733.7432433
53322.732.332233.71.53333
54423342.732342.76667
552.73.33.72.7232.73.3231.9
5643.342.733.343.743.73.03333
573.33.72.74323223.72.66667
583322.7323232.32.33333
594332.73.341.74331.8
60222.32.73.33.33.32.743.72.23333
61232.32.7232.731.73.72.1
62433.73.73.73.743.3423.33333
6333.3233.33.323232.76667
642343233223.71.56667
653.33.332.74441.72.73.32.76667
66433.74444443.73.13333
673.33.33.33.73.3334332.23333
682.72.742.333.32.712.33.72.13333
692.72.7333.333343.32.43333
70443343.34442.73.66667
7133332.733.322.332.66667
722.72.343232343.72.9
7343.743.73.744443.73.33333
74334333.3343.732.53333
752.332.72.72.32.73.723.33.72.43333
763.343.3333343.73.72.8
773.33333333.73.33.72.66667
783.743.73.7333.74322.9
79331.72.33.33.73.332.732.66667
803.332.73.33.33333.733
81334443.743443
823.33.33.733.33233.342.66667
834443.743.744443.33333
843.33.33.333.72.733333
8542.73.333.732.32.332.72.66667
862.33.733.32.72.32.3332.72.56667
87332.322.33321.731.53333
88342.72.73.332.72.32.33.32.23333
893.743.3343.733.333.72.1
9032.322.32.733332.31.43333
912.33334333.743.32.23333
9244442.744442.73.43333
933.332.73.3443.34343
94222.7342.72343.72.9
953.33.33.72.3443.7333.72.66667
9633.33.32.72.72.312.342.72.33333
973422.32.72.33.72.71.322.2
982.7333.32.72.732.73.742.13333
992.724433.73.7332.32.33333
10033.72.72322.33331.76667
10132.32.72.342.73.343.342.66667
10232.32.323.33.32.72.743.31.8
1034434344323.32.33333
1042.3232.33.3332.3432.33333
1052.72.32.72.73233.73.33.71.76667
1062.72.3312.72.33.3332.32.1
1074443.733.334441.76667
1083.7243.72.33.7343.741.8
109443.733.743.73443.66667
1103.33.73.333.33.742.72.33.73.2
1112.732.722.3333.72.743.13333
1122.332.72.742.733241.66667
113443.73.73.343.73.743.73
11432.72.331.732.33.73.731.7
11524344432322.33333
11632.72.323.32.3342.342.36667
1172.323.722.32.72.33.732.31.66667
1182233.733.724431.66667
1193.32333332.73.732.2
120332.72.7343.342.72.72.46667
12133.32.32.733.33.73.723.32.66667
12233442333241.76667
1233.332.7223.332.72.32.32
12432.332.33.732.73.73.72.73.46667
1253.31.732.32.72.33433.33.46667
1261.72.72.722.73.332.73.72.31.03333
12732223.333.7233.32
1282.32222.72.32.3443.32.23333
1292.72322.3343431.66667
1301.31.73.72.72.72.7223.71.71.76667
1313.33.3443.332.733.73.33.23333
1322.733.33.3433.33.7442.96667
13323323.7243332.33333
13443.32.32.732.743342
1352.33.7443.7333.743.32.66667
1363.742.73.744443.32.33.43333
13733.33.33.73.733.71.7243.3
13822.71.73333.342.33.71.66667
1393.32433.33.73.3333.32.86667
140332.722.73.322.72.732.56667
1413242.71.72.723.3432.23333
1423.33.7323.73.73.34332.23333
1432.71.73.73.33.33.3143.73.72.53333
1443.333.32.73.33.732.33.722
145334333.33.73432
1463.72.72.7433.33.33.3342.53333
1472.74341.7123.3441.46667
14822.72.733.72.73.7222.72.76667
14932.72.72.742.71.72.33.73.71.9
1503.732.733.73.743442.76667
1512.72.73.732.33431.732.23333
1524332.331.7332.73.32.46667
15322.73.7432.71432.71.23333
154343343223.332.23333
1551.7222.73.33.33.33.33.73.72.66667
156243.33.72.32.32.733.332
15722.332.32.72.71.7442.72.2
1583.33443.73.33.72433
15922221.72.73.732.741.8
1602242.732.333341.86667
1613232.343.732322.76667
162443.71.34414332.53333
1633342.32.334443.32.23333
16433.33.72.73.73.73.33.343.32.9
1652.32.7433.33.32.32.32.33.72.33333
16622.332.73.33.32.32.743.32.96667
1671.72.733.73.33.72.332.72.32.1
16833.732432.733.72.72.33333
16943323.73.732.73.342.56667
1702.7332.32.33.32.32.331.72.2
171323.332.7342322.33333
17232.32.73.32.333.32.3241.8
1733443.73.33.73.34443.33333
1742.31.72.32.323.73443.71.9
17532.73.732.72.732.3441.76667
1762.72.3333.72.73.33.343.72.13333
1772.733.73.73.33.33.733.333.33333
1783.72.33.32.342323.332.43333
1792.72.72.733.732.72.743.71.56667
18022.333.72.733.332.73.72.56667
1812.72.33322.72.73242.76667
18233333.73.7233.732.43333
18322.333.32.33331.73.72.56667
1842.333.333.32.73.332.732.53333
185333.3332.32.7323.32.33333
18632.73.7332.73333.31.86667
18734444334422.1
1884343.3333.32.313.31.13333
1892.334432.732.31.732.13333
190322.732344342.3
1914443.73.73.73.343.73.73.33333
1923.3223.723.7421.741.46667
19322.73.3333.32.33.733.72.33333
19432343433342.13333
19533.3332.3432.732.31.86667
19633.33.323.32.332232.1
1972.32.73.31.71.73.343.33.732
1984443443.73.333.33
19944323.732.33.7342.8
200333.33.333.733.73.743.03333
2012.72.72.722.73.72433.33.1
2022.73.7333.72332.741.46667
2033.72.743.73.32.73.33.332.33.23333
2042.33222.332.73.73.732.23333
2053.343343.732.33.73.32.8
2063.72.732.33.343.333.743
207443.333.33.33.333.333
20842.73.3342.73343.73.23333
20932.33.32.73.33222.332.23333
21033233433242.33333
2113.323.73.32.72.72.733.722.46667
2123.332.32.731.33.7233.32.43333
2133.7334332.73322.3
214333.323.744443.72.9
2151.73.31.73.72.33.32.743.742.7
2162.732.32.33.33.71.73.33.332.9
21744344434342
218324341.71.72333
2194443.74443.7433
22023223.7333.7232.53333
2213.7242.32.732.33.72.332.33333
2222.323222.333.33.731.43333
2233.32.7132.743.322.33.31.9
224232.33.3342.32.3443.3
225443.343.33.743443
2263.32.33.333.3332.33.73.72.53333
2272.322.343.332243.72
2282232.342.333.32.731.9
22932.723.3222.32.32.32.71.33333
2303.33.33.32.32.33.3443.342.66667
2312.722.72.33.32.7322.742
2322.333.73.72.73.32.332.322.56667
23333.34433.3342.742.56667
2342.322.31.733.343.73.342.76667
23532.732.32.72.332.343.32.33333
2362.73.33.342.32.32.32.7432.56667
2374444444443.33.53333
23832.722.73.72.73.33.73.33.31.8
23933233.73.731.742.71.66667
24041.7232.72.3423.72.72.66667
2413.73.72.32.732.3331.33.72.43333
242332.723.32.73.72.32.73.72.9
243444443.733.7433.56667
24433.7323.333.3433.33.23333
24543.7444443.3433.66667
2462.73.73.32.72.33.7333.73.72
2473.7443.33.33.73.7343.33.33333
24842.72.3444430.731.66667
2493.32.73.3333.33.33.733.32.2
25033.33.33.7233333.32.56667

This is fictitious data.

Order your essay today and save 10% with the discount code ESSAYHELP