Question: please show work and answer questions. i give like! A systems engineer conducted an experiment to help the purchasing department in his company decide which

please show work and answer questions. i give like!
please show work and answer questions. i give
please show work and answer questions. i give
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 feat. He looked at 7 brands operating with three different fuel types to better-evaluate the miles-per-galon performance. The raw data is shown below. Van Brand 1 2 3 4 5 6 1 32 31 30 33 30 31 Fuel Type 2 30 29 28 31 29 27 3 35 37 37 34 30 36 The ANOVA output he obtained from Excel is shown below. Anova: Two-Factor Without Replication 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 3 3 Column 1 Column 2 Column 3 Column 4 Column 5 Column 6 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 ANOVA Source of Variation Row Columns SS 104.333 18 dr MS Pwole Ecrit 2 52.1667 15.495 0.00086 4.10282 5 3.6 1.06931 0.43196 332581 un LET ANOVA Source of Variation df Rows Columns Error SS 104.333 18 33.6667 MS F P-value Ferir 2 52.1667 15.495 0.00086 4.10282 5 3.6 1.06931 0.43196 3.32583 10 3.36667 Total 156 17 Based on the ANOVA output answer the list of question below in the textbox provided. Make sure you start each answer with the number of the question to 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 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 tot ensary to investigate the problem further enor No? Briefly explain why your answer is a yes or no For the core ALY.FOPO AT.P.P10 Mac

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!