1 .Complete the problems below from the textbook. You will need to use the "Lincolnville School District Bus Data" and the "Century National Bank Data" files for this assignment.The files are located in the topic materials.

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.

\fData Set 3 --Lincolnville School District Bus Data Engine Typ Maintenance Odometer ID Manufacturer Capacity Miles Keiser 4646 54375 1072 21858 11969 Bluebird 55 9394 116580 751 Keiser 1078 22444 11948 279 22672 11925 500 Bluebird 55 5329 50765 11922 Variables Bluebird 55 4794 11896 759 55 87872 11889 D = Bus identification number 714 Bluebi 42 73703 11837 $7947 11814 Manufacturer = Source of the bus (Bluebird, Keiser, or Thompson) 600 Bluebird 55 Bluebird 55 953 55 119860 5160 1770 11798 Engine type = If the engine is diesel then engine type = 0; if the engine is gasoline, then engine type = 1) 101 Bluebird 1955 41096 358 70086 Capacity = number of seats on the bus 5352 365 3065 11778 Maintenance cost = dollars spent to maintain a bus last year 162 3143 1569 31266 686 34674 11707 Age = number of years since the bus left the manufacturer 370 Keiser 86528 11704 luebir 3743 3672 Odometer Miles = total number of miles traveled by a bus 948 Bluebird 34530 11698 4342 97956 Miles = number of miles traveled since last maintenance 678 75229 481 3097 34362 11662 Bluebird 8263 11615 704 814 Bluebird 4218 2028 40824 11576 69444 11533 699 9069 98307 11518 3011 Keiser 9193 101889 11461 989 4795 0660 982 505 10276 321 11358 724 Bluebird 2732 Keiser 3754 11344 732 4640 10119 11342 880 97065 11336 193 128712 11248 Bluebird 92457 Bluebird 3190 79240 Bluebird 68526 11168 103536 135 uebird 3560 76426 11127 833 3920 90968 11112 671 6733 89792 11100 692 Thompson Bluebird 377 93248 11048 Bluebird 5168 7380 103700 146860 11003 540 3656 10945 660 Bluebird 6213 64434 10911 45744 482 10575 11653 10802 398 4752 95922 10802 984 3809 10760 977 Bluebird luebird 3769 79422 10759 2152 47596 10755 2985 71538 10726 326 luebi 4563 0734 10724 Keiser 4723 bluebird 1826 44604 10662 695 Bluebird 23152 10633 9 Keiser 3527 46848 10591 uebir 9669 106040 10551 603 2116 44384 10518 156 14046 10473 427 Keiser 1881 20/42 hompson 7004 83006 10315 954 768 Bluebird 5284 101000 10235 71778 490 10133 10210 725 Bluebird 2356 10209 Keiser 3124 60102 10167 Keiser 5976 61662 10140 5408 128117 10128 507 Bluebird 10095 10081 10075 89960 418 104715 10000