One way analysis of variance in excel

Reference no: EM1320920

There are four auto body shops in a community and all claim to promptly serve customers. To check if there is any difference in service, customers are randomly selected from each repair shop and their waiting times in days are recorded. The output from a statistical software package is:

Summary
Groups	Count	Sum	Average	Variance
Body Shop A	3	15.4	5.133333	0.323333
Body Shop B	4	32	8	1.433333
Body Shop C	5	25.2	5.04	0.748
Body Shop D	4	25.9	6.475	0.595833

ANOVA
Source of Variation	SS	df	MS	F	p-value
Between Groups	23.37321	3	7.791069	9.612506	0.001632
Within Groups	9.726167	12	0.810514
Total	33.09938	15

Is there evidence to suggest a difference in the mean waiting times at the four body shops? Use the .05 significance level.

Reference no: EM1320920

Questions Cloud

Appropriate test for interval and ratio data : Evaluate the data below using the Kruskal - Wallis Nonparametric Hypothesis Test. Explain why you chose this particular nonparametric test to analyze your data.

Standpoint of the power company : Assume a person is severely injured by electricity while trying to remove a kite from the power line after having climbed a power pole without the utility's permission. The injured party sues the power company. What are good defences from the stan..

Conclusion that the guideline is still reasonable : At the .05 significance level, can we conclude that the guideline is still reasonable?

Most significant challenge associated with leverage : Analyze the ways in which managers could use the Federal Register to determine the single most significant challenge associated with its use, and how managers could address that challenge. Provide specific examples to support your response.

One way analysis of variance in excel : Is there evidence to suggest a difference in the mean waiting times at the four body shops? Use the .05 significance level.

Test for two independent sample using excel : At the .05 significance level, can we conclude that there is a difference in their mean times?

Case study of steamer furniture company : Steamer Furniture Company operates a "rent-to-own" furniture store in Nashua, NH. Stanley Dino purchased a living room suite (couch, loveseat and chair) on May 18, 2009.

Significance level for number of units produced : At the .05 significance level, is the number of units produced on the afternoon shift larger?

Conclusion on assembly time using the new method : Using the .10 level of significance, can we conclude that the assembly time using the new method is faster?

User Account

All Pages