Airlines Katar Airlines Lusiana Airlines Go-Indio Spice Jet Indiana Airlines East-West Airlines Ethihad Emiritus Air Malaya
Airlines Katar Airlines Lusiana Airlines Go-Indio Spice Jet Indiana Airlines East-West Airlines Ethihad Emiritus Air Malaya
Airlines Katar Airlines Lusiana Airlines Go-Indio Spice Jet Indiana Airlines East-West Airlines Ethihad Emiritus Air Malaya
Airlines
Katar Airlines
Lusiana Airlines
Go-Indio
Spice Jet
Indiana Airlines
East-West Airlines
Ethihad
What is the mean baggage handling cost per passenger? What is th
Emiritus Which of the above average it should c
planning to start operations.
Air Malaya
Mean
Median
ount of money each major airline operator spend per passengers get on baggage han
Amount ( in Rs '000)
3.17
6
2.41
7.93
5.9
1.76
0.98
ing cost per passenger? What is the Median baggage Handling count per passenger?
6.77 consider for planning purpose and why?
ch of the above average it should
7.15
4.67444444444444
5.9
ers get on baggage handling
65 48 CI
45 54 31-40
56 53 41-50
50 59 51-60
63 57 61-70
58 50
33 48
53 53
57 51
52 51
48 59
43 54
bin
40 Histogram
50 10
9
60 8
7
70
Frequency
6
5
4
3
bin Frequency 2
1
40 7 0
40 50 60
50 6
Sales
60 9
70 6
More 0
Frequency
7
6
9
6
Histogram
50 60 70 More
Sales
PQR company employs 500 workers, of which 72 are ma
remaining 275 are manual workers. The montlly pay of
500
ny employs 500 workers, of which 72 are management staff, 153 are clerical,
75 are manual workers. The montlly pay of each class of employee is as follow
Class Pay(Rs) X
Management Staff 6,000
Clerical Administrative and Technical 3,000
Manual workers 2,000
Pay (X)
Mean Pay
aff, 153 are clerical, administartive and technical staff, while the
employee is as follows:Calculate mean wages of the employees
No(f) W
72 432000
153 459000
275 550000
1441000
2882
le the
oyees
Based on the following data answer the questions
? By how much?
le
ages in a month
in a month
Date Nifty INFY Reliance Ind ICICI
6/30/2019 11811.15 718 1263.35 436.35
5/31/2019 11788.85 721.804 1253.1 437.1
4/30/2019 11922.8 727.474 1330.15 423.7
3/31/2019 11748.15 740.884 1392.8 407.5
2/28/2019 11623.9 733.489 1363.25 400.5
1/31/2019 10792.5 724.072 1231.05 350.15
12/31/2018 10830.95 739.109 1227.15 364.45
11/30/2018 10862.55 649.771 1121.25 360.15
10/31/2018 10876.75 658.153 1167.55 355.15
9/30/2018 10386.6 669.548 1061.25 355
8/31/2018 10930.45 712.126 1257.95 305.55
7/31/2018 11680.5 702.859 1241.65 341.076
6/30/2018 11356.5 665.792 1186 299.548
5/31/2018 10714.3 617.048 966.49 271.144
4/30/2018 10736.15 581.456 915.703 281.383
3/31/2018 10739.35 566.209 957.396 279.808
2/28/2018 10113.7 534.253 877.29 274.048
1/31/2018 10492.85 553.512 948.7 308.409
12/31/2017 11027.7 542.962 955.408 347.495
11/30/2017 10530.7 491.887 915.405 309.147
10/31/2017 10226.55 460.756 915.902 302.797
9/30/2017 10335.3 423.164 935.083 295.462
8/31/2017 9788.6 413.089 776.114 272.325
7/31/2017 9917.9 419.997 792.364 293.443
6/30/2017 10077.1 464.179 790.964 297.923
5/31/2017 9520.9 416.487 675.787 281.037
4/30/2017 9621.25 434.962 656.542 287.452
3/31/2017 9304.05 409.097 683.23 245.23
2/28/2017 9173.75 455.084 646.846 243.778
1/31/2017 8879.6 450.699 606.274 243.337
12/31/2016 8561.3 413.393 511.835 236.821
11/30/2016 8185.8 449.897 1006.041 224.802
10/31/2016 8224.5 434.294 484.828 233.827
9/30/2016 8638 434.642 516.61 243.778
8/31/2016 8611.15 451.439 530.689 222.028
7/31/2016 8786.2 451.352 519.083 227.179
6/30/2016 8638.5 467.91 496.997 231.494
5/31/2016 8287.75 498.41 474.593 207.116
4/30/2016 8160.1 531.551 469.06 210.645
3/31/2016 7849.8 514.289 481.229 204.016
2/29/2016 7738.4 518.631 501.315 203.757
1/31/2016 6987.05 461.481 463.64 163.635
12/31/2015 7563.55 495.899 496.615 198.161
11/30/2015 7946.35 470.57 486.638 225.024
10/31/2015 7935.25 463.12 463.856 235.529
9/30/2015 8065.8 474.552 454.551 238.499
8/31/2015 7948.9 485.628 413.59 232.774
7/31/2015 7948.95 457.396 833.751 267.511
6/30/2015 8532.85 450.144 480.523 260.369
5/31/2015 8368.5 375.536 479.684 260.259
4/30/2015 8433.65 385.923 410.979 268.075
3/31/2015 8181.5 370.491 404.114 279.82
2/28/2015 8491 423.158 387.079 266.596
1/31/2015 8844.6 432.2 400.927 283.285
12/31/2014 8808.9 408.575 428.904 304.79
11/30/2014 8282.7 376.271 417.61 298.368
10/31/2014 8588.25 415.828 464.683 296.492
9/30/2014 8322.2 362.728 468.877 274.903
8/31/2014 7964.8 335.554 443.173 242.268
7/31/2014 7954.35 322.218 468.01 263.098
Greendelivery.com has recently decide
deliver shopping purchased online to c
collected is part of the first stage in an
biofuels from diesel
(a) Use Excel to construct a frequency
75-84, 85-94, ...175-184. Comment on
(b) Use the raw data to determine mea
(c) Comment on which measure you w
uct a frequency distribition and plot the histogram with class int
84. Comment on the pattern in mileage travelled by the compan
o determine mean, median, standard devaition , Variance, and C
h measure you would use to describe the average and measure o
140
124
109
80
80
146
122
126
165
of the delivery vehicles used to
parcel depot. The sample data
potentially moving vehicles to
uct a frequency distribition and plot the histogram with class int
84. Comment on the pattern in mileage travelled by the compan
o determine mean, median, standard devaition , Variance, and C
h measure you would use to describe the average and measure o
140
124
109
80
80
146
122
126
165
121.3333333
of the delivery vehicles used to
parcel depot. The sample data
potentially moving vehicles to
d Median
dard deviation Quartiles (Q1,Q2 and Q3), Quartile Range and SIQR.
Do the results suggest that there is a great deal of variation in the time taken
d the Shop Manager uses to describe the variation in the time taken to serve
ese results?
and SIQR.
in the time taken