Complete the problems below from the textbook. You will need to use the "Lincolnville School District Bus Data" file for this assignment.The files have been attached Chapter 12 – Problem 51 Chapter 15...

1 answer below »

Complete the problems below from the textbook. You will need to use the "Lincolnville School District Bus Data" file for this assignment.The files have been attached



  1. Chapter 12 – Problem 51

  2. Chapter 15 – Problem 57

  3. Chapter 15 – Problem 64


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. All graphs, data, and statistical outputs for each problem must be on the tab for the problem on the excel attached file ( Week 8 Stats). A text block with the question has been placed on the excel file. Please be sure that the answer to the problem is typed under the question for each of the problems.


Submit output in one Excel file.




ChartDataSheet_ This worksheet contains values required for MegaStat charts. Boxplot 1/28/2010 16:03.39 2741 2806 3806 3827 1827 3827 3851.5 2851.5 2908 2851.5 1851.5 1806 2806 1669.5 3669.5 1737.75 3737.75 1919.75 3919.75 1988 3988 Boxplot 1/28/2010 16:06.08 2741 2806 3806 3827 1827 3827 3851.5 2851.5 2908 2851.5 1851.5 1806 2806 1669.5 3669.5 1737.75 3737.75 1919.75 3919.75 1988 3988 Dotplot 1/28/2010 16:06.08 7411 7511 7571 7572 7601 7741 7751 7801 7841 7851 7901 7921 7981 7991 7992 8001 8021 8031 8041 8061 8062 8091 8121 8151 8152 8153 8161 8162 8171 8172 8173 8181 8191 8192 8211 8221 8231 8261 8271 8272 8273 8281 8301 8311 8321 8351 8361 8371 8381 8391 8421 8422 8423 8441 8451 8461 8471 8481 8491 8511 8531 8561 8571 8572 8581 8591 8592 8641 8651 8661 8662 8691 8701 8731 8741 8821 8831 8851 8951 9081 Boxplot 1/28/2010 16:08.20 2741 2806 3806 3827 1827 3827 3851.5 2851.5 2895 2851.5 1851.5 1806 2806 1669.5 3669.5 1737.75 3737.75 1919.75 3919.75 1988 3988 1.8980 1.81008 Dotplot 1/28/2010 16:08.20 7411 7511 7571 7572 7601 7741 7751 7801 7841 7851 7901 7921 7981 7991 7992 8001 8021 8031 8041 8061 8062 8091 8121 8151 8152 8153 8161 8162 8171 8172 8173 8181 8191 8192 8211 8221 8231 8261 8271 8272 8273 8281 8301 8311 8321 8351 8361 8371 8381 8391 8421 8422 8423 8441 8451 8461 8471 8481 8491 8511 8531 8561 8571 8572 8581 8591 8592 8641 8651 8661 8662 8691 8701 8741 8821 8831 8851 8951 9801 10081 Bus Data Set 3 --Lincolnville School District Bus Data IDManufacturerEngine Type (0=diesel)CapacityMaintenance CostAgeOdometer MilesMiles 10Keiser114464655437511973 396Thompson014107222185811969 122Bluebird15593941011658011967 751Keiser014107822244411948 279Bluebird055100822267211925 500Bluebird155532955076511922Variables 520Bluebird05547941011913011896 759Keiser055395288787211889ID = Bus identification number 714Bluebird042374277370311837 875Bluebird055437699794711814Manufacturer = Source of the bus (Bluebird, Keiser, or Thompson) 600Bluebird05548321011986011800 953Bluebird05551601011770011798Engine type = If the engine is diesel then engine type = 0; if the engine is gasoline, then engine type = 1) 101Bluebird055195544109611789 358Bluebird055277567008611782Capacity = number of seats on the bus 29Bluebird155535266943811781 365Keiser055306566338411778Maintenance cost = dollars spent to maintain a bus last year 162Keiser155314333126611757 686Bluebird055156933467411707Age = number of years since the bus left the manufacturer 370Keiser155776688652811704 887Bluebird055374389367211698Odometer Miles = total number of miles traveled by a bus 464Bluebird155254033453011698 948Keiser042434299795611691Miles = number of miles traveled since last maintenance 678Keiser055336177522911668 481Keiser16309733436211662 43Bluebird1558263910296911615 704Bluebird055421888342411610 814Bluebird055202844082411576 39Bluebird155582166944411533 699Bluebird155906999830711518 75Bluebird055301167197011462 693Keiser1559193910188911461 989Keiser0554795910660511418 982Bluebird05550511027611359 321Bluebird042273267012211358 724Keiser042375489196811344 732Keiser0424640910119611342 880Keiser155841099706511336 193Thompson01459221112871111248 884Bluebird055436499245711231 57Bluebird055319077924011222 731Bluebird042321366852611168 61Keiser0554139910353611148 135Bluebird055356077642611127 833Thompson014392089096811112 671Thompson114673388979211100 692Bluebird055377089324811048 200Bluebird05551681010370011018 754Keiser01473801414686011003 540Bluebird155365644528410945 660Bluebird155621366443410911 353Keiser155427944574410902 482Bluebird155105751011653410802 398Thompson06475299592210802 984Bluebird055380988766410760 977Bluebird055376977942210759 705Keiser042215244759610755 767Keiser055298567153810726 326Bluebird0554563910734310724 120Keiser04247231011032010674 554Bluebird042182644460410662 695Bluebird055106122315210633 9Keiser155352744684810591 861Bluebird15596691010604010551 603Keiser014211644438410518 156Thompson01462121214046010473 427Keiser155692777342310355 883Bluebird155188122074210344 168Thompson114700478300610315 954Bluebird04252841010100010235 768Bluebird042317377177810227 490Bluebird155101331010624010210 725Bluebird055235655706510209 45Keiser055312466010210167 38Keiser114597666166210140 314Thompson0654081112811710128 507Bluebird055369077284910095 40Bluebird15595731011847010081 918Bluebird055247055362010075 387Bluebird155686388996010055 418Bluebird0554513910471510000
Answered Same DaySep 26, 2021

Answer To: Complete the problems below from the textbook. You will need to use the "Lincolnville School...

Suraj answered on Sep 28 2021
136 Votes
Chapter 12 – Problem 51
                                        a.    One way ANOVA                        b.     One way ANOVA
                                        Maintainence cost                            Miles traveled by a bus
                                        Keiser    Thompson    Bluebird                    Keiser    Thompson    Bluebird
                                        4646    1072    9394                    11973    11969    11967
                                        1078    5922    1008                    11948    11248    11925
                                        3952    3920    5329                    11889    11112    11922
                                        3065    6733    4794                    11778    11100    11896
                                        3143    4752    3742                    11757    10802    11837
                                        7766    6212    4376                    11704    10473    11814
                                        4342    7004    4832                    11691    10315    11800
                                        3361    5408    5160                    11668    10128    11798
                                        3097        1955                    11662        11789
                                        9193        2775                    11461        11782
                                        4795        5352                    11418        11781
                                        3754        1569                    11344        11707
                                        4640        3743                    11342        11698
                                        8410        2540                    11336        11698
                                        4139        8263                    11148        11615
                                        7380        4218                    11003        11610
                                        4279        2028                    10902        11576
                                        2152        5821                    10755        11533
                                        2985        9069                    10726        11518
                                        4723        3011                    10674        11462
                                        3527        505                    10591        11359
                                        2116        2732                    10518        11358
                                        6927        4364                    10355        11231
                                        3124        3190                    10167        11222
                                        5976        3213                    10140        11168
                                                3560                            11127
                                                3770                            11048
                                                5168                            11018
                                                3656                            10945
                                                6213                            10911
                                                10575                            10802
                                                3809                            10760
                                                3769                            10759
                                                4563                            10724
                                                1826                            10662
                                                1061                            10633
                                                9669                            10551
                                                1881                            10344
                                                5284                            10235
                                                3173                            10227
                                                10133                            10210
                                                2356                            10209
                                                3690                            10095
                                                9573                            10081
                                                2470                            10075
                                                6863                            10055
                                                4513                            10000
                                    Anova: Single Factor                                        Anova: Single Factor
                                    SUMMARY                                        SUMMARY
                                    Groups    Count    Sum    Average    Variance                        Groups    Count    Sum    Average    Variance
                                    Keiser    25    112570    4502.8    4199550.33333333                        Keiser    25    279950    11198    331208.583333333
                                    Thompson    8    41023    5127.875    3718724.125                        Thompson    8    87147    10893.375    354085.696428571
                                    Bluebird    47    210558    4479.9574468085    6514563.04162812                        Bluebird    47    522537    11117.8085106383    412430.810360784
                                    ANOVA                                        ANOVA
                                    Source of Variation    SS    df    MS    F    P-value    F...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here