Answered step by step
Verified Expert Solution
Question
1 Approved Answer
1 Customer Type of Customer Items Net Sales Method of Payment Marital Gender Status Age 2 1 Regular 1 39.50 Discover Male Married 32
1 Customer Type of Customer Items Net Sales Method of Payment Marital Gender Status Age 2 1 Regular 1 39.50 Discover Male Married 32 3 2 Promotional 1 102.40 Proprietary Card Female Married 36 4 3 Regular 1 22.50 Proprietary Card Female Married 32 5 4 Promotional 5 100.40 Proprietary Card Female Married 28 6 5 Regular 2 54.00 MasterCard Female Married 34 7 6 Regular 1 44.50 MasterCard Female Married 44 8 7 Promotional 2 78.00 Proprietary Card Female Married 30 9 8 Regular 1 22.50 Visa Female Married 40 10 9 Promotional 2 56.52 Proprietary Card Female Married 46 11 10 Regular 1 44.50 Proprietary Card Female Married 36 12 11 Regular 1 29.50 Proprietary Card Female Married 48 13 12 Promotional 1 31.60 Proprietary Card Female Married 40 19 24 29 156782222222222222232233337 14 13 Promotional 9 160.40 Visa Female Married 40 14 Promotional 2 64.50 Visa Female Married 46 15 Regular 1 49.50 Visa Male Single 24 16 Promotional 2 71.40 Proprietary Card Male Single 36 17 Promotional 3 94.00 Proprietary Card Female Single 22 18 Regular 3 54.50 Discover Female Married 40 20 19 Promotional 2 38.50 MasterCard Female Married 32 20 Promotional 6 44.80 Proprietary Card Female Married 56 21 Promotional 1 31.60 Proprietary Card Female Single 28 22 Promotional 4 70.82 Proprietary Card Female Married 38 23 Promotional 7 266.00 American Express Female Married 50 24 Regular 2 74.00 Proprietary Card Female Married 42 25 Promotional 2 39.50 Visa Male Married 48 26 Promotional 1 30.02 Proprietary Card Female Married 60 27 Regular 1 44.50 Proprietary Card Female Married 54 28 Promotional 5 192.80 Proprietary Card Female Single 42 30 29 Promotional 3 71.20 Proprietary Card Female Married 32 30 Promotional 1 18.00 Proprietary Card Female Married 70 31 Promotional 2 63.20 MasterCard Female Married 28 32 Regular 1 75.00 Proprietary Card Female Married 52 34 33 Promotional 3 63.20 Proprietary Card Female Married 44 34 Regular 1 40.00 Proprietary Card Female Married 34 35 Promotional 5 105.50 MasterCard Female Married 56 36 Regular 1 29.50 MasterCard Male Single 36 37 Regular 2 102.50 Visa Female Single 42 39 40 38 Promotional 6 117.50 Proprietary Card Female Married 50 39 Promotional 5 13.23 Proprietary Card Female Married 44 41 40 Regular 2 52.50 Proprietary Card Female Married 58 42 41 Promotional 13 198.80 Proprietary Card Female Married 42 43 42 Promotional 4 19.50 Visa Female Married 46 44 43 Regular 2 123.50 Proprietary Card Female Married 48 45 44 Promotional 1 62.40 Proprietary Card Female Married 54 46 45 Promotional 2 23.80 Proprietary Card Female Married 38 47 46 Promotional 2 39.60 Proprietary Card Female Married 60 48 47 Regular 1 25.00 MasterCard Female Married 46 49 48 Promotional 3 63.64 Proprietary Card Female Married 30 50 49 Promotional 1 14.82 Proprietary Card Female Married 32 51 50 Promotional 9 145.20 MasterCard Female Married 46 52 51 Promotional 6 176.62 Proprietary Card Female Married 38 53 52 Promotional 5 118.80 Proprietary Card Male Married 68 54 53 Regular 1 58.00 Discover Female Single 78 55 54 Regular 2 74.00 Visa Female Single 20 56 55 Regular 2 49.50 MasterCard Female Married 32 57 56 Promotional 3 141.60 Proprietary Card Female Married 38 58 57 Promotional 6 123.10 Proprietary Card Female Married 54 59 58 Promotional 2 80.40 Proprietary Card Female Married 48 60 59 Promotional 4 65.20 MasterCard Female Married 46 61 60 Promotional 4 113.00 Proprietary Card Female Single 50 62 61 Promotional 1 108.80 Proprietary Card Female Married 46 63 62 Promotional 3 59.91 Proprietary Card Female Single 30 64 63 Promotional 5 53.60 Proprietary Card Female Married 54 65 64 Promotional 1 31.60 Proprietary Card Female Single 42 66 65 Promotional 2 49.50 Proprietary Card Female Married 48 67 66 Promotional 1 39.60 Proprietary Card Female Married 62 68 67 Promotional 2 59.50 Proprietary Card Female Married 34 69 68 Promotional 5 146.80 Proprietary Card Female Married 28 70 69 Promotional 2 47.20 Proprietary Card Male Married 46 71 70 Promotional 8 95.05 Proprietary Card Female Married 54 72 71 Promotional 5 155.32 Proprietary Card Female Married 30 73 72 Promotional 4 58.00 MasterCard Female Married 32 74 73 Regular 1 69.00 Proprietary Card Female Single 22 75 74 Promotional 2 46.50 Proprietary Card Female Married 32 76 75 Promotional 2 45.22 Proprietary Card Female Married 74 77 76 Promotional 4 84.74 Proprietary Card Female Married 62 78 77 Regular 2 39.00 Proprietary Card Female Married 42 79 78 Promotional 4 111.14 Proprietary Card Female Married 28 80 79 Promotional 3 86.80 Proprietary Card Female Married 38 81 80 Regular 2 89.00 Discover Female Married 54 82 81 Promotional 2 78.00 MasterCard Female Married 68 83 82 Promotional 6 53.20 Proprietary Card Female Single 30 84 83 Promotional 4 58.50 Visa Female Married 36 85 84 Promotional 3 46.00 Proprietary Card Female Married 44 86 85 Regular 2 37.50 Visa Female Married 44 87 86 Promotional 1 20.80 Proprietary Card Female Married 62 88 87 Regular 6 144.00 MasterCard Female Single 48 89 88 Regular 4 107.00 Proprietary Card Female Married 36 90 89 Promotional 1 31.60 Proprietary Card Female Single 20 91 92 90 Promotional 6 57.60 Proprietary Card Female Married 42 93 94 95 96 97 98 99 100 101 R 91 Promotional 4 95.20 Proprietary Card Female Married 54 92 Promotional 1 22.42 Proprietary Card Female Married 54 93 Regular 5 159.75 Proprietary Card Female Married 72 94 Promotional 17 229.50 Proprietary Card Female Married 30 95 Regular 3 66.00 American Express Female Married 46 96 Regular 1 39.50 MasterCard Female Married 44 97 Promotional 9 253.00 Proprietary Card Female Married 30 98 Promotional 10 287.59 Proprietary Card Female Married 52 99 Promotional 2 47.60 Proprietary Card Female Married 30 100 Promotional 1 28.44 Proprietary Card Female Married 44 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 Ch.2-Case study 1: Pelican Stores Pelican Stores, a division of National Clothing, is a chain of women's apparel stores operating throughout the country. The chain recently ran a promotion in which discount coupons were sent to customers of other National Clothing Stores. Data collected for a sample of 100 in-store credit card transactions at Pelican Stores during one day while the promotion was running are contained in the file named "Case Study Ch2-PelicanStores". When reviewing the data, note that the "proprietary card" method of payment refers to charges made using a National Clothing charge card. Customers who made a purchase using a discount coupon are referred to as "promotional" customers; and customers who made a purchase but did not use a discount coupon are referred to as "regular" customers. Because the promotional coupons were not sent to regular Pelican Stores customers, management considers the sales made to people presenting the promotional coupons as sales it would not otherwise make. Of course, Pelican also hopes that the promotional customers will continue to shop at its stores. The following variables are shown in the data file: Customer: is an auto-numbering field to count the number of customers in the study (this is not used in the analysis). Type of Customer: is a customer that either is a regular shopper (regular) or came to the store specifically because of the promotion being held (Promotional). Items: refers to the total number of items purchased. Net Sales: refers to the total amounts ($) charged to one of the credit cards. Method of Payment: refers to a Discover Card, Visa Card, MasterCard, or the Proprietary Card, which is essentially the store's credit card (e.g., Macy's, JC Penny, Kohls, etc.) Gender: Male or Female Marital Status: Married or Single Age: Age of the customer Managerial Report Use the tabular and graphical methods of descriptive statistics to help management develop a customer profile and to evaluate the promotional campaign. Your report should include the following: 1. Percent frequency distribution for the key variables (Type of Customer, Items, Net Sales, Method of Payment, Gender. Marital Status, Age) 2. A bar chart showing the number of customer purchases attributable to the method of payment. 3. A histogram for Net sales. 4. Interpret the results and report the managerial insights. Chs.3 and 4-Case study 2: Pelican Stores Consider the Pelican Stores case problem presented in Ch. 2. Use the methods of numerical descriptive statistics to summarize the data and comment on your findings. At a minimum, your report should include the following: 1. Descriptive statistics on net sales for all customers. 2. Descriptive statistics on net sales by various classification of customers (Married/Single and Regular/Promotional). 1. Percent Frequency Distribution Type of Customers Promotional Regular Items Percentage Frequency 70% 70 30% 30 Item Frequency Percentage 2 3 5 29% 27% 10% 10% 9% 6 7 7% 7 1 1% 00 8 1 1% 9 3 35 10 1 1% 13 1 1% 17 1 1% Net Sales Frequency Distribution Table Class Count 10-49.99 39 50-89.99 32 90-129.99 15 7 130-169.99 170-209.99 210-249.99 250-289.99 Total Method of Payment Percentage 39 32 15 7313 313 100 100 Method American Express Discover Frequency 2 Percentage 2% 4% MasterCard 14 14% Proprietary Card 70 70% Visa 10 Total 100 10% 100% Marital Status Marital Status Married Single Age Frequency Percentage 84 84% 16 16% Frequency Distribution Table Class Count Percentage 20-32 26 26 33-45 32 32 46-58 31 31 59-71 8 8 72-84 3 3 Total 100 100 2. METHOD OF PURCHASING Number of Customers Per Purchasing Method Visa Proprietary Card MasterCard Discover American Express 0 10 20 30 40 50 60 70 80 NUMBER OF CUSTOMERS 40 44 WA 50 CUSTOMERS 20 10 10 30 0 30 Net Sales Series1 12 8 2 2 (55.23, 97.23] (139.23, 181.23] (223.23, 265.23] [13.23, 55.23] (97.23, 139.23] (181.23, 223.23] NET SALES 2 (265.23, 307.23] Net Sales Descriptive Statistics Result Net Sales Mean Standard Error Median Mode Standard Deviation Sample Variance Kurtosis Skewness Range Minimum Maximum Sum Count 77.6005 5.566493843 59.705 31.6 55.66493843 3098.58537 3.149955028 1.714996093 274.36 13.23 287.59 7760.05 100 Net Sales of Married Mean Standard Error Median Mode Standard Deviation Sample Variance Kurtosis Skewness Range Minimum Maximum Sum Count 77.6005 5.566493843 59.705 31.6 55.66493843 3098.58537 3.149955028 1.714996093 274.36 13.23 287.59 7760.05 100 Net Sales of Single Mean Standard Error Median Mode Standard Deviation Sample Variance Kurtosis Skewness Range Minimum Maximum Sum Count 75.350625 11.29347361 64.455 31.6 45.17389445 2040.68074 1.827875387 1.354238075 163.3 29.5 192.8 1205.61 16 Net Sales of Promotional Mean Standard Error Median Mode Standard Deviation Sample Variance Kurtosis Skewness Range Minimum Maximum Sum Count 84.29 7.34614957 63.42 31.6 61.46229694 3777.613945 2.135932152 1.519903094 274.36 13.23 287.59 5900.3 70 70 Net Sales of Regular Mean Standard Error Median Mode Standard Deviation Sample Variance Kurtosis Skewness Range Minimum Maximum Sum Count 84.29 7.34614957 63.42 31.6 61.46229694 3777.613945 2.135932152 1.519903094 274.36 13.23 287.59 5900.3 70
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