Question

In: Math

(Use Excel or R) Wenton Powersports produces dune buggies. They have three assembly lines, “Razor,” “Blazer,”...

(Use Excel or R)

Wenton Powersports produces dune buggies. They have three assembly lines, “Razor,” “Blazer,” and “Tracer,” named after the particular dune buggy models produced on those lines. Each assembly line was originally designed using the same target production rate. However, over the years, various changes have been made to the lines. Accordingly, management wishes to determine whether the assembly lines are still operating at the same average hourly production rate. Production data (in dune buggies/hour) for the last eight hours are as follows.

Razor Blazer Tracer
11 10 9
10 8 9
8 11 10
10 9 9
9 9 8
9 10 7
13 13 8
11 8 9

a. Specify the competing hypotheses to test whether there are some differences in the mean production rates across the three assembly lines.

  • H0: μRazor = μBlazer = μTracer. HA: Not all population means are equal.

  • H0: μRazorμBlazerμTracer. HA: Not all population means are equal.

  • H0: μRazorμBlazerμTracer. HA: Not all population means are equal.

b-1. Construct an ANOVA table. Assume production rates are normally distributed. (Round "Sum Sq" to 2 decimal places, "Mean Sq" and "F value" to 3, and "p-value" to 4 decimal places.)

b-2. At the 5% significance level, what is the conclusion to the test?

b-3. What about the 10% significance level?

Solutions

Expert Solution

Using Excel: Data > Data Analysis > Anova: Single Factor

Anova: Single Factor
SUMMARY
Groups Count Sum Average Variance
Razor 8 81 10.125 2.410714
Blazer 8 78 9.75 2.785714
Tracer 8 69 8.625 0.839286
ANOVA
Source of Variation SS df MS F P-value F crit at 0.05
Between Groups 9.75 2 4.875 2.423 0.113017 3.4668
Within Groups 42.25 21 2.012
Total 52 23

a. Null and Alternative hypothesis:

H0: μRazor = μBlazer = μTracer. HA: Not all population means are equal.

b-1. ANOVA table.

Source of Variation SS df MS F P-value
Between Groups 9.75 2 4.875 2.423 0.1130
Within Groups 42.25 21 2.012
Total 52 23

b-2. As p-value = 0.01130 > 0.05, we fail to reject the null hypothesis.

There is not enough evidence to conclude that not all population means are equal.

b-3. As p-value = 0.01130 > 0.10, we fail to reject the null hypothesis.

There is not enough evidence to conclude that not all population means are equal.


Related Solutions

Wenton Powersports produces dune buggies. They have three assembly lines, “Razor,” “Blazer,” and “Tracer,” named after...
Wenton Powersports produces dune buggies. They have three assembly lines, “Razor,” “Blazer,” and “Tracer,” named after the particular dune buggy models produced on those lines. Each assembly line was originally designed using the same target production rate. However, over the years, various changes have been made to the lines. Accordingly, management wishes to determine whether the assembly lines are still operating at the same average hourly production rate. Production data (in dune buggies/hour) for the last eight hours are as...
Wenton Powersports produces dune buggies. They have three assembly lines, “Razor,” “Blazer,” and “Tracer,” named after...
Wenton Powersports produces dune buggies. They have three assembly lines, “Razor,” “Blazer,” and “Tracer,” named after the particular dune buggy models produced on those lines. Each assembly line was originally designed using the same target production rate. However, over the years, various changes have been made to the lines. Accordingly, management wishes to determine whether the assembly lines are still operating at the same average hourly production rate. Production data (in dune buggies/hour) for the last eight hours are as...
Wenton Powersports produces dune buggies. They have three assembly lines, “Razor,” “Blazer,” and “Tracer,” named after...
Wenton Powersports produces dune buggies. They have three assembly lines, “Razor,” “Blazer,” and “Tracer,” named after the particular dune buggy models produced on those lines. Each assembly line was originally designed using the same target production rate. However, over the years, various changes have been made to the lines. Accordingly, management wishes to determine whether the assembly lines are still operating at the same average hourly production rate. Production data (in dune buggies/hour) for the last eight hours are as...
A manufacturing process has two assembly lines, A and B. Suppose that line A produces 60%...
A manufacturing process has two assembly lines, A and B. Suppose that line A produces 60% of the product. and line B produces the rest. We are told that 5% of the products produced by line A are defective in some way, and 8% of the line B products are defective. it may be helpful to construct a tree diagram with first and second-generation branches to answer the following: C) if the end product is defective, what is the probability...
A company uses three different assembly lines – A1, A2, and A3 – to manufacture a...
A company uses three different assembly lines – A1, A2, and A3 – to manufacture a particular component. Of those manufactured by line A1, 5% need rework to remedy a defect, whereas 8% of A2’s components need rework and 10% of A3’s need rework. Suppose that 50% of all components are produced by line A1, 30% are produced by line A2, and 20% come from line A3. (a) Suppose a component is selected at random, what is the probability that...
We have these 3 lines in an excel file. The goal is to set all the...
We have these 3 lines in an excel file. The goal is to set all the lines like the second one ( 26/07/2019) 24-Apr-2019 26/07/2019 03/03/2017 16:29
Excel Assignment 2 Direction: Use Microsoft Excel to answer the following three questions (Excel Instructions are...
Excel Assignment 2 Direction: Use Microsoft Excel to answer the following three questions (Excel Instructions are provided in previous assignment) 1. An Economist was interested in sex differences in the number of books a person reads (see file: Number of Books). Two random samples were taken, one of men and the other, and the number of books read during the last month was recorded. Is there a difference with respect to the number of books read by females and males?...
5. Use either R or Excel for the following. Provide the formulas or code that you...
5. Use either R or Excel for the following. Provide the formulas or code that you are using. Let x1 be a random variable that is N(100, 225). Let x2 be a random variable that is U(50,150) and let x3 be a random variable that is U(500,1500). Set Y = (X1)(X2)/ (X3) a) Use R to create 500 random numbers of each type (X1, X2, X3 and Y). b) Estimate P(0.1 < Y < 0.25) c) Estimate E(Y) and the...
Use the CardioGoodFitness data. The company sells three different lines of treadmills. The TM195 is an...
Use the CardioGoodFitness data. The company sells three different lines of treadmills. The TM195 is an entry-level treadmill designed for those who want minimal programs and the desire for simplicity to initiate their walk or hike. The TM498 is a middle-line model for those who are in a transitional stage from walkers to running or midlevel runners. It has two programs and a 15% elevation upgrade from the TM195. The TM798 is the top-of-the-line treadmill which is structurally larger and...
Wallace, Inc., produces a product tha goes through three departments: Machining, Assembly, and Polishing. Materials are...
Wallace, Inc., produces a product tha goes through three departments: Machining, Assembly, and Polishing. Materials are added at the beginning of the machining operation; labor and overhead are added uniformly throughout the process. The Machining department had work in process at the beginning and end of 1998 as follows: Percentage of Completion Materials Conversion Costs Januarty 1, 1998, 2,500 units 100 60 December 31, 1998, 4,000 units 100 50 The company completed 42,500 units during the year and incurred the...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT