Question: I need this solved on excel please. Data from the U.S. Shopper Database provided the following percentages for women shopping at each of the various

I need this solved on excel please.

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 Kohls, 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.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!