solution
Tyre manufactures are constantly researching ways to produce tyres that last longer. Innovations are tested by professional drivers on race tracks, as well as by ordinary drivers. To determine whether a new steel-belted radial tyre lasts longer than the company’s existing model, the company conducts the following experiment. On 35 randomly selected cars, existing tyres are installed on both rear wheels. The cars are driven until the tyres wear out. Then existing tyres are replaced by newly-designed tyres on both rear wheels of the same cars. The cars are driven until the tyres wear out. The number of kilometres until wear-out occurred was recorded in the tyres.xlsx. Use Excel to carry out a suitable test to address the following research question: Is there a difference between the average number of kilometers until wear-out for the existing and new design tyres? Use your Excel output, and any appropriate plots provided to answer the following questions. For each question, either choose the most correct option, or type in the answer to the number of decimal places specified. (1 mark) The most appropriate test for these data is Answer (1 mark) Referring to the histograms provided, to check the assumption(s) for this test we would use Answer A. Distance until wear-out of Existing design (Graph A) B. Distance until wear-out of New design (Graph B) C. Distance until wear-out of Existing design and Distance until wear-out of New design(Graphs A and B) D. Differences in distance until wear-out (Graph C) E.None of the other answers For the remaining questions you may assume that any relevant assumptions have been met. (2 marks) The absolute value of the test statistic is equal to (type your answer with 3 dp) Answer (1 mark) The degrees of freedom is equal to (type your answer as an integer) Answer (1 mark) The p-value is larger than 0.05 Answer (2 marks) The test indicates that the distance (in thousands of kilometres) until wear-out: Answer A. was significantly different (was longer, on average, for the new design). B. was significantly different (was longer, on average, for the current design). C. could have been the same, on average, for either design.
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

