Question

4. Box-Plot: Create a box-plot for the “Car Mileage” and the “Height in Inches” data on...

4. Box-Plot: Create a box-plot for the “Car Mileage” and the “Height in Inches” data on separate graphs. Use Microsoft Excel to compute the essential features of the box-plot (Median, Quartiles, IQR, Outliers). You can create your box plots by hand on a separate sheet of graph paper. Be sure to indicate the key features of a box-plot on your graph, namely, the median, lower and upper quartiles, inner and outer fences and be sure to indicate outliers. Comment on whether the data appears skewed (left/right-skewed) or symmetric.

CAR MILAGE DATA

41760
78758
65069
80318
96974
55635
55046
112489
75569
183249
67492
139697
162474
79863
38753
111302
122719
61951
39037
72370
104293
53063
99528
71279
74697
70830
173195
47711
70328
48320
70820
158279
93756
70461
58590
61362
60971
106178
88601
82246
71292
61334
51220
63123
49044
82383
87883
116263
113383
45605
96938
67933
61157
114483
57791
178849
80279
133219
67654
74611
66055
107358
57811
62679
156086
78611
81779
53463
105498
110414
178462
55052
54193
35523
55304
138310
66742
101381
173936
73969
78677
85217
91639
52574
72567
49326
39934
128147
50934
41918
97527
148681
95343
164647
89582
91276
55818
93037
85985
126902
91898
130092
63269
72315
73283
249430
28483
141008
41165
72514
141066
85664
28317
92928
70400
128293
125178
93536
105298
44872
54514
42961
68864
103368
71691
152787
100892
108182
101696
56849
66092
62677
83483
87089
113630
134968
63323
101511
36452
99625
62359
119388
29682
64663
120623
151138
112901
73049
76114
96394
86582
54674
59290
110972
84456
115073
240230
98822
11893
77854
86672
170681
96901
57974
96738
144871
59471
64437
156494
148518
136158
119849
70959
72419
71219
127233
67534
58940
52319
68735
110010
108712
77023
68178
98740
100494
58679
99410
50826
106129
70788
66698
64832
126220
62990
104851
54690
73657
40739
40287
55622
58103
138801
81157
59210
112161
57277
77246
92541
133533
46152
117817
41566
113553
49423
67610
47408
49772
94625
42458
49124
116643
68757
129715
123688
66673
118382
115525
87537
65370
136488
68115
154889
39927
100955
55558
199486
55803
35842
81347
57282
46930
36763
57009
55472
91296
108929
50392
155759
50405
65262
80340
110411
82422
46676
56105
95001
76849
52554
168921
154533
43956
89765
75472
164379
63139
103132
48483
108050
108688
148662
166928
51679
120735
46868
96118
41358
69941
143084
118233
63117
39424
98890
129560
65238
72448
85509
57376
53766
46833
66153
145038
73561
40829
35915
65324
64567
59811
111014
137885
159372
48542
57022
95668
142658
78973
51559
49187
67713
67820
110931
73229
119398
42510
158000
113071
115000
89567
137564
143690
48144
71998
51804
44410
22311
49907
145368
104715
110423
62619
104642
85523
80247
166951
68968
118624
60593
77090
86351
65189
56796
102181
59504
80173
165092
65260
91845
35523
141787
36789
127865
148972
65643
79317
118691
51940
59672
43341
67809
58546
56834
85120
58589
31529
29673
113500
46213
26086
96572
117203
77789
74050
59312
152431
77472
155563
120541
58488
73883
76619
144534
91383
67953
87957
43141
61836
97998
117253
92749
65078
75068
88297
123244
117710
158948
74299
99779
96344
90589
45377
51756
103866
79450
67019
92012
72362
96857
104715
52188
111777
70738
51707
87138
93345
99916
67564
86181
120367
48013
77003
90827
43449
151315
143107
176197
238681
103961
54030
66491
148937
62231
168733
208030
63340
135198
142357
136790
70039
99101
59098
128655
88939
49716
82524
82385
172468
61114
106454
97066
81892
158791
121232
92485
124120
118442
166505
85310
58976
18890
67347
90470
161009
74050
95961
48447
33051
56867
100866
63663
40488
86228
67596
30388
144267
95427
99540
103692
63781
157046
94144
53669
81985
73607
72331
79077
50625
75082
185182
156515
148099
54628
118262
79296
104246
64889
99752
115346
80976
53797
97791

HEIGHT IN INCHES DATA

67
67
68
68
74
69
71
66
64
64
66
68
68
72
72
67
67
66
67
69
71
74
70
66
70
66
70
67
66
65
72
70
72
66
68
67
72
65
68
73
70
67
68
68
69
68
70
73
72
66
71
70
66
66
72
60
68
69
73
77
68
67
68
70
71
67
71
71
68
70
71
68
70
69
67
70
65
69
66
66
63
70
70
63
64
70
69
64
68
62
66
69
69
72
68
67
71
68
68
70
70
67
69
62
75
67
68
63
68
72
67
67
64
66
66
67
65
67
72
72
68
74
65
66
73
68
66
64
71
69
65
65
69
69
67
64
64
65
68
72
63
69
74
68
67
67
65
70
66
70
65
70
67
65
66
74
74
65
64
67
71
68
65
69
66
72
66
70
66
64
67
75
71
71
70
60
72
64
65
69
62
71
69
65
67
70
69
72
67
68
67
69
69
68
64
67
72
71
70
67
68
68
67
67
62
64
67
69
64
72
64
70
73
73
64
65
71
67
68
67
68
71
66
70
62
66
68
68
69
63
69
69
68
68
71
68
66
70
75
68
70
68
68
72
74
70
73
74
69
66
67
66
71
68
67
68
69
72
66
72
70
70
69
62
73
66
68
68
69
65
69
66
69
72
72
68
66
70
70
67
66
70
72
66
69
64
64
63
67
64
67
73
73
69
69
65
65
66
67
67
67
73
66
64
71
72
62
69
66
66
66
67
68
71
67
69
66
62
68
70
66
68
67
67
69
74
67
64
69
70
68
69
70
71
69
69
67
65
72
69
66
69
68
66
75
69
67
71
69
66
66
68
69
69
67
66
69
68
71
67
70
67
71
75
69
66
65
66
63
73
68
68
68
69
65
67
75
68
68
70
73
65
67
68
65
70
67
69
68
67
69
62
68
65
71
68
68
71
66
65
64
71
70
70
68
72
65
64
67
69
67
72
74
67
70
68
67
71
69
63
68
70
74
67
68
67
62
73
67
66
70
70
67
66
68
67
66
67
72
68
70
66
70
68
69
67
69
69
65
71
66
67
65
67
68
68
69
69
70
66
69
72
69
69
67
70
68
66
69
72
72
75
69
70
68
66
72
65
66
64
67
70
65
66
73
68
68
67
70
71
70
73
71
66
66
68
67
68
68
65

0 0
Add a comment Improve this question Transcribed image text
Answer #1

Box plot Use Excel to draw the box plot for the Car Mileage data 1. Enter the data in Excel spread sheet 2. Choose Add-InsMegBoxPlot 50000 100000 150000 200000 250000 300000 CAR MILAGE DATA From the plot, the data is skewed right. Because most of the data values falls between 02 and Q3. five data points lie outside the box plot. Thus, outliers are present in the data. Box plot: Use Excel to draw the box plot for the height data: 1. Enter the data in Excel spread sheet. 2. Choose Add-Ins -> MegaStat -» Descriptive Statistic:s 3. Check Median, quartiles, mode, outliers and Boxplot. 4. Select the data range of Heights 5. Click OK.Output Descriptive statistics HEIGHT IN INCHES DATA 500 count 1st quartile median 3rd quartile interquartile range mode 66.00 68.00 70.00 4.00 68.00 low extremes low outliers high outliers high extremes BoxPlot 50 60 65 70 75 80 85 HEIGHT IN INCHES DATA From the plot, the data is distributed like symmetritc plot. Thus, outliers are present in the data. One data value lie outside the box

Add a comment
Know the answer?
Add Answer to:
4. Box-Plot: Create a box-plot for the “Car Mileage” and the “Height in Inches” data on...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT