94. Refer to the Lincolnville school bus data. Set up a variable that divides the age ofthe buses into three groups: new (less than 5 years old), medium (5 but less than 10 years),and old (10 or more...

1 answer below »
94. Refer to the Lincolnville school bus data. Set up a variable that divides the age ofthe buses into three groups: new (less than 5 years old), medium (5 but less than 10 years),and old (10 or more years). The median maintenance cost is $4,179. Based on thisvalue, create a variable for those less than or equal to the median (low maintenance)and those more than the median (high maintenance cost). Finally, develop a table toshow the relationship between maintenance cost and age of the bus.a. What percentage of the buses are less than five years old?b. What percentage of the buses less than five years old have low maintenance costs?c. What percentage of the buses ten or more years old have high maintenance costs?d. Does maintenance cost seem to be related to the age of the bus? Hint: Compare themaintenance cost of the old buses with the cost of the new buses? Would you concludemaintenance cost is independent of the age?
46. Refer to the Lincolnville School District bus data.a. Referring to the maintenance cost variable, develop a box plot. What are the minimum,first quartile, median, third quartile, and maximum values? Are there anyoutliers?b. Using the median maintenance cost, develop a contingency table with bus manufactureras one variable and whether the maintenance cost was above or below themedian as the other variable. What are your conclusions?
25. The Director of Planning for Devine Dining Inc. wishes to study the relationship betweenthe gender of a guest and whether the guest orders dessert. To investigate therelationship, the manager collected the following information on 200 recent customers.GenderDessert Ordered Male Female TotalYes 32 15 47No 68 85 153Total 100 100 200a. What is the level of measurement of the two variables?b. What is the above table called?c. Does the evidence in the table suggest men are more likely to order dessertthan women? Explain why.
The following case will appear in subsequent review sections.Assume that you work in the Planning Department ofthe Century National Bank and report to Ms. Lamberg. Youwill need to do some data analysis and prepare a short writtenreport. Remember, Mr. Selig is the president of the bank,so you will want to ensure that your report is complete andaccurate. A copy of the data appears in Appendix A.6.Century National Bank has offices in several cities inthe Midwest and the southeastern part of the UnitedStates. Mr. Dan Selig, president and CEO, would like toknow the characteristics of his checking account customers.What is the balance of a typical customer?How many other bank services do the checking accountcustomers use? Do the customers use the ATM serviceand, if so, how often? What about debit cards? Whouses them, and how often are they used?To better understand the customers, Mr. Selig askedMs. Wendy Lamberg, director of planning, to select a sampleof customers and prepare a report. To begin, she hasappointed a team from her staff. You are the head of theteam and responsible for preparing the report. You select arandom sample of 60 customers. In addition to the balancein each account at the end of last month, you determine(1) the number of ATM (automatic teller machine) transactionsin the last month; (2) the number of other bank services(a savings account, a certificate of deposit, etc.) thecustomer uses; (3) whether the customer has a debit card(this is a bank service in which charges are made directly tothe customer’s account); and (4) whether or not interest ispaid on the checking account. The sample includes customersfrom the branches in Cincinnati, Ohio; Atlanta,Georgia; Louisville, Kentucky; and Erie, Pennsylvania.1. Develop a graph or table that portrays the checkingbalances. What is the balance of a typical customer?Do many customers have more than $2,000 in theiraccounts? Does it appear that there is a difference inthe distribution of the accounts among the fourbranches? Around what value do the account balancestend to cluster?2. Determine the mean and median of the checking accountbalances. Compare the mean and the medianbalances for the four branches. Is there a differenceamong the branches? Be sure to explain the differencebetween the mean and the median in your report.3. Determine the range and the standard deviation ofthe checking account balances. What do the first andthird quartiles show? Determine the coefficient ofskewness and indicate what it shows. BecauseMr. Selig does not deal with statistics daily, include abrief description and interpretation of the standarddeviation and other measures.
88. Refer to the Lincolnville School District bus data. Prepare a report on the maintenancecost for last month. Be sure to answer the following questions in your report.a. Around what values do the data tend to cluster? Specifically what was the meanmaintenance cost last month? What is the median cost? Is one measure more representativeof the typical cost than the others?b. What is the range of maintenance costs? What is the standard deviation? About 95%of the maintenance costs are between what two values?








Answered Same DayJan 27, 2021

Answer To: 94. Refer to the Lincolnville school bus data. Set up a variable that divides the age ofthe buses...

Pooja answered on Jan 27 2021
134 Votes
Bus
    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
94
    Age    Maintenance Cost        Age Coded    Maintenance Cost Coded
    5    4646        medium    high maintenance        Count of Maintenance Cost Coded    Maintenance Cost Coded
    2    1072        new    low maintenance        Age Coded    high maintenance    low maintenance    Grand Total
    10    9394        old    high maintenance        medium    24    23    47
    2    1078        new    low maintenance        new    1    17    18
    2    1008        new    low...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here