Data from the U. Shopper Database provided the following percentages for women shopping at each of the various outlets.

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. 

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. 

Use excel Please