Question

A steel company is considering the relocation of one of its manufacturing plants. The company’s executives...

A steel company is considering the relocation of one of its manufacturing plants. The company’s executives have selected four areas that they believe are suitable locations. However, they want to determine if the average wages are significantly different in any of the locations, since this could have a major impact on the cost of production. A survey of hourly wages of similar workers in each of the four areas is performed with the following results. Do the data indicate a significant difference among the average hourly wages in the three areas?

Hourly Wages ($)
Area 1 Area 2 Area 3
8 19 18
13 15 11
17 24 20
10 14 18
16 20 20
19 24 13
15 17 15
8 11 13

Step 1 of 2:

Find the value of the test statistic to test for a difference in the areas. Round your answer to two decimal places, if necessary.

Step 2 of 2:

Make the decision to reject or fail to reject the null hypothesis of equal average hourly wages in the three areas and state the conclusion in terms of the original problem. Use α=0.01.

Homework Answers

Answer #1

For the given data using Anova single factor in Excel we get output as

Anova: Single Factor
SUMMARY
Groups Count Sum Average Variance
Area 1 8 106 13.25 17.64286
Area 2 8 144 18 21.71429
Area 3 8 128 16 12
ANOVA
Source of Variation SS df MS F P-value F crit
Between Groups 91 2 45.5 2.657858 0.09355 5.780416
Within Groups 359.5 21 17.11905
Total 450.5 23

So from the above output

F = ms between / ms within

F = 45.5 / 17.11905

F = 5.78

value of the test statistic = 2.66

Decision :

At   α=0.01 l.o.s , df = ( 2,21 )

F critical value = 5.78

f cal < f crit

i.e., 2.66 < 5.78

so fail to reject the null hypothesis  

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
A steel company is considering the relocation of one of its manufacturing plants. The company’s executives...
A steel company is considering the relocation of one of its manufacturing plants. The company’s executives have selected four areas that they believe are suitable locations. However, they want to determine if the average wages are significantly different in any of the locations, since this could have a major impact on the cost of production. A survey of hourly wages of similar workers in each of the four areas is performed with the following results. Do the data indicate a...
The Chart Listed Is The Only Info You Need (Anderson et al. 2015) A sample of...
The Chart Listed Is The Only Info You Need (Anderson et al. 2015) A sample of 8 seafood restaurants, 8 Italian restaurants and 8 Steakhouses is selected. The meal price (the average amount paid per person for dinner and drinks, minus the tip) is recorded for each restaurant. The data is provided in the spreadsheet "GrandStand.xlsx", which is available in the Week6 folder. Use level of significance 0.05 to test whether there is a significant difference among the mean meal...
A manufacturing company is purchasing metal pipes of standard length from two different suppliers, ABC and...
A manufacturing company is purchasing metal pipes of standard length from two different suppliers, ABC and XYZ. In the past two months there are increasing complaints by the Production Manager that delivery times by ABC present higher variability in comparison to the delivery times by XYZ. The Production Manager is worried that this variability will make it harder to efficiently schedule the production process. If the variance of XYZ remains unchanged, what should be the variance of ABC in order...
Part A. In the past it has been found that the arrival time have a population...
Part A. In the past it has been found that the arrival time have a population mean value of μ = 13 and a population standard deviation of σ = 6.26. Using the given data, test whether this mean has changed. Use the critical value approach to test the hypothesis. The significance level alpha is set at 0.05 . The original data of time taken is given below. Show the process by using excel (Formulas). Part B. Test the hypothesis...
Assuming that the population standard deviation is unknown, calculate the 95% confidence interval of the population...
Assuming that the population standard deviation is unknown, calculate the 95% confidence interval of the population mean. The following is the data. Calculating Process should be shown by Excel (Formulas). What formulas in statistics are used? 7 21 23 24 18 16 2 19 11 6 3 13 17 9 5 12 13 17 4 14 15 25 12 24 22 14 14 20 15 11 26 17 21 11 4 13 16 14 13 14 25 23 9 15...
A company has the following returns over the past 30 months: Month Ret.(%) Month Ret.(%) Month...
A company has the following returns over the past 30 months: Month Ret.(%) Month Ret.(%) Month Ret.(%) 1) 3 11   -3 21 -1 2) -16 12 -2 22 -24 3) 31 13 -8 23 -14 4) 33 14 2 24 -19 5) -23 15 35 25 -19 6) -17 16 11 26 33 7) 8 17 -20 27 -18    8) -19 18 15 28 23 9) -13 19 -12 29 6 10 -17 20 17 30 5 What is...
Test, at the 1% level of significance, whether the average business has more than 15 employees....
Test, at the 1% level of significance, whether the average business has more than 15 employees. Answer using excel. Employees 14 17 17 6 8 17 21 16 6 17 11 17 15 16 20 19 6 12 17 22 20 17 11 11 9 22 17 18 21 20 26 7 16 19 18 11 21 17 25 16 22 14 14 16 18 20 21 11 19 13 6 11 19 14 18 31 13 15 17 21...
A manufacturing company is purchasing metal pipes of standard length from two different suppliers, ABC and...
A manufacturing company is purchasing metal pipes of standard length from two different suppliers, ABC and XYZ. In the past two months there are increasing complaints by the Production Manager that delivery times by ABC present higher variability in comparison to the delivery times by XYZ. The Production Manager is worried that this variability will make it harder to efficiently schedule the production process. Does the sample data indicate a statistically significant difference at the 5% level? Justify your answer....
A manufacturing company is purchasing metal pipes of standard length from two different suppliers, ABC and...
A manufacturing company is purchasing metal pipes of standard length from two different suppliers, ABC and XYZ. In the past two months there are increasing complaints by the Production Manager that delivery times by ABC present higher variability in comparison to the delivery times by XYZ. The Production Manager is worried that this variability will make it harder to efficiently schedule the production process. Does the sample data indicate a statistically significant difference at the 5% level? Justify your answer....
A consumer advocate researches the length of life between two brands of refrigerators, Brand A and...
A consumer advocate researches the length of life between two brands of refrigerators, Brand A and Brand B. He collects data (measured in years) on the longevity of 40 refrigerators for Brand A and repeats the sampling for Brand B. These data are measured in years. (You may find it useful to reference the appropriate table: z table or t table) Brand A Brand B Brand A Brand B 25 21 18 19 15 15 24 19 24 15 17...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT