Business statistics II Family transportation costs include car payments, insuran

Question

Business statistics II

Family transportation costs include car payments, insurance, fuel costs, repairs, parking and public transportation. 5 families were randomly selected in 4 cities and asked to approximate their monthly transportation costs. Results are recorded in the table below. Atlanta New York Los Angeles Chicago $630 $250 $630 $340 480 523 180 450 330 400 530 675 600 275 400 350 673 500 375 400 Use Microsoft Excel to conduct an ANOVA to determine whether there are significant differences in the mean monthly family transportation costs in the 4 cities. Use = 0.05.

State the hypothesis test Ho: 1 = 2 = 3 = 4 = 450 Ho: = 450 Ha: # 450 QUESTION 2 What is your level of significance, the highest probability that you will incorrectly conclude that significant differences exist? QUESTION 3 From your results of the Single Factor ANOVA you conducted in Excel, state the p-value QUESTION 4 From your results of the Single Factor ANOVA you conducted in Excel, state the Fstat (test statistic) QUESTION 5 From your results of the Single Factor ANOVA you conducted in Excel, state the Fcrit (critical value) QUESTION 6 When drawing a conclusion after applying an ANOVA test, if p

Explanation / Answer

Question 1

H0 : 1 = 2 = 3 = 4

Ha : 1 2 ,1 3 , 1 4 , 2 3 , 2 4 , 3 4

OPtion C is correct.

Question 2

Level of significance = 0.05

Question 3

THe ANOVA analysis

p- value = 0.3986

Question 4

Fstat = 1.0476

Question 5

Fcritical = 3.2389

Question 6

if p value is less than alpha than we reject the null hypothesis and can say that difference exists between different population means. Both of the options are correct.

Anova: Single Factor SUMMARY Groups Count Sum Average Variance Atlanta 5 2713 542.6 19263.8 New York 5 1948 389.6 15678.3 Los Angeles 5 2115 423 29045 Chicago 5 2215 443 18745 ANOVA Source of Variation SS df MS F P-value F crit Between Groups 65000.55 3 21666.85 1.047567 0.398554 3.238872 Within Groups 330928.4 16 20683.03 Total 395929 19

Related Questions

Navigate

• Browse (All)
• Browse B
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.