CONSOLIDATED FOODS, INC.

Consolidated Foods, Inc., operates a chain of supermarkets in New Mexico, Arizona, and California. Data showing the dollar amounts and method of payment were collected for a sample of 100 customers(see fileConsolid). Consolidated's managers requested the sample be taken to learn about payment practices of the store's customers. In particular, managers are interested in learning about how a new credit card payment option is related to the customers' purchase amounts.

Managerial Report

Use the methods of descriptive statistics to summarize the sample data. Provide summaries of the dollar purchase amounts for cash customers. personal check customers, and credit card customers separately. Your report should contain the following summaries and discussions.

1. A comparison and interpretation of means and medians.

2. A comparison and interpretation of measures of variability such as the range and standard deviation.

3. The identification and interpretation of the five-number summaries for each method of payment.

Use the summary section of your report to provide a discussion of what you have learned about the method of payment and the amounts of payments for Consolidated Foods customers.

l VinaPhone 6 09:16 85% Consolid.xls ... Data Sheet2 Sheet3 Sheet4 SH Method of Customer Amount ($) Payment 1 28,58 Check 2 52,04 Check 3 7,41 Cash 4 11,17 Cash 5 43,79 Credit Card 6 48,95 Check 7 57,59 Check 8 27.60 Check 9 26,91 Credit Card 10 9,00 Cash 11 12.07 Cash 12 54,19 Credit Card 13 58,11 Check 14 58,64 Check 15 7,22 Cash 16 16,69 Cash 17 48,11 Credit Card 18 58,75 Check 19 25,57 Credit Card 20 42.69 Check 21 14,28 Cash 22 16,28 Cash 23 11,77 Cash 24 15.07 Cash 25 36,48 Check 26 31,07 Check 27 18.77 Check 28 57,55 Credit Card 29 4,34 Cash 30 30,60 Check 31 55,40 Check 32 35,38 Check 33 7,02 Cash 34 27,66 Credit Card 35 44,53 Credit Card 36 40,51 Check 37 1,09 Cash 38 59.78 Check All VinaPhone 09:17 85% k ... 39 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 SO 51 S2 S3 54 33 56 37 58 39 60 61 62 63 64 65 66 67 68 69 70 71 72 Consolid.xls 9,6 CTC 44.53 Credit Card 40,51 Check 1.09 Cash 59.78 Check 21.11 Check 2.87 Cash 52.87 Check 55.21 Credit Card 20,48 Cash 19.78 Credit Card 8,81 Cash 2.67 Check 16,38 Cash 46,24 Credit Card 72,46 Check 31.74 Check 33,76 Credit Card 14,44 Credit Card 4.75 Cash 22.59 Credit Card 11.34 Cash 2.44 Cash 52,35 Credit Card 26,57 Credit Card 15.10 Cash 7,40 Cash 13.09 Cash 35,89 Check 15,37 Cash 1.27 Cash 52.63 Credit Card 41,58 Check 5.98 Cash 46,13 Credit Card 2.96 Cash 5.91 Cash 17.87 Check 1.85 Cash 49.21 Check 69,22 Check 34,67 Check S.1S Cash ANS 74 75 76 All VinaPhone 09:17 85% Consolid.xls ... 39 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 32 78 79 0 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 15.10 Cash 7.40 Cash 13.09 Cash 35,89 Check 15,59 Cash 1.27 Cash 32.63 Credit Card 41,58 Check 5.98 Cash 46,13 Credit Card 2,96 Cash 5.91 Cash 17,87 Check 1.85 Cash 49.21 Check 69,22 Check 34,67 Check S.IS Cash 51.66 Check 36.09 Check 53,32 Credit Card 8,85 Cash 7.17 Cash 39.55 Check 42.83 Check 3.65 Cash 50,58 Check 25,96 Check 5,08 Cash 30.30 Credit Card 78,16 Check 37,94 Check 27.89 Credit Card 37,20 Check 7.88 Cash 6,93 Cash 18.09 Cash 34.84 Check 41.10 Check 43.14 Check 3.31 Cash 69.77 Credit Card