Question: Conduct a pareto analysis for the number of minutes that flight

are late in the global airline data excel file. Interpret the results.
Global Airline Flight Statistics

Schedu
led Actual
Arrival Arrival
Time Time
Flight Number Origin Airport
1 373 RDU 08:44 09:09
2 1,926 DFW 19:15 02:44
3 1,924 DFW 16:30 04:23
4 2,009 EWR 11:13 15:33
5 1,512 SLC 16:40 16:45
6 1,032 PHX 19:40 22:18
7 2,016 JAX 13:09 15:35
8 1,790 SAT 16:40 17:15
9 1,684 SJC 13:57 14:18
10 1,908 DEN 18:10 18:44
11 1,920 DFW 14:03 14:35
12 1,617 MEM 16:09 16:36
13 2,088 IAH 12:42 13:10
14 409 CLT 08:48 09:17
15 1,899 RIC 08:51 13:16
16 543 DFW 08:42 09:11
17 1,982 MIA 08:35 09:02
18 1,140 PBI 20:49 20:55
19 28 MCO 14:10 14:15
20 1,896 DEN 05:56 06:17
he number of minutes that flights
e. Interpret the results.
20% of the flights accounted for about 70-80% of the late minutes

Taxi-in
Time
(Minute Time Difference
Time Difference (Minutes) s) (Minutes)
25 9 713
449 13 449
713 8 265
260 12 260
5 16 158
158 9 146
146 8 35
35 10 34
21 11 32
34 7 29
32 10 29
27 13 28
28 12 27
29 8 27
265 7 25
29 19 21
27 16 21
6 39 6
5 13 5
21 6 5
2,315
comulative frequency cumulative percentage
713 30.7991360691145
1,162 50.1943844492441 Chart
1,427 61.6414686825054 2,500
1,687 72.8725701943845
2,000
1,845 79.6976241900648
1,991 86.0043196544277 1,500
2,026 87.5161987041037
2,060 88.9848812095032 1,000
2,092 90.3671706263499
2,121 91.6198704103672 500

2,150 92.8725701943845
0
2,178 94.0820734341253 1 2 3 4 5 6 7 8 9
2,205 95.2483801295896
2,232 96.414686825054 comulative frequency
2,257 97.4946004319654
2,278 98.4017278617711
2,299 99.3088552915767
2,305 99.5680345572354
2,310 99.7840172786177
2,315 100
 Chart Title

3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20

comulative frequency cumulative percentage

Question: A community health survey obtained
the following demographic information from
the respondents. Compute the relative
frequencies and relative frequencies of the age
group.
Health Status Survey

Age Frequency CUMULATIVE FREQUENCY

18 to 29 250 0.130208
30 to 45 740 0.385417
46 to 64 560 0.291667
65+ 370 0.192708
1920
Question: Create a stacked area chart for the monthly
average sales of the different types of fuel. What conclusion
can you reach?
Average Petrol Sales

Year Desiel Ron 97 Ron 95

Jan-17 27.8164 38.4091 12.9671
Feb-17 87.2405 39.0617 59.4576 Char
Mar-17 48.2529 29.9997 70.4036 300.0000
Apr-17 20.5400 30.1349 70.4177
250.0000
May-17 32.1131 81.7516 59.6797
Jun-17 49.3341 35.9776 27.5300 200.0000

Jul-17 18.0533 41.8054 84.1096 150.0000

Aug-17 89.2159 14.3291 12.2439 100.0000
Sep-17 82.9229 98.7664 34.9137
50.0000
Oct-17 70.4538 63.0265 52.6254
Nov-17 99.5798 28.6274 40.3005 0.0000
17 7 7 7 17 7
Dec-17 77.4849 53.9419 74.4210 n- -1 -1 -1 p- -1
Ja ar ay J ul e ov Ja
n
M M S N
Jan-18 50.4937 90.9805 42.2031
Feb-18 53.7036 28.0032 19.9141 Desiel Ro
Mar-18 43.5219 11.6730 97.2014
Apr-18 95.7687 56.5573 88.2445
May-18 11.2715 16.6205 95.4754
Jun-18 21.7692 63.6299 73.0492
Jul-18 48.5029 63.2948 69.6730 Conclusion :
Aug-18 85.2554 92.2885 40.4723 RON95 as the dom
Sep-18 29.5087 94.8133 70.9097 demand ,RON 97 s
moderate sales, an
Oct-18 77.4875 45.9305 84.8901 fluctuating demana
Nov-18 62.4648 44.1008 95.2911
Dec-18 28.9645 19.5844 64.5243
Jan-19 28.7533 62.1207 56.4999
Feb-19 75.3904 46.9051 84.9132
Mar-19 37.7353 37.6354 15.3729
 Chart Title

17 7 7 7 7 8 8 8 8 8 8 9 9
-1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1
ay J ul ep Nov J an Mar ay J ul ep Nov J an Mar
M S M S

Desiel Ron 97 Ron 95

Conclusion :
RON95 as the dominant fuel whith steasy
demand ,RON 97 serving a premium segment with
moderate sales, and Diesel showing niche,
fluctuating demanad influenced by external factors.
Question: Data in the excel file of microchips shows the demand for one type of ch
industria equipment from a small manufacturer.
A. Construct a chart of the data. What appers to happen when a new chip is introd
B. Develop a causal regression model to forecast the demand that includes both tim
introduction to new chip as explanatory variable.
C. What would be the forecast for the next month if the new chip is introduced? W
would be if new chip is not introduced.

Microchips
Chart Ti
Month New Chip Introduced Demand 20000
1 0 3894 18000
2 0 3489 16000
3 0 6083 14000
12000
4 1 10645
10000
5 0 7697 8000
6 0 7711 6000
7 0 5427 4000
8 0 8734 2000
9 1 13048 0
1 2 3 4 5 6 7 8 9 10 11 12
10 0 7271
11 0 8614 Month New Chip Intro
12 0 7164
13 0 7401
14 0 9689
15 1 14506 SUMMARY OUTPUT
16 0 8509
17 0 12159 Regression Statistics
18 0 14696 Multiple R 0.379479
19 1 18965 R Square 0.144004
20 0 14214 Adjusted R 0.103242
21 0 14841 Standard E 4025.267
22 0 15304 Observatio 23
23 0 16472
24 0 16974 ANOVA
df SS MS
Regression 1 57241615 57241615
Residual 21 3.4E+08 16202772
Total 22 3.97E+08

CoefficientStandard Et Stat
Intercept 10128.89 923.4595 10.96842
0 4162.105 2214.378 1.879582
for one type of chip used in

new chip is introduced.

t includes both time and

p is introduced? What it

Chart Title

4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24

Month New Chip Introduced Demand

F Significance F
3.532828 0.074113

P-value Lower 95%Upper 95%Lower 95. Upper 95.0%

3.749E-10 8208.456 12049.33 8208.456 12049.33
0.074113 -442.9462 8767.157 -442.9462 8767.157
Question: prepare a Scatter diagram, Trend line and
Regression Equation

Month Defects/million
1 812
Defects/million
2 810
3 813 870
4 823 860
5 832 850
6 848 840
7 837 830
8 831 820
9 827
810
10 838
800
11 826
790
12 819
780
13 828 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18
14 832
15 847
16 839 SUMMARY OUTPUT
17 832
18 840 Regression Statistics
19 849 Multiple R 0.6994187048
20 857 R Square 0.4891865246
Adjusted R0.4608079981
Standard E9.4427395385
Observatio 20

ANOVA
df SS MS F
Regression 1 1537.024 1537.024 17.23791
Residual 18 1604.976 89.16533
Total 19 3142

CoefficientsStandard Error t Stat P-value

Intercept 816.03684211 4.38645 186.0358 5.141E-31
Month 1.5203007519 0.366174 4.151856 0.000599
on

12 13 14 15 16 17 18 19 20

Significance F
0.000599

Lower 95%Upper 95%Lower 95.0%

Upper 95.0%
806.8213 825.2524 806.8213 825.2524
0.750998 2.289603 0.750998 2.289603