Answer all the questions use excel

profilesevenczj
etb1100_a2_2014-data.xls
Home>Business & Finance homework help>Accounting homework help>Answer all the questions use excel

Qn1

ETB1100, S2 2014 Ass2 data
Time Required to Serve Customers at a Fast Food Restaurant's Drive-Up Window
Time
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
Measured in minutes.

Qn2

ETB1100, S2 2014 Ass2 data
Memory card No. Card Capacity, MB/s
1 9.90
2 9.69
3 10.47
4 9.76
5 7.32
6 10.01
7 9.85
8 8.67
9 11.91
10 10.31
11 10.30
12 10.94
13 8.76
14 9.97
15 8.69
16 10.48
17 9.31
18 9.95
19 9.32
20 9.02
21 8.83
22 8.63
23 9.61
24 9.76
25 10.46
26 9.92
27 8.69
28 9.33
29 10.23
30 8.57
31 10.64
32 8.22
33 9.88
34 8.75
35 11.05
36 8.30
37 9.37
38 11.01
39 8.79
40 9.23
41 10.60
42 9.96
43 10.28
44 9.83
45 10.08
46 10.15
47 8.81
48 9.17
49 10.18
50 8.71
51 9.12
52 8.62
53 10.49
54 9.99
55 10.78
56 7.28
57 9.69
58 9.17
59 9.23
60 9.35
61 9.36
62 9.40
63 9.87
64 10.38

Qn3

ETB1100, S2 2014 Ass2 data
Outlet_Number Price, $ Quantity Sold
1 14 85300
2 15 60500
3 16 61800
4 16.5 50800
5 16 60600
6 14 79400
7 15.5 71400
8 15 70700
9 16 55600
10 16 70900
11 14.5 77200
12 16.5 63200
13 16 65100
14 18 38575
15 13 90285
16 14 75500
17 15.5 52100
18 17 40000
19 15.5 70000
20 16 60500