Details of this Paper

In the Data Analysis & Decision Making with Microsoft? Excel textbook, complete Chapter 3 Problem 4 on page 103.

Description

solution


Question

In the Data Analysis & Decision Making with Microsoft? Excel textbook, complete Chapter 3 Problem 4 on page 103.;Instructions;Place all problems for this assignment in one Excel file.;Use separate worksheets to display your answers.;Problem 4: The manager of a local fast food restaurant is interested in improving the service provided to customers who use the restaurants drive up window. As a first step in the process, the manager asks his assistant to record the time (in minutes) it it takes to serve 200 customers at the final window in the facilities drive up system. The 200 customer service times given in the file p02_04.xlsx are observed during the busiest hour of the day for this fast food operation.;A. Compute the mean, median, and mode of this sample of customer service times.;B. Which of these measures do you believe is the most appropriate one in describing this distribution. Explain the reasoning behind your choice.;Attachment Preview;P02_04.xlsx;T ime Required to Serve Customers at a Fast Food Restaurant's Drive-Up Window;Time;0.9210;0.9062;0.4152;0.4629;2.3724;0.8223;0.6380;0.1645;0.2240;0.7876;0.7912;0.6705;1.2476;0.9485;0.8875;1.2092;1.5587;1.0332;0.7688;0.3374;0.5669;1.1596;0.5467;0.5670;1.0895;0.3845;0.9730;0.5162;0.3996;0.2990;1.2572;0.0774;0.7647;0.1338;0.2715;1.5919;0.9238;0.7125;1.4948;0.7360;0.7943;0.3798;1.4247;1.1885;0.2426;0.3538;0.8499;1.0430;1.4960;0.3475;1.2874;1.2216;0.7294;1.6080;1.1465;1.2259;0.8819;1.0060;0.3746;1.3054;1.5990;0.2641;1.0593;0.4233;1.0103;1.2978;0.4145;1.4390;0.6813;1.1314;0.7111;1.3309;0.4257;0.7676;0.6232;0.8000;1.3467;0.4841;0.9823;1.0916;1.2901;0.8386;1.7934;1.5242;0.9559;0.4714;1.1600;0.6556;0.5071;1.4707;1.0641;0.6471;0.7643;0.9964;1.8362;0.9933;0.3534;0.1788;1.8126;0.5177;0.7823;0.3799;0.8715;1.0877;0.7285;0.8686;2.0357;0.2041;0.7851;0.8409;0.5361;1.6160;1.0762;0.5227;0.7201;1.0519;0.4184;0.5795;1.6800;1.1775;0.2798;0.4259;0.6184;0.8745;0.8020;1.1582;1.4568;0.8147;2.3493;0.7240;0.5007;1.3223;0.6482;0.5117;0.6468;0.2303;0.5763;0.4434;1.1398;1.1516;0.9638;1.6103;0.5343;0.9617;1.4219;0.7661;1.3056;1.3317;1.1563;0.7590;0.5905;0.5344;0.8519;0.9404;1.2190;0.7197;1.5434;1.3066;0.7087;0.7383;1.3805;0.8542;0.9996;0.9943;0.8771;1.1677;1.1068;0.8875;1.6927;0.6500;0.0953;0.8476;0.5168;0.3019;0.8200;0.9122;0.4629;0.6410;0.8190;1.3315;1.3008;0.8198;1.0732;1.1238;0.4029;0.6853;0.4573;0.6719;1.1921;0.9364;0.1880;1.2267;0.3181;1.0830;0.5179;0.3734;0.5219;1.2482;1.0504;0.7163

 

Paper#32326 | Written in 18-Jul-2015

Price : $46
SiteLock