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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started