Great Deal! Get Instant $10 FREE in Account on First Order + 10% Cashback on Every Order Order Now

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.

Answered Same Day Sep 26, 2021

Solution

Suraj answered on Sep 28 2021
150 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 Facto
                                    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