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 resources.

1. Chapter 3 - Problem 88

Refer to the Lincolnville School District bus data. Report on the maintenance cost for last month. Be sure to answer the following questions in your report.

Lincolnville School District Bus Data Download Reference the "Lincolnville School District Bus Data" as directed to complete the topic assignment. A B 1 This worksheet contains values required for MegaStat charts. 2 3 Boxplot 1/28/2010 16:03.39 4 2 741 5 2 806 6 3 806 7 3 827 8 1 827 9 3 827 10 3 851.5 11 2 851.5 12 2 908 13 2 851.5 14 1 851.5 15 1 806 16 2 806 17 1 669.5 18 3 669.5 19 1 737.75 20 3 737.75 21 1 919.75 22 3 919.75 23 1 988 24 3 988 25 26 Boxplot 1/28/2010 16:06.08 27 2 741 28 2 806 29 3 806 30 3 827 31 1 827 32 3 827 33 3 851.5 34 2 851.5 35 2 908 36 2 851.5 37 1 851.5 38 1 806 39 2 806 40 1 669.5 41 3 669.5 42 1 737.75 43 3 737.75 44 1 919.75 45 3 919.75 46 1 988 47 3 988 48 49 Dotplot 1/28/2010 16:06.08 50 741 1 51 751 1 52 757 1 53 757 2 54 760 1 55 774 1 56 775 1 57 780 1 58 784 1 59 785 1 60 790 1 61 792 1 62 798 1 63 799 1 64 799 2 65 800 1 66 802 1 67 803 1 68 804 1 69 806 1 70 806 2 71 809 1 72 812 1 73 815 1 74 815 2 75 815 3 76 816 1 77 816 2 78 817 1 79 817 2 80 817 3 81 818 1 82 819 1 83 819 2 84 821 1 85 822 1 86 823 1 87 826 1 88 827 1 89 827 2 90 827 3 91 828 1 92 830 1 93 831 1 94 832 1 95 835 1 96 836 1 97 837 1 98 838 1 99 839 1 100 842 1 101 842 2 102 842 3 103 844 1 104 845 1 105 846 1 106 847 1 107 848 1 108 849 1 109 851 1 110 853 1 111 856 1 112 857 1 113 857 2 114 858 1 115 859 1 116 859 2 117 864 1 118 865 1 119 866 1 120 866 2 121 869 1 122 870 1 123 873 1 124 874 1 125 882 1 126 883 1 127 885 1 128 895 1 129 908 1 130 131 Boxplot 1/28/2010 16:08.20 132 2 741 133 2 806 134 3 806 135 3 827 136 1 827 137 3 827 138 3 851.5 139 2 851.5 140 2 895 141 2 851.5 142 1 851.5 143 1 806 144 2 806 145 1 669.5 146 3 669.5 147 1 737.75 148 3 737.75 149 1 919.75 150 3 919.75 151 1 988 152 3 988 153 1.8 980 154 1.8 1008 155 156 Dotplot 1/28/2010 16:08.20 157 741 1 158 751 1 159 757 1 160 757 2 161 760 1 162 774 1 163 775 1 164 780 1 165 784 1 166 785 1 167 790 1 168 792 1 169 798 1 170 799 1 171 799 2 172 800 1 173 802 1 174 803 1 175 804 1 176 806 1 177 806 2 178 809 1 179 812 1 180 815 1 181 815 2 182 815 3 183 816 1 184 816 2 185 817 1 186 817 2 187 817 3 188 818 1 189 819 1 190 819 2 191 821 1 192 822 1 193 823 1 194 826 1 195 827 1 196 827 2 197 827 3 198 828 1 199 830 1 200 831 1 201 832 1 202 835 1 203 836 1 204 837 1 205 838 1 206 839 1 207 842 1 208 842 2 209 842 3 210 844 1 211 845 1 212 846 1 213 847 1 214 848 1 215 849 1 216 851 1 217 853 1 218 856 1 219 857 1 220 857 2 221 858 1 222 859 1 223 859 2 224 864 1 225 865 1 226 866 1 227 866 2 228 869 1 229 870 1 230 874 1 231 882 1 232 883 1 233 885 1 234 895 1 235 980 1 236 1008 1 A B C D E F G H I J K L 1 2 Data Set 3 --Lincolnville School District Bus Data 3 ID Manufacturer Engine Type (0=diesel) Capacity Maintenance Cost Age Odometer Miles Miles 4 10 Keiser 1 14 4646 5 54375 11973 5 396 Thompson 0 14 1072 2 21858 11969 6 122 Bluebird 1 55 9394 10 116580 11967 7 751 Keiser 0 14 1078 2 22444 11948 8 279 Bluebird 0 55 1008 2 22672 11925 9 500 Bluebird 1 55 5329 5 50765 11922 Variables 10 520 Bluebird 0 55 4794 10 119130 11896 11 759 Keiser 0 55 3952 8 87872 11889 ID = Bus identification number 12 714 Bluebird 0 42 3742 7 73703 11837 13 875 Bluebird 0 55 4376 9 97947 11814 Manufacturer = Source of the bus (Bluebird, Keiser, or Thompson) 14 600 Bluebird 0 55 4832 10 119860 11800 15 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) 16 101 Bluebird 0 55 1955 4 41096 11789 17 358 Bluebird 0 55 2775 6 70086 11782 Capacity = number of seats on the bus 18 29 Bluebird 1 55 5352 6 69438 11781 19 365 Keiser 0 55 3065 6 63384 11778 Maintenance cost = dollars spent to maintain a bus last year 20 162 Keiser 1 55 3143 3 31266 11757 21 686 Bluebird 0 55 1569 3 34674 11707 Age = number of years since the bus left the manufacturer 22 370 Keiser 1 55 7766 8 86528 11704 23 887 Bluebird 0 55 3743 8 93672 11698 Odometer Miles = total number of miles traveled by a bus 24 464 Bluebird 1 55 2540 3 34530 11698 25 948 Keiser 0 42 4342 9 97956 11691 Miles = number of miles traveled since last maintenance 26 678 Keiser 0 55 3361 7 75229 11668 27 481 Keiser 1 6 3097 3 34362 11662 28 43 Bluebird 1 55 8263 9 102969 11615 29 704 Bluebird 0 55 4218 8 83424 11610 30 814 Bluebird 0 55 2028 4 40824 11576 31 39 Bluebird 1 55 5821 6 69444 11533 32 699 Bluebird 1 55 9069 9 98307 11518 33 75 Bluebird 0 55 3011 6 71970 11462 34 693 Keiser 1 55 9193 9 101889 11461 35 989 Keiser 0 55 4795 9 106605 11418 36 982 Bluebird 0 55 505 1 10276 11359 37 321 Bluebird 0 42 2732 6 70122 11358 38 724 Keiser 0 42 3754 8 91968 11344 39 732 Keiser 0 42 4640 9 101196 11342 40 880 Keiser 1 55 8410 9 97065 11336 41 193 Thompson 0 14 5922 11 128711 11248 42 884 Bluebird 0 55 4364 9 92457 11231 43 57 Bluebird 0 55 3190 7 79240 11222 44 731 Bluebird 0 42 3213 6 68526 11168 45 61 Keiser 0 55 4139 9 103536 11148 46 135 Bluebird 0 55 3560 7 76426 11127 47 833 Thompson 0 14 3920 8 90968 11112 48 671 Thompson 1 14 6733 8 89792 11100 49 692 Bluebird 0 55 3770 8 93248 11048 50 200 Bluebird 0 55 5168 10 103700 11018 51 754 Keiser 0 14 7380 14 146860 11003 52 540 Bluebird 1 55 3656 4 45284 10945 53 660 Bluebird 1 55 6213 6 64434 10911 54 353 Keiser 1 55 4279 4 45744 10902 55 482 Bluebird 1 55 10575 10 116534 10802 56 398 Thompson 0 6 4752 9 95922 10802 57 984 Bluebird 0 55 3809 8 87664 10760 58 977 Bluebird 0 55 3769 7 79422 10759 59 705 Keiser 0 42 2152 4 47596 10755 60 767 Keiser 0 55 2985 6 71538 10726 61 326 Bluebird 0 55 4563 9 107343 10724 62 120 Keiser 0 42 4723 10 110320 10674 63 554 Bluebird 0 42 1826 4 44604 10662 64 695 Bluebird 0 55 1061 2 23152 10633 65 9 Keiser 1 55 3527 4 46848 10591 66 861 Bluebird 1 55 9669 10 106040 10551 67 603 Keiser 0 14 2116 4 44384 10518 68 156 Thompson 0 14 6212 12 140460 10473 69 427 Keiser 1 55 6927 7 73423 10355 70 883 Bluebird 1 55 1881 2 20742 10344 71 168 Thompson 1 14 7004 7 83006 10315 72 954 Bluebird 0 42 5284 10 101000 10235 73 768 Bluebird 0 42 3173 7 71778 10227 74 490 Bluebird 1 55 10133 10 106240 10210 75 725 Bluebird 0 55 2356 5 57065 10209 76 45 Keiser 0 55 3124 6 60102 10167 77 38 Keiser 1 14 5976 6 61662 10140 78 314 Thompson 0 6 5408 11 128117 10128 79 507 Bluebird 0 55 3690 7 72849 10095 80 40 Bluebird 1 55 9573 10 118470 10081 81 918 Bluebird 0 55 2470 5 53620 10075 82 387 Bluebird 1 55 6863 8 89960 10055 83 418 Bluebird 0 55 4513 9 104715 10000

• Around what values do the data tend to cluster? Specifically what was the mean maintenance cost last month? What is the median cost? Is one measure more representative of the typical cost than the others?
• What is the range of maintenance costs? What is the standard deviation? About 95% of the maintenance costs are between what two values?

1. Chapter 4 - Problem 25

TheDirectorofPlanningforDevineDiningInc.wishestostudytherelationshipbetweenthegenderofaguestandwhethertheguestordersdessert.Toinvestigatetherelationship,themanagercollectedthefollowinginformationon200recentcustomers.

Desert ordered: yes: male 32, female: 15, total 47

no: male 68, female 85, total 153

total: 100 100 200

1. Whatisthelevelofmeasurementofthetwovariables?
2. Whatistheabovetablecalled?
3. Doestheevidenceinthetablesuggestmenaremorelikelytoorderdessertthanwomen?Explainwhy.
4. Chapter 4 - Problem 46

RefertotheLincolnvilleSchoolDistrictbusdata.

1. Referringtothemaintenancecostvariable,developaboxplot.Whataretheminimum,firstquartile,median,thirdquartile,andmaximumvalues?Arethereanyoutliers?
2. Usingthemedianmaintenancecost,developacontingencytablewithbusmanufacturerasonevariableandwhetherthemaintenancecostwasaboveorbelowthemedianastheothervariable.Whatareyourconclusions?
3. Chapter 5 - Problem 94

RefertotheLincolnvilleschoolbusdata.Setupavariablethatdividestheageofthebusesintothreegroups:new(lessthan5yearsold),medium(5butlessthan10years),andold(10ormoreyears).Themedianmaintenancecostis$4,179.Basedonthisvalue,createavariableforthoselessthanorequaltothemedian(lowmaintenance)andthosemorethanthemedian(highmaintenancecost).Finally,developatabletoshowtherelationshipbetweenmaintenancecostandageofthebus.

1. Whatpercentageofthebusesarelessthanfiveyearsold?
2. Whatpercentageofthebuseslessthanfiveyearsoldhavelowmaintenancecosts?
3. Whatpercentageofthebusestenormoreyearsoldhavehighmaintenancecosts?
4. Doesmaintenancecostseemtoberelatedtotheageofthebus?Hint:Comparethemaintenancecostoftheoldbuseswiththecostofthenewbuses?Wouldyouconcludemaintenancecostisindependentoftheage?
5. Chapter 4 Case A - Century National Bank

A.CenturyNationalBank

Thefollowingcasewillappearinsubsequentreviewsections.AssumethatyouworkinthePlanningDepartmentoftheCenturyNationalBankandreporttoMs.Lamberg.Youwillneedtodosomedataanalysisandprepareashortwrittenreport.Remember,Mr.Seligisthepresidentofthebank,soyouwillwanttoensurethatyourreportiscompleteandaccurate.AcopyofthedataappearsinAppendixA.6.

CenturyNationalBankhasofficesinseveralcitiesintheMidwestandthesoutheasternpartoftheUnitedStates.Mr.DanSelig,presidentandCEO,wouldliketoknowthecharacteristicsofhischeckingaccountcustomers.Whatisthebalanceofatypicalcustomer?

Howmanyotherbankservicesdothecheckingaccountcustomersuse?DothecustomersusetheATMserviceand,ifso,howoften?Whataboutdebitcards?Whousesthem,andhowoftenaretheyused?

Tobetterunderstandthecustomers,Mr.SeligaskedMs.WendyLamberg,directorofplanning,toselectasampleofcustomersandprepareareport.Tobegin,shehasappointedateamfromherstaff.Youaretheheadoftheteamandresponsibleforpreparingthereport.Youselectarandomsampleof60customers.Inadditiontothebalanceineachaccountattheendoflastmonth,youdetermine(1)thenumberofATM(automatictellermachine)transactionsinthelastmonth;(2)thenumberofotherbankservices(asavingsaccount,acertificateofdeposit,etc.)thecustomeruses;(3)whetherthecustomerhasadebitcard(thisisabankserviceinwhichchargesaremadedirectlytothecustomer'saccount);and(4)whetherornotinterestispaidonthecheckingaccount.ThesampleincludescustomersfromthebranchesinCincinnati,Ohio;Atlanta,Georgia;Louisville,Kentucky;andErie,Pennsylvania.

1. Developagraphortablethatportraysthecheckingbalances.Whatisthebalanceofatypicalcustomer?Domanycustomershavemorethan$2,000intheiraccounts?Doesitappearthatthereisadifferenceinthedistributionoftheaccountsamongthefourbranches?Aroundwhatvaluedotheaccountbalancestendtocluster?
2. Determinethemeanandmedianofthecheckingaccountbalances.Comparethemeanandthemedianbalancesforthefourbranches.Isthereadifferenceamongthebranches?Besuretoexplainthedifferencebetweenthemeanandthemedianinyourreport.

Determinetherangeandthestandarddeviationofthecheckingaccountbalances.Whatdothefirstandthirdquartilesshow?Determinethecoefficientofskewnessandindicatewhatitshows.BecauseMr.Seligdoesnotdealwithstatisticsdaily,includeabriefdescriptionandinterpretationofthestandarddeviationandothermeasures.

Reference the "Century National Bank Data" as directed to complete the topic assignment. A B C D E F 1 Balance ATM Services Debit Interest City 2 1756 13 4 0 1 2 3 748 9 2 1 0 1 4 1501 10 1 0 0 1 5 1831 10 4 0 1 3 6 1622 14 6 0 1 4 7 1886 17 3 0 1 1 8 740 6 3 0 0 3 9 1593 10 8 1 0 1 10 1169 6 4 0 0 4 11 2125 18 6 0 0 2 12 1554 12 6 1 0 3 13 1474 12 7 1 0 1 14 1913 6 5 0 0 1 15 1218 10 3 1 0 1 16 1006 12 4 0 0 1 17 2215 20 3 1 0 4 18 137 7 2 0 0 3 19 167 5 4 0 0 4 20 343 7 2 0 0 1 21 2557 20 7 1 0 4 22 2276 15 4 1 0 3 23 1494 11 2 0 1 1 24 2144 17 3 0 0 3 25 1995 10 7 0 0 2 26 1053 8 4 1 0 3 27 1526 8 4 0 1 2 28 1120 8 6 1 0 3 29 1838 7 5 1 1 3 30 1746 11 2 0 0 2 31 1616 10 4 1 1 2 32 1958 6 2 1 0 2 33 634 2 7 1 0 4 34 580 4 1 0 0 1 35 1320 4 5 1 0 1 36 1675 6 7 1 0 2 37 789 8 4 0 0 4 38 1735 12 7 0 1 3 39 1784 11 5 0 0 1 40 1326 16 8 0 0 3 41 2051 14 4 1 0 4 42 1044 7 5 1 0 1 43 1885 10 6 1 1 2 44 1790 11 4 0 1 3 45 765 4 3 0 0 4 46 1645 6 9 0 1 4 47 32 2 0 0 0 3 48 1266 11 7 0 0 4 49 890 7 1 0 1 1 50 2204 14 5 0 0 2 51 2409 16 8 0 0 2 52 1338 14 4 1 0 2 53 2076 12 5 1 0 2 54 1708 13 3 1 0 1 55 2138 18 5 0 1 4 56 2375 12 4 0 0 2 57 1455 9 5 1 1 3 58 1487 8 4 1 0 4 59 1125 6 4 1 0 2 60 1989 12 3 0 1 2 61 2156 14 5 1 0 2

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.