Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

both pictures are part of the same question. thank you :) QUESTION 17 A systems engineer conducted an experiment to help the purchasing department in

image text in transcribed
image text in transcribed
both pictures are part of the same question.
thank you :)
QUESTION 17 A systems engineer conducted an experiment to help the purchasing department in his company decide which type of vans to purchase for the company as part of its effort to modernize its aging delivery floot. He looked at 7 brands operating with three different fuel types to better- evaluate the miles-per-gallon performance. The raw data is shown below. Van Brand 1 2 3 4 5 6 1 32 31 30 30 31 Fuel Type 2 30 29 28 29 27 3 35 37 37 34 30 36 The ANOVA output he obtained from Excel is shown below. Anova: Two-Factor Without Replication 33 31 SUMMARY Row 1 Row 2 Row 3 Count 6 6 6 Sum Average Variance 187 31.1667 1.36667 174 29 2 209 34.8333 6.96667 Column 1 Column 2 Column 3 Column 4 Column 5 Column 6 3 3 3 3 3 3 97 32.3333 6.33333 97 32.3333 17.3333 95 31.6667 22.3333 98 32.6667 2.33333 89 29.6667 0.33333 94 31.3333 20.3333 Column 2 Column 3 Column 4 Column 5 Column 6 3 3 3 3 3 97 32:3333 17.3333 95 31.6667 22.3333 98 32.6667 2.33333 89 29.6667 0.33333 94 31.3333 20.3333 ANOVA Source of Variation df Rows Columns Error SS 104.333 18 MS F P-value Fcrit 2 52.1667 15.495 0.00086 4.10282 5 3.6 1.06931 0.43196 3.32583 10 3.36667 33.6667 Total 156 17 Based on the ANOVA output, answer the list of questions below in the textbox provided. Make sure you start each answer with the number of the question so that your answers are organized by question number. 1. State the two null hypotheses for this problem. 2. What are the two p-values in the output? 3. Indicate whether you reject or fail to reject the two null hypotheses you stated in question 1 based on a significance level of 0.05. 4. Interpret the answer of question 3 based on the language of the problem. Specifically, what does the output say about the Van Brand and Fuel Type? 5. Is a Tukey's test necessary to investigate the problem further (Yes or No)? Briefly explain why your answer is a yes or no

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Accounting questions