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. (See Google docs link)

• 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. (See google docs link)

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.