Chapter 8 - 9 questions
Century National Bank Data
| Balance | ATM | Services | Debit | Interest | City |
| 1756 | 13 | 4 | 0 | 1 | 2 |
| 748 | 9 | 2 | 1 | 0 | 1 |
| 1501 | 10 | 1 | 0 | 0 | 1 |
| 1831 | 10 | 4 | 0 | 1 | 3 |
| 1622 | 14 | 6 | 0 | 1 | 4 |
| 1886 | 17 | 3 | 0 | 1 | 1 |
| 740 | 6 | 3 | 0 | 0 | 3 |
| 1593 | 10 | 8 | 1 | 0 | 1 |
| 1169 | 6 | 4 | 0 | 0 | 4 |
| 2125 | 18 | 6 | 0 | 0 | 2 |
| 1554 | 12 | 6 | 1 | 0 | 3 |
| 1474 | 12 | 7 | 1 | 0 | 1 |
| 1913 | 6 | 5 | 0 | 0 | 1 |
| 1218 | 10 | 3 | 1 | 0 | 1 |
| 1006 | 12 | 4 | 0 | 0 | 1 |
| 2215 | 20 | 3 | 1 | 0 | 4 |
| 137 | 7 | 2 | 0 | 0 | 3 |
| 167 | 5 | 4 | 0 | 0 | 4 |
| 343 | 7 | 2 | 0 | 0 | 1 |
| 2557 | 20 | 7 | 1 | 0 | 4 |
| 2276 | 15 | 4 | 1 | 0 | 3 |
| 1494 | 11 | 2 | 0 | 1 | 1 |
| 2144 | 17 | 3 | 0 | 0 | 3 |
| 1995 | 10 | 7 | 0 | 0 | 2 |
| 1053 | 8 | 4 | 1 | 0 | 3 |
| 1526 | 8 | 4 | 0 | 1 | 2 |
| 1120 | 8 | 6 | 1 | 0 | 3 |
| 1838 | 7 | 5 | 1 | 1 | 3 |
| 1746 | 11 | 2 | 0 | 0 | 2 |
| 1616 | 10 | 4 | 1 | 1 | 2 |
| 1958 | 6 | 2 | 1 | 0 | 2 |
| 634 | 2 | 7 | 1 | 0 | 4 |
| 580 | 4 | 1 | 0 | 0 | 1 |
| 1320 | 4 | 5 | 1 | 0 | 1 |
| 1675 | 6 | 7 | 1 | 0 | 2 |
| 789 | 8 | 4 | 0 | 0 | 4 |
| 1735 | 12 | 7 | 0 | 1 | 3 |
| 1784 | 11 | 5 | 0 | 0 | 1 |
| 1326 | 16 | 8 | 0 | 0 | 3 |
| 2051 | 14 | 4 | 1 | 0 | 4 |
| 1044 | 7 | 5 | 1 | 0 | 1 |
| 1885 | 10 | 6 | 1 | 1 | 2 |
| 1790 | 11 | 4 | 0 | 1 | 3 |
| 765 | 4 | 3 | 0 | 0 | 4 |
| 1645 | 6 | 9 | 0 | 1 | 4 |
| 32 | 2 | 0 | 0 | 0 | 3 |
| 1266 | 11 | 7 | 0 | 0 | 4 |
| 890 | 7 | 1 | 0 | 1 | 1 |
| 2204 | 14 | 5 | 0 | 0 | 2 |
| 2409 | 16 | 8 | 0 | 0 | 2 |
| 1338 | 14 | 4 | 1 | 0 | 2 |
| 2076 | 12 | 5 | 1 | 0 | 2 |
| 1708 | 13 | 3 | 1 | 0 | 1 |
| 2138 | 18 | 5 | 0 | 1 | 4 |
| 2375 | 12 | 4 | 0 | 0 | 2 |
| 1455 | 9 | 5 | 1 | 1 | 3 |
| 1487 | 8 | 4 | 1 | 0 | 4 |
| 1125 | 6 | 4 | 1 | 0 | 2 |
| 1989 | 12 | 3 | 0 | 1 | 2 |
| 2156 | 14 | 5 | 1 | 0 | 2 |
Lincolnville School District B
| Data Set 3 --Lincolnville School District Bus Data | |||||||||||
| ID | Manufacturer | Engine Type (0=diesel) | Capacity | Maintenance Cost | Age | Odometer Miles | Miles | ||||
| 10 | Keiser | 1 | 14 | 4646 | 5 | 54375 | 11973 | ||||
| 396 | Thompson | 0 | 14 | 1072 | 2 | 21858 | 11969 | ||||
| 122 | Bluebird | 1 | 55 | 9394 | 10 | 116580 | 11967 | ||||
| 751 | Keiser | 0 | 14 | 1078 | 2 | 22444 | 11948 | ||||
| 279 | Bluebird | 0 | 55 | 1008 | 2 | 22672 | 11925 | ||||
| 500 | Bluebird | 1 | 55 | 5329 | 5 | 50765 | 11922 | Variables | |||
| 520 | Bluebird | 0 | 55 | 4794 | 10 | 119130 | 11896 | ||||
| 759 | Keiser | 0 | 55 | 3952 | 8 | 87872 | 11889 | ID = Bus identification number | |||
| 714 | Bluebird | 0 | 42 | 3742 | 7 | 73703 | 11837 | ||||
| 875 | Bluebird | 0 | 55 | 4376 | 9 | 97947 | 11814 | Manufacturer = Source of the bus (Bluebird, Keiser, or Thompson) | |||
| 600 | Bluebird | 0 | 55 | 4832 | 10 | 119860 | 11800 | ||||
| 953 | Bluebird | 0 | 55 | 5160 | 10 | 117700 | 11798 | Engine type = If the engine is diesel then engine type = 0; if the engine is gasoline, then engine type = 1) | |||
| 101 | Bluebird | 0 | 55 | 1955 | 4 | 41096 | 11789 | ||||
| 358 | Bluebird | 0 | 55 | 2775 | 6 | 70086 | 11782 | Capacity = number of seats on the bus | |||
| 29 | Bluebird | 1 | 55 | 5352 | 6 | 69438 | 11781 | ||||
| 365 | Keiser | 0 | 55 | 3065 | 6 | 63384 | 11778 | Maintenance cost = dollars spent to maintain a bus last year | |||
| 162 | Keiser | 1 | 55 | 3143 | 3 | 31266 | 11757 | ||||
| 686 | Bluebird | 0 | 55 | 1569 | 3 | 34674 | 11707 | Age = number of years since the bus left the manufacturer | |||
| 370 | Keiser | 1 | 55 | 7766 | 8 | 86528 | 11704 | ||||
| 887 | Bluebird | 0 | 55 | 3743 | 8 | 93672 | 11698 | Odometer Miles = total number of miles traveled by a bus | |||
| 464 | Bluebird | 1 | 55 | 2540 | 3 | 34530 | 11698 | ||||
| 948 | Keiser | 0 | 42 | 4342 | 9 | 97956 | 11691 | Miles = number of miles traveled since last maintenance | |||
| 678 | Keiser | 0 | 55 | 3361 | 7 | 75229 | 11668 | ||||
| 481 | Keiser | 1 | 6 | 3097 | 3 | 34362 | 11662 | ||||
| 43 | Bluebird | 1 | 55 | 8263 | 9 | 102969 | 11615 | ||||
| 704 | Bluebird | 0 | 55 | 4218 | 8 | 83424 | 11610 | ||||
| 814 | Bluebird | 0 | 55 | 2028 | 4 | 40824 | 11576 | ||||
| 39 | Bluebird | 1 | 55 | 5821 | 6 | 69444 | 11533 | ||||
| 699 | Bluebird | 1 | 55 | 9069 | 9 | 98307 | 11518 | ||||
| 75 | Bluebird | 0 | 55 | 3011 | 6 | 71970 | 11462 | ||||
| 693 | Keiser | 1 | 55 | 9193 | 9 | 101889 | 11461 | ||||
| 989 | Keiser | 0 | 55 | 4795 | 9 | 106605 | 11418 | ||||
| 982 | Bluebird | 0 | 55 | 505 | 1 | 10276 | 11359 | ||||
| 321 | Bluebird | 0 | 42 | 2732 | 6 | 70122 | 11358 | ||||
| 724 | Keiser | 0 | 42 | 3754 | 8 | 91968 | 11344 | ||||
| 732 | Keiser | 0 | 42 | 4640 | 9 | 101196 | 11342 | ||||
| 880 | Keiser | 1 | 55 | 8410 | 9 | 97065 | 11336 | ||||
| 193 | Thompson | 0 | 14 | 5922 | 11 | 128711 | 11248 | ||||
| 884 | Bluebird | 0 | 55 | 4364 | 9 | 92457 | 11231 | ||||
| 57 | Bluebird | 0 | 55 | 3190 | 7 | 79240 | 11222 | ||||
| 731 | Bluebird | 0 | 42 | 3213 | 6 | 68526 | 11168 | ||||
| 61 | Keiser | 0 | 55 | 4139 | 9 | 103536 | 11148 | ||||
| 135 | Bluebird | 0 | 55 | 3560 | 7 | 76426 | 11127 | ||||
| 833 | Thompson | 0 | 14 | 3920 | 8 | 90968 | 11112 | ||||
| 671 | Thompson | 1 | 14 | 6733 | 8 | 89792 | 11100 | ||||
| 692 | Bluebird | 0 | 55 | 3770 | 8 | 93248 | 11048 | ||||
| 200 | Bluebird | 0 | 55 | 5168 | 10 | 103700 | 11018 | ||||
| 754 | Keiser | 0 | 14 | 7380 | 14 | 146860 | 11003 | ||||
| 540 | Bluebird | 1 | 55 | 3656 | 4 | 45284 | 10945 | ||||
| 660 | Bluebird | 1 | 55 | 6213 | 6 | 64434 | 10911 | ||||
| 353 | Keiser | 1 | 55 | 4279 | 4 | 45744 | 10902 | ||||
| 482 | Bluebird | 1 | 55 | 10575 | 10 | 116534 | 10802 | ||||
| 398 | Thompson | 0 | 6 | 4752 | 9 | 95922 | 10802 | ||||
| 984 | Bluebird | 0 | 55 | 3809 | 8 | 87664 | 10760 | ||||
| 977 | Bluebird | 0 | 55 | 3769 | 7 | 79422 | 10759 | ||||
| 705 | Keiser | 0 | 42 | 2152 | 4 | 47596 | 10755 | ||||
| 767 | Keiser | 0 | 55 | 2985 | 6 | 71538 | 10726 | ||||
| 326 | Bluebird | 0 | 55 | 4563 | 9 | 107343 | 10724 | ||||
| 120 | Keiser | 0 | 42 | 4723 | 10 | 110320 | 10674 | ||||
| 554 | Bluebird | 0 | 42 | 1826 | 4 | 44604 | 10662 | ||||
| 695 | Bluebird | 0 | 55 | 1061 | 2 | 23152 | 10633 | ||||
| 9 | Keiser | 1 | 55 | 3527 | 4 | 46848 | 10591 | ||||
| 861 | Bluebird | 1 | 55 | 9669 | 10 | 106040 | 10551 | ||||
| 603 | Keiser | 0 | 14 | 2116 | 4 | 44384 | 10518 | ||||
| 156 | Thompson | 0 | 14 | 6212 | 12 | 140460 | 10473 | ||||
| 427 | Keiser | 1 | 55 | 6927 | 7 | 73423 | 10355 | ||||
| 883 | Bluebird | 1 | 55 | 1881 | 2 | 20742 | 10344 | ||||
| 168 | Thompson | 1 | 14 | 7004 | 7 | 83006 | 10315 | ||||
| 954 | Bluebird | 0 | 42 | 5284 | 10 | 101000 | 10235 | ||||
| 768 | Bluebird | 0 | 42 | 3173 | 7 | 71778 | 10227 | ||||
| 490 | Bluebird | 1 | 55 | 10133 | 10 | 106240 | 10210 | ||||
| 725 | Bluebird | 0 | 55 | 2356 | 5 | 57065 | 10209 | ||||
| 45 | Keiser | 0 | 55 | 3124 | 6 | 60102 | 10167 | ||||
| 38 | Keiser | 1 | 14 | 5976 | 6 | 61662 | 10140 | ||||
| 314 | Thompson | 0 | 6 | 5408 | 11 | 128117 | 10128 | ||||
| 507 | Bluebird | 0 | 55 | 3690 | 7 | 72849 | 10095 | ||||
| 40 | Bluebird | 1 | 55 | 9573 | 10 | 118470 | 10081 | ||||
| 918 | Bluebird | 0 | 55 | 2470 | 5 | 53620 | 10075 | ||||
| 387 | Bluebird | 1 | 55 | 6863 | 8 | 89960 | 10055 | ||||
| 418 | Bluebird | 0 | 55 | 4513 | 9 | 104715 | 10000 |
Problem 1 (Chapter 8 #44)
Problem 2 (Chapter 8 #48)
Problem 3 (Chapter 9 #56)
Problem 4 (Chapter 9 #66)
Problem 5 (Chapter 9 #71)
Problem 6 (Chapter 9 Case A)
Case A (page 129)
| Balance | ATM | Services | Debit | Interest | City |
| 32 | 13 | 4 | 0 | 1 | 2 |
| 137 | 9 | 2 | 1 | 0 | 1 |
| 167 | 10 | 1 | 0 | 0 | 1 |
| 343 | 10 | 4 | 0 | 1 | 3 |
| 580 | 14 | 6 | 0 | 1 | 4 |
| 634 | 17 | 3 | 0 | 1 | 1 |
| 740 | 6 | 3 | 0 | 0 | 3 |
| 748 | 10 | 8 | 1 | 0 | 1 |
| 765 | 6 | 4 | 0 | 0 | 4 |
| 789 | 18 | 6 | 0 | 0 | 2 |
| 890 | 12 | 6 | 1 | 0 | 3 |
| 1006 | 12 | 7 | 1 | 0 | 1 |
| 1044 | 6 | 5 | 0 | 0 | 1 |
| 1053 | 10 | 3 | 1 | 0 | 1 |
| 1120 | 12 | 4 | 0 | 0 | 1 |
| 1125 | 20 | 3 | 1 | 0 | 4 |
| 1169 | 7 | 2 | 0 | 0 | 3 |
| 1218 | 5 | 4 | 0 | 0 | 4 |
| 1266 | 7 | 2 | 0 | 0 | 1 |
| 1320 | 20 | 7 | 1 | 0 | 4 |
| 1326 | 15 | 4 | 1 | 0 | 3 |
| 1338 | 11 | 2 | 0 | 1 | 1 |
| 1455 | 17 | 3 | 0 | 0 | 3 |
| 1474 | 10 | 7 | 0 | 0 | 2 |
| 1487 | 8 | 4 | 1 | 0 | 3 |
| 1494 | 8 | 4 | 0 | 1 | 2 |
| 1501 | 8 | 6 | 1 | 0 | 3 |
| 1526 | 7 | 5 | 1 | 1 | 3 |
| 1554 | 11 | 2 | 0 | 0 | 2 |
| 1593 | 10 | 4 | 1 | 1 | 2 |
| 1616 | 6 | 2 | 1 | 0 | 2 |
| 1622 | 2 | 7 | 1 | 0 | 4 |
| 1645 | 4 | 1 | 0 | 0 | 1 |
| 1675 | 4 | 5 | 1 | 0 | 1 |
| 1708 | 6 | 7 | 1 | 0 | 2 |
| 1735 | 8 | 4 | 0 | 0 | 4 |
| 1746 | 12 | 7 | 0 | 1 | 3 |
| 1756 | 11 | 5 | 0 | 0 | 1 |
| 1784 | 16 | 8 | 0 | 0 | 3 |
| 1790 | 14 | 4 | 1 | 0 | 4 |
| 1831 | 7 | 5 | 1 | 0 | 1 |
| 1838 | 10 | 6 | 1 | 1 | 2 |
| 1885 | 11 | 4 | 0 | 1 | 3 |
| 1886 | 4 | 3 | 0 | 0 | 4 |
| 1913 | 6 | 9 | 0 | 1 | 4 |
| 1958 | 2 | 0 | 0 | 0 | 3 |
| 1989 | 11 | 7 | 0 | 0 | 4 |
| 1995 | 7 | 1 | 0 | 1 | 1 |
| 2051 | 14 | 5 | 0 | 0 | 2 |
| 2076 | 16 | 8 | 0 | 0 | 2 |
| 2125 | 14 | 4 | 1 | 0 | 2 |
| 2138 | 12 | 5 | 1 | 0 | 2 |
| 2144 | 13 | 3 | 1 | 0 | 1 |
| 2156 | 18 | 5 | 0 | 1 | 4 |
| 2204 | 12 | 4 | 0 | 0 | 2 |
| 2215 | 9 | 5 | 1 | 1 | 3 |
| 2276 | 8 | 4 | 1 | 0 | 4 |
| 2375 | 6 | 4 | 1 | 0 | 2 |
| 2409 | 12 | 3 | 0 | 1 | 2 |
| 2557 | 14 | 5 | 1 | 0 | 2 |
| Balance of Typical Customer | 1499.8666666667 | ||||
| Services | 265 | ||||
| Frequenecy | |||||
| Customer Frequency on | 618 | 265 | 26 | ||
| MEADIAN | 1604.5 | ||||
| Customers With More than 2000 | 18.0327868852 | ||||
| PEARSON | -0.0621096663 | ||||
| mean | 1499.8666666667 | ||||
| median | 1604.5 | ||||
| Minimum | 32 | ||||
| Maximum | 2557 | ||||
| Range | 2525 | ||||
| Q1 | 1123.75 | ||||
| Q3 | 1924.25 | ||||
| IQT | 800.5 | ||||
| STDEV | 596.9049115616 | ||||
| Median-Mean | 104.6333333333 | ||||
| Pearson Coefficient of Skweness | 313.9 |
This shows that there is a weak and negative relationship between account balances and branches.
In this analytical data, mean is 1499.867 while, median 1604.5. This difference occur due to conditions data variation in the dataset, However, in a continuous data presentation , median shows an effective and accurate center of tendency than mean.
In the the computation , the range is calculasted as thediffrence between Min and max, STDEV inidcates the diffreneces in ranges in the balanaces. IQT accommoadtes the diffreneces between Q1 and Q3. Significatly, Pearson Coefficient of Skweness is computed by by multiplying the difference between the mean and median, multiplied by three.