0 Comments

Description

Complete the problems below from the textbook. You will need to use the “Buena School District Bus Data” and the “Century National Bank Data” files for this assignment.

  1. Chapter 3 – Problem 88
  2. Chapter 4 – Problem 25
  3. Chapter 4 – Problem 46
  4. Chapter 5 – Problem 94
  5. Chapter 4 Case A – Century National Bank

For problems requiring computations, please ensure that your Excel file includes the associated cell computations and/or statistics output. This information is needed in order to receive full credit on these problems.

 

Frequency Distribution – Quantitative
Maintenance
lower
upper
320
340
360
380
400
420
440
460
480
500
520
540
560
<
<
<
<
<
<
<
<
<
<
<
<
<
Histogram
20
18
16
Percent
14
12
10
8
6
4
2
0
Maintenance
Descriptive statistics
count
mean
sample variance
sample standard deviation
minimum
maximum
range
Maintenance
80
450.29
2,882.18
53.69
329
570
241
340
360
380
400
420
440
460
480
500
520
540
560
580
midpoint
330
350
370
390
410
430
450
470
490
510
530
550
570
width
20
20
20
20
20
20
20
20
20
20
20
20
20
frequency
3
3
1
8
5
12
12
15
7
8
1
3
2
80
1st quartile
median
3rd quartile
interquartile range
mode
low extremes
low outliers
high outliers
high extremes
420.00
456.00
489.75
69.75
329.00
0
0
0
0
Frequency Distribution – Quantitative
Maintenance
lower
upper
300
350
400
450
500
550
<
<
<
<
<
<
350
400
450
500
550
600
midpoint
325
375
425
475
525
575
width
50
50
50
50
50
50
frequency
3
12
22
29
11
3
80
midpoint
343
378
413
width
35
35
35
frequency
6
8
12
Histogram
40
35
Percent
30
25
20
15
10
5
0
Maintenance
Frequency Distribution – Quantitative
Maintenance
lower
325
360
395
upper
<
<
<
360
395
430
430
465
500
535
570
<
<
<
<
<
Histogram
30
25
Percent
20
15
10
5
0
Maintenance
Descriptive statistics
count
mean
sample variance
sample standard deviation
minimum
maximum
range
1st quartile
median
3rd quartile
interquartile range
mode
low extremes
low outliers
high outliers
high extremes
Miles
80
827.53
1,188.20
34.47
741
908
167
806.00
827.00
851.50
45.50
815.00
0
0
0
0
BoxPlot
465
500
535
570
605
448
483
518
553
587
35
35
35
35
35
20
20
9
4
1
80
BoxPlot
1/28/2010 16:03.39 (1)
600
650
700
750
800
850
900
950
850
900
950
850
900
950
Miles
Descriptive statistics
count
mean
sample variance
sample standard deviation
minimum
maximum
range
1st quartile
median
3rd quartile
interquartile range
mode
Miles
80
827.53
1,188.20
34.47
741
908
167
806.00
827.00
851.50
45.50
815.00
low extremes
low outliers
high outliers
high extremes
0
0
0
0
BoxPlot
1/28/2010 16:06.08 (1)
600
650
700
750
800
Miles
DotPlot
1/28/2010
16:06.08 (1)
600
650
700
750
800
Miles
Descriptive statistics
count
mean
sample variance
sample standard deviation
minimum
maximum
range
1st quartile
median
3rd quartile
interquartile range
mode
Miles
80
830.11
1,779.85
42.19
741
1008
267
806.00
827.00
851.50
45.50
815.00
low extremes
low outliers
high outliers
high extremes
0
0
1
1
BoxPlot
1/28/2010 16:08.20 (1)
600
700
800
900
1000
1100
1000
1100
Miles
DotPlot
1/28/2010
16:08.20 (1)
600
700
800
900
Miles
Correlation Matrix
Maintenance
Age
Maintenance
1.000
.465
Age
1.000
Miles
Miles
.450
.522
1.000
80 sample size
± .220 critical value .05 (two-tail)
± .286 critical value .01 (two-tail)
percent
3.8
3.8
1.3
10.0
6.3
15.0
15.0
18.8
8.8
10.0
1.3
3.8
2.5
100.0
cumulative
frequency percent
3
3.8
6
7.5
7
8.8
15
18.8
20
25.0
32
40.0
44
55.0
59
73.8
66
82.5
74
92.5
75
93.8
78
97.5
80
100.0
percent
3.8
15.0
27.5
36.3
13.8
3.8
100.0
percent
7.5
10.0
15.0
cumulative
frequency percent
3
3.8
15
18.8
37
46.3
66
82.5
77
96.3
80
100.0
cumulative
frequency percent
6
7.5
14
17.5
26
32.5
25.0
25.0
11.3
5.0
1.3
100.0
46
66
75
79
80
57.5
82.5
93.8
98.8
100.0
Data Set 3 –Buena School District Bus Data
Bus Number
X1
Maintenance
X2
Age
X3
Miles
X4
Type
X5
Bus-Mfg
X6
Passenger
X7
135
120
200
40
427
759
10
880
481
387
326
861
122
156
887
686
490
370
464
875
883
57
482
704
989
731
75
162
732
751
600
948
358
833
692
61
9
314
396
365
329
503
505
466
359
546
427
474
382
422
433
474
558
561
357
329
497
459
355
489
436
455
514
503
380
432
478
406
471
444
493
452
461
496
469
442
414
459
457
462
7
10
10
10
7
8
5
9
3
8
9
10
10
12
8
3
10
8
3
9
2
7
11
8
9
6
6
3
9
2
10
9
6
8
8
9
4
11
2
6
853
883
822
865
751
870
780
857
818
869
848
845
885
838
760
741
859
826
806
858
785
828
980
857
803
819
821
798
815
757
1008
831
849
839
812
809
864
859
815
799
Diesel
Diesel
Diesel
Gasoline
Gasoline
Diesel
Gasoline
Gasoline
Gasoline
Gasoline
Diesel
Gasoline
Gasoline
Diesel
Diesel
Diesel
Gasoline
Gasoline
Gasoline
Diesel
Gasoline
Diesel
Gasoline
Diesel
Diesel
Diesel
Diesel
Gasoline
Diesel
Diesel
Diesel
Diesel
Diesel
Diesel
Diesel
Diesel
Gasoline
Diesel
Diesel
Diesel
Bluebird
Keiser
Bluebird
Bluebird
Keiser
Keiser
Keiser
Keiser
Keiser
Bluebird
Bluebird
Bluebird
Bluebird
Thompson
Bluebird
Bluebird
Bluebird
Keiser
Bluebird
Bluebird
Bluebird
Bluebird
Bluebird
Bluebird
Keiser
Bluebird
Bluebird
Keiser
Keiser
Keiser
Bluebird
Keiser
Bluebird
Thompson
Bluebird
Keiser
Keiser
Thompson
Thompson
Keiser
55 Passenger
42 Passenger
55 Passenger
55 Passenger
55 Passenger
55 Passenger
14 Passenger
55 Passenger
6 Passenger
55 Passenger
55 Passenger
55 Passenger
55 Passenger
55 Passenger
6 Passenger
55 Passenger
55 Passenger
55 Passenger
55 Passenger
55 Passenger
55 Passenger
55 Passenger
55 Passenger
55 Passenger
55 Passenger
42 Passenger
55 Passenger
55 Passenger
42 Passenger
14 Passenger
55 Passenger
42 Passenger
55 Passenger
55 Passenger
55 Passenger
55 Passenger
55 Passenger
6 Passenger
55 Passenger
55 Passenger
398
43
500
279
693
884
977
38
725
982
724
603
168
45
754
39
671
418
984
953
507
540
695
193
321
918
101
714
678
768
29
554
767
699
954
705
660
520
814
353
570
439
369
390
469
381
501
432
392
441
448
468
467
478
515
411
504
504
392
423
410
529
477
540
450
390
424
433
428
494
396
458
493
475
476
403
337
492
426
449
9
9
5
2
9
9
7
6
5
1
8
4
7
6
14
6
8
9
8
10
7
4
2
11
6
5
4
7
7
7
6
4
6
9
10
4
6
10
4
4
844
832
842
792
775
882
874
837
774
823
790
800
827
830
895
804
866
842
851
835
866
846
802
847
856
799
827
817
842
815
784
817
816
816
827
806
819
836
757
817
Diesel
Gasoline
Gasoline
Diesel
Gasoline
Diesel
Diesel
Gasoline
Diesel
Diesel
Diesel
Diesel
Gasoline
Diesel
Diesel
Gasoline
Gasoline
Diesel
Diesel
Diesel
Diesel
Gasoline
Diesel
Diesel
Diesel
Diesel
Diesel
Diesel
Diesel
Diesel
Gasoline
Diesel
Diesel
Gasoline
Diesel
Diesel
Gasoline
Diesel
Diesel
Gasoline
Thompson
Bluebird
Bluebird
Bluebird
Keiser
Bluebird
Bluebird
Keiser
Bluebird
Bluebird
Keiser
Keiser
Thompson
Keiser
Keiser
Bluebird
Thompson
Bluebird
Bluebird
Bluebird
Bluebird
Bluebird
Bluebird
Thompson
Bluebird
Bluebird
Bluebird
Bluebird
Keiser
Bluebird
Bluebird
Bluebird
Keiser
Bluebird
Bluebird
Keiser
Bluebird
Bluebird
Bluebird
Keiser
14 Passenger
55 Passenger
55 Passenger
55 Passenger
55 Passenger
55 Passenger
55 Passenger
14 Passenger
55 Passenger
55 Passenger
42 Passenger
14 Passenger
55 Passenger
55 Passenger
14 Passenger
55 Passenger
55 Passenger
55 Passenger
55 Passenger
55 Passenger
55 Passenger
55 Passenger
55 Passenger
55 Passenger
6 Passenger
55 Passenger
55 Passenger
42 Passenger
55 Passenger
42 Passenger
55 Passenger
14 Passenger
55 Passenger
55 Passenger
42 Passenger
42 Passenger
55 Passenger
55 Passenger
55 Passenger
55 Passenger
Balance
1756
748
1501
1831
1622
1886
740
1593
1169
2125
1554
1474
1913
1218
1006
2215
137
167
343
2557
2276
1494
2144
1995
1053
1526
1120
1838
1746
1616
1958
634
580
1320
1675
789
1735
1784
1326
2051
1044
1885
1790
765
1645
32
1266
890
2204
2409
1338
ATM
Services
13
9
10
10
14
17
6
10
6
18
12
12
6
10
12
20
7
5
7
20
15
11
17
10
8
8
8
7
11
10
6
2
4
4
6
8
12
11
16
14
7
10
11
4
6
2
11
7
14
16
14
4
2
1
4
6
3
3
8
4
6
6
7
5
3
4
3
2
4
2
7
4
2
3
7
4
4
6
5
2
4
2
7
1
5
7
4
7
5
8
4
5
6
4
3
9
0
7
1
5
8
4
Debit
Interest
0
1
0
0
0
0
0
1
0
0
1
1
0
1
0
1
0
0
0
1
1
0
0
0
1
0
1
1
0
1
1
1
0
1
1
0
0
0
0
1
1
1
0
0
0
0
0
0
0
0
1
1
0
0
1
1
1
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
1
0
0
0
1
0
1
0
1
0
0
0
0
0
0
1
0
0
0
0
1
1
0
1
0
0
1
0
0
0
City
2
1
1
3
4
1
3
1
4
2
3
1
1
1
1
4
3
4
1
4
3
1
3
2
3
2
3
3
2
2
2
4
1
1
2
4
3
1
3
4
1
2
3
4
4
3
4
1
2
2
2
2076
1708
2138
2375
1455
1487
1125
1989
2156
12
13
18
12
9
8
6
12
14
5
3
5
4
5
4
4
3
5
1
1
0
0
1
1
1
0
1
0
0
1
0
1
0
0
1
0
2
1
4
2
3
4
2
2
2
Ch3 88. Refer to the Buena School District bus data. Prepare a report on the maintenance cost for last month. Be sure to answer the
following questions in your report.
a. Around what values do the data tend to cluster? Specifically what was the mean main-tenance cost last month? What is the median
cost? Is one measure more representative of the typical cost than the others?
b. What is the range of maintenance costs? What is the standard deviation? About 95% of the maintenance costs are between what two
values?
Ch4 46
Refer to the Buena School District bus data
.a. Refer to the maintenance cost variable. Develop a box plot. What are the first and third quartiles? Are there any outliers?
b. Determine the median maintenance cost. Based on the median, develop a contingency table with bus manufacturer as one variable and
whether the maintenance cost was above or below the median as the other variable. What are your conclusions?
Ch5
94. Refer to the data on the school buses in the Buena School District. Set up a variable that divides the age of the buses into three groups:
new (less than 5 years old), medium (5 but less than 10 years), and old (10 or more years). The median maintenance cost is $456. Based on
this value, create a variable for those less than or equal to the median (low main-tenance) and those more than the median (high
maintenance). Finally, develop a table to show the relationship between maintenance cost and age of the bus.
a. What percentage of the buses are new?
b. What percentage of the new buses have low maintenance?
c. What percentage of the old buses have high maintenance?
d. Does maintenance cost seem to be related to the age of the bus? Hint: Compare the maintenance cost of the old buses with the cost of
the new buses? Would you conclude maintenance cost is independent of the age?
2
Course Oure
160 of 30
A Bank
Pin
Hoved
Bar

个 ↑
+
161 of 889
whe
CH

wy
ARVIEW OF WATER
119
was
IH
Product There a Difference
காகாகா
COME
who
*
ww
ETICE

Purchase answer to see full
attachment

Order Solution Now

Categories: