Airlines Katar Airlines Lusiana Airlines Go-Indio Spice Jet Indiana Airlines East-West Airlines Ethihad Emiritus Air Malaya

Download as xlsx, pdf, or txt
Download as xlsx, pdf, or txt
You are on page 1of 29

The following is the average amount of money each major airline

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

count per passenger? A new airline is


e and why?
Sales A Sales B
42 52
49 55
70 57 Max 70
65 52 Min 33
33 47 CI
38 53 31-40
57 52 41-50
35 53 51-60
59 52 61-70
52 53
68 54
35 51
33 53
55 46
70 53
47 52
35 52

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

Daily Wages Factory A Factory B


10--20 15 25
20--30 30 40
30--40 44 60
40--50 60 35
50--60 30 20
60--70 14 15
70---80 7 5
You are given in the adjoining table the wages paid t
workers in two factories X and Y.
(a) Which factory pays higher wages ? By how much?
(b) In which factory are wages variable
(c) Which factory has to pay more wages in a month
assuming that both work for 20 days in a month
he wages paid to the

? 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

80 165 159 143


136 138 118 120
159 131 93 145
163 136 163 142
106 136 163 142
144 145 91 112
170 105 131 141
137 152 109 122
114 155 92 143
s recently decided to review the weekly milege of the delivery ve
hased online to customer homes from a central parcel depot. Th
first stage in analyzing the economic benefit of potentially mo

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

am with class intervals of classes


by the company vehicles
Variance, and CV
e and measure of dispersion
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

80 165 159 143


136 138 118 120
159 131 93 145
163 136 163 142
106 136 163 142
144 145 91 112
170 105 131 141
137 152 109 122
114 155 92 143
MEAN 134.3333333 140.3333333 124.3333333 134.4444444
MEDIAN 137 138 118 142
s recently decided to review the weekly milege of the delivery ve
hased online to customer homes from a central parcel depot. Th
first stage in analyzing the economic benefit of potentially mo

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

am with class intervals of classes


by the company vehicles
Variance, and CV
e and measure of dispersion
Bakers Ltd run a chain of Bakery shops and is famous for the q
concerned at the number of complaints from customers who
The motto of the company is to have Pie in two minutes. The
data on the time it takes to customers to enter the shop and b
below:
(a) From the data set calculate the mean and Median
(b) Repeat the analysis to calculate the standard deviation Qu
(c) Describe the shape of the distribution. Do the results sugg
to serve the customer
(d) Which measures would you recommend the Shop Manage
customers?
(e) What conclusions can you draw from these results?

0.7 0.7 0.7 0.7 0.7 0.7


0.99 0.99 0.99 0.99 0.99 0.99
0.12 0.12 0.12 0.12 0.12 0.12
0.7 0.7 0.7 0.7 0.7 0.7
1.88 1.88 1.88 1.88 1.88 1.88
0.55 0.55 0.55 0.55 0.55 0.55
1.38 1.38 1.38 1.38 1.38 1.38
0.8 0.8 0.8 0.8 0.8 0.8
1.25 1.25 1.25 1.25 1.25 1.25
1.48 1.48 1.48 1.48 1.48 1.48
is famous for the quality of their Pies. The management of the company is
m customers who say it takes too long to serve customers at a particular bra
two minutes. The manager of the branch concerned has been told to provid
nter the shop and be served by the shop staff and has presented the data as g

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?

0.7 0.7 0.7 0.7


0.99 0.99 0.99 0.99
0.12 0.12 0.12 0.12
0.7 0.7 0.7 0.7
1.88 1.88 1.88 1.88
0.55 0.55 0.55 0.55
1.38 1.38 1.38 1.38
0.8 0.8 0.8 0.8
1.25 1.25 1.25 1.25
1.48 1.48 1.48 1.48
the company is
at a particular branch.
een told to provide
ented the data as given

and SIQR.
in the time taken

me taken to serve the

You might also like