1. Data from the U.S. Shopper Database provided the following percentages for wo

Question

1.      Data from the U.S. Shopper Database provided the following percentages for women shopping at each of the various outlets. The other category included outlets such as Target, Kmart, and Sears as well as numerous smaller specialty outlets. No individual outlet in this group accounted for more than 5% of the women shoppers.

Outlet

Percentage

Other

35

Wal-Mart

25

Department Stores

10

Mail Order

15

Kohl's

10

J.C. Penney

5

A recent survey using a sample of 200 women shoppers in Tampa, FL found 60 Wal-Mart, 29 traditional department store, 11 JC Penney, 14 Kohl’s, 30 mail order, and 56 other outlet shoppers. Does this sample suggest that women shoppers in Tampa differ from the preferences expressed in the U.S. Shopper Data-base? What is your conclusion based on both the p-value and critical-value approaches? Use = .01.

Please tell me exactly what to write in Excel to get these answers and if there are any formulas that could be used. Thanks

Outlet

Percentage

Other

35

Wal-Mart

25

Department Stores

10

Mail Order

15

Kohl's

10

J.C. Penney

5

Explanation / Answer

here applying chi square test of goodness of fit :

here test stat X2 =10.75

and degree of freedom =number of categories -1 =6-1 =5

for above test stat and 5 degree of freedom ; p value =0.0566

as p value is greater then 0.01 level we can not reject null hypothesis,

( Note from excel: you can directly calculate p value by chitest command; but for that you need to caclulate expected E =200* percentage of corresponding outlet) . use =chitest(array of observed value ; array of expected values) and you will get p value.)

please revert for further clarifcation

observed Expected Chi square Type Probability O E=total*p =(O-E)^2/E Other 0.350 56.000 70.00 2.80 Wal-Mart 0.250 60.000 50.00 2.00 Department Stores 0.100 29.000 20.00 4.05 Mail Order 0.150 30.000 30.00 0.00 Kohl's 0.100 14.000 20.00 1.80 J.C. Penney 0.050 11.000 10.00 0.10 1 200 200 10.7500

Related Questions

Navigate

• Browse (All)
• Browse 1
• Subjects

---

---

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