J5 fx A B C D E F G H 1 ID Manufacturer Engine Type Engine Type (0=diesel) 2 10 Keiser 3 396 Thompson Gasoline Diesel 1 Capacity 14 Maintenance cost Age Odometer Miles Miles 4646 5 54375 11973 0 14 1072 2 21858 11969 4 122 Bluebird Gasoline 1 55 9394 10 116580 11967 5 751 Keiser Diesel 0 14 1078 2 22444 11948 6 279 Bluebird Diesel 0 55 1008 2 22672 11925 7 500 Bluebird Gasoline 1 55 5329 5 50765 11922 8 520 Bluebird Diesel 0 55 4794 10 119130 11896 9 759 Keiser Diesel 0 55 3952 8 87872 11883 10 714 Bluebird Diesel 0 42 3742 7 73703 11837 11 875 Bluebird Diesel 0 55 4376 9 97947 11814 12 600 Bluebird Diesel 0 55 4832 10 119860 11800 13 953 Bluebird Diesel 0 55 5160 10 117700 11798 14 101 Bluebird Diesel 0 55 1955 4 41096 11789 15 358 Bluebird Diesel 0 55 2775 6 70086 11782 16 29 Bluebird Gasoline 1 55 5352 6 69438 11781 17 365 Keiser Diesel 0 55 3065 6 63384 11778 18 162 Keiser Gasoline 1 55 3143 3 31266 11758 19 686 Bluebird Diesel 0 55 1569 3 34674 11757 20 370 Keiser Gasoline 1 55 7766 8 86528 11707 21 887 Bluebird Diesel 0 55 3743 8 93672 11704 22 464 Bluebird Gasoline 1 55 2540 3 34530 11698 23 948 Keiser Diesel 0 42 4342 9 97956 11691 24 678 Keiser Diesel 0 55 3361 7 75229 11668 25 481 Keiser Gasoline 1 6 3097 3 34362 11662 26 43 Bluebird Gasoline 1 55 8263 9 102969 11615 27 704 Bluebird Diesel 0 55 4218 8 83424 11610 28 814 Bluebird Diesel 0 55 2028 4 40824 11576 29 39 Bluebird Gasoline 1 55 5821 6 69444 11533 30 699 Bluebird Gasoline 1 55 9069 9 98307 11518 31 75 Bluebird Diesel 0 55 3011 6 71970 11462 32 693 Keiser Gasoline 1 55 9193 9 101889 11461 33 989 Keiser Diesel 0 55 4795 9 106605 11418 34 982 Bluebird Diesel 0 55 505 1 10276 11359 35 321 Bluebird Diesel 0 42 2732 6 70122 11358 36 724 Keiser Diesel 0 42 3754 8 91968 11344 37 732 Keiser Diesel 0 42 4640 9 101196 11342 38 880 Keiser Gasoline 1 55 8410 9 97065 11336 38 880 Keiser Gasoline 1 55 8410 9 97065 11336 39 193 Thompson Diesel 0 14 5922 11 128711 11248 40 884 Bluebird Diesel 0 55 4364 9 92457 11231 41 57 Bluebird Diesel 0 55 3190 7 79240 11222 42 731 Bluebird Diesel 0 42 3213 6 68526 11168 43 61 Keiser Diesel 0 55 4139 9 103536 11148 44 45 135 Bluebird Diesel 0 55 3560 7 76426 11127 833 Thompson Diesel 0 14 3920 8 90968 11112 46 671 Thompson Gasoline 1 14 6733 8 89792 11100 47 692 Bluebird Diesel 0 55 3770 8 93248 11048 48 200 Bluebird Diesel 0 55 5168 10 103700 11018 49 754 Keiser Diesel 0 14 7380 14 146860 11003 50 540 Bluebird Gasoline 1 55 3656 4 45284 10945 51 660 Bluebird Gasoline 1 55 6213 6 64434 10911 52 353 Keiser Gasoline 1 55 4279 4 45744 10902 53 482 Bluebird Gasoline 1 55 10575 10 116534 10802 54 398 Thompson Diesel 0 6 4752 9 95922 10802 55 984 Bluebird Diesel 0 55 3809 8 87664 10760 56 977 Bluebird Diesel 0 55 3769 7 79422 10759 57 705 Keiser Diesel 0 42 2152 4 47596 10755 58 767 Keiser Diesel 0 55 2985 6 71538 10726 59 326 Bluebird Diesel 0 55 4563 9 107343 10724 60 120 Keiser Diesel 0 42 4723 10 110320 10674 61 554 Bluebird Diesel 0 42 1826 4 44604 10662 62 695 Bluebird Diesel 0 55 1061 2 23152 10633 63 9 Keiser Gasoline 1 55 3527 4 46848 10591 64 861 Bluebird Gasoline 1 55 9669 10 106040 10551 65 603 Keiser Diesel 0 14 2116 4 44384 10518 66 156 Thompson Diesel 0 14 6212 12 140460 10473 67 427 Keiser Gasoline 1 55 6927 7 73423 10355 68 883 Bluebird Gasoline 1 55 1881 2 20742 10344 69 168 Thompson Gasoline 1 14 7004 7 83006 10315 70 954 Bluebird Diesel 0 42 5284 10 101000 10235 71 768 Bluebird Diesel 0 42 3173 7 71778 10227 72 490 Bluebird Gasoline 1 55 10133 10 106240 10210 73 725 Bluebird Diesel 0 55 2356 5 57065 10209 74 45 Keiser Diesel 0 55 3124 6 60102 10167 75 38 Keiser Gasoline 1 14 5976 6 61662 10140 67 427 Keiser Gasoline 1 55 6927 68 883 Bluebird Gasoline 1 55 1881 69 168 Thompson Gasoline 1 14 7004 70 954 Bluebird Diesel 0 42 5284 71 768 Bluebird Diesel 0 42 3173 72 490 Bluebird Gasoline 1 55 10133 73 725 Bluebird Diesel 0 55 2356 74 45 Keiser Diesel 0 55 3124 72727956 73423 10355 20742 10344 83006 10315 10 101000 10235 71778 10227 10 106240 10210 57065 10209 60102 10167 75 38 Keiser Gasoline 1 14 5976 6 61662 10140 76 314 Thompson Diesel 0 6 5408 77 507 Bluebird Diesel 0 55 3690 78 40 Bluebird Gasoline 1 55 9573 79 918 Bluebird Diesel 0 55 2470 80 387 Bluebird Gasoline 1 55 6863 81 418 Bluebird Diesel 0 55 4513 272580 11 128117 10128 72849 10095 10 118470 10081 53620 10075 89960 10055 9 104715 10000 82 Refer to the Lincolnville School District Bus data, which report information on the school district's bus fleet. Chapter 7: a) Refer to the maintenance cost variable. The mean maintenance cost for last year is $4,552 with a standard deviation of $2332. Estimate the number of buses with a maintenance cost of more than $6,000. Compare that with the actual number. Create a frequency distribution of maintenance cost. Is the distribution normally distributed? b) Refer to the variable on the number of miles driven since the last maintenance. The mean is 11,121 and the standard deviation is 617 miles. Estimate the number of buses traveling more than 11,500 miles since the last maintenance. Compare that number with the actual value. Create a frequency distribution of miles since maintenance cost. Is the distribution normally distributed? Chapter 8: c) Information provided by manufacturers of school buses suggests the mean maintenance cost per year is $4,400 per bus with a standard deviation of $1000. Compute the mean maintenance cost for the Lincolnville buses. Does the Lincolnville data seem to be in line with that reported by the manufacturer? Specifically, what is the probability of Lincolnville's mean annual maintenance cost, or greater, given the manufacturer's data? Chapter 9: d) e) f) Develop a 95% confidence interval for the mean bus maintenance cost. Develop a 95% confidence interval for the mean bus odometer miles. Write a business memo to the state transportation official to report your results. Chapter 10: g) Select the variable for the number of miles traveled last month. Conduct a hypothesis test to determine whether the mean miles traveled last month equals 10,000. Use the 0.01 significance level. Find the p-value and explain what it means. h) A study of school bus fleets reports that the average per bus maintenance cost is $4,000 per year. Using the maintenance cost variable, conduct a hypothesis test to determine whether the mean maintenance cost for Lincolnville's bus fleet is more than $4,000 at the 0.05 significance level. Determine the p-value and report the results.