Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

Analysis of Variance Using the information within the chart at this link, comple

ID: 3329963 • Letter: A

Question

Analysis of Variance

Using the information within the chart at this link, complete the following, https://www.chegg.com/homework-help/questions-and-answers/large-metropolitan-police-force-considering-changing-full-size-cars-mid-size-cars-police-f-q1090514?trackid=507133eb&strackid=004e2b71&ii=1

Similar to problem 11.10 in the text, based on section 11.2 of the text. A large metropolitan police force is considering changing from full-size cars to intermediates. The police force sampled cars from each of three manufacturers. Each car was driven 5,000 miles, and the operating cost per mile computed. The operating cost, in cents per mile, for the 21 cars is presented below. Perform an analysis of variance on these data using a significance level of 0.05.

Report the:
a. Critical value
b. Test statistic
c. Your decision
d. Conclusion

H0: The population means are equal.

H1: The population means are not all equal.

Total Sum of Squares: SST =

SSB =

Complete the ANOVA Table:

ANOVA Table

Source of Variation

Sum of Squares

df

MS

F

Between Groups

Within Groups

Total

20

Using the charts in this picture provided by the link, complete the following: https://www.chegg.com/homework-help/questions-and-answers/similar-problem-117-text-based-section-112-text-individual-owns-3-automobile-dealerships-i-q19667440?trackid=1ddaa225&strackid=71c681d8&ii=1

Similar to problem 11.7 in the text, based on section 11.2 of the text. An individual owns 3 automobile dealerships and is interested in determining whether average daily sales for the 3 dealerships are the same. A random selection of daily sales at the 3 dealerships is presented in the table below.

State the appropriate null and alternative hypotheses for this analysis.

What is the between-column (explained) variance?

Report the Mean Square Error (MSE) for this ANOVA?

What is the value of the test-statistic for the test specified above?

What are the degrees of freedom for the hypothesis that average sales for each dealership are equal?

a. 2 for numerator, 9 for denominator

b. 9 for numerator, 2 for denominator

c. 2 for numerator, 11 for denominator

d. 11 for numerator, 9 for denominator

In testing the hypothesis that average sales for each dealership are equal, the appropriate conclusion to be drawn would be:

a. reject H0 at the 10% significance level.

b. the test is significant at the 88% level.

c. the test is not significant at the 5% level.

d. cannot reject the null hypothesis at the 10% level.

e. accept the null hypothesis at the 88% level.

What is the critical value for this test if the decision maker is willing to take a 10% chance of error?

In one sentence, make a statement to interpret the results of this analysis.

ANOVA Table

Source of Variation

Sum of Squares

df

MS

F

Between Groups

Within Groups

Total

20

Explanation / Answer

Enter the data into Excel.
Go to Data tab -> Click on Data Analysis tool pack -> Choose Anova : Single factor -> Click ok.
Select the data in the input range -> Tick labels -> Click ok.

Anova: Single Factor

SUMMARY

Groups

Count

Sum

Average

Variance

CAR1

8

111

13.875

0.382143

CAR2

5

64.8

12.96

0.163

CAR3

7

105.1

15.01429

0.388095

ANOVA

Source of Variation

SS

df

MS

F

P-value

F crit

Between Groups

12.69393

2

6.346964

19.07825

4.52E-05

3.591531

Within Groups

5.655571

17

0.332681

Total

18.3495

19

a.Critical value : 3.591531

b.Test statistic : 19.07825

c.Decision : Reject the null hypothesis since test statistic > critical value.

d.Conclusion : the average operating costs per mile for the 3 types of police cars are significantly different.

SST = 18.3495
SSB = 12.69393

Anova table is given above.

Anova: Single Factor

SUMMARY

Groups

Count

Sum

Average

Variance

CAR1

8

111

13.875

0.382143

CAR2

5

64.8

12.96

0.163

CAR3

7

105.1

15.01429

0.388095

ANOVA

Source of Variation

SS

df

MS

F

P-value

F crit

Between Groups

12.69393

2

6.346964

19.07825

4.52E-05

3.591531

Within Groups

5.655571

17

0.332681

Total

18.3495

19

Hire Me For All Your Tutoring Needs
Integrity-first tutoring: clear explanations, guidance, and feedback.
Drop an Email at
drjack9650@gmail.com
Chat Now And Get Quote