Homework Help is Here – Start Your Trial Now!
Math
Statistics
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 PelicanStores. Table 3.13 shows a portion of the data set. 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. Pelican’s management would like to use this sample data to learn about its customer base and to evaluate the promotion involving discount coupons.

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 PelicanStores. Table 3.13 shows a portion of the data set. 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. Pelican’s management would like to use this sample data to learn about its customer base and to evaluate the promotion involving discount coupons.

MATLAB: An Introduction with Applications
MATLAB: An Introduction with Applications
6th Edition
ISBN:9781119256830
Author:Amos Gilat
Publisher:Amos Gilat
Chapter1: Starting With Matlab
Section: Chapter Questions
Problem 1P
See similar textbooks
icon
Related questions
Question

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 PelicanStores. Table 3.13 shows a portion of the data set.

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. Pelican’s management would like to use this sample data to learn about its customer base and to evaluate the promotion involving discount coupons.

 

Managerial Report

Use the tabular and graphical methods of descriptive statistics to help management develop a customer profile and to evaluate the promotional campaign. At a minimum, your report should include the following:

 

  1. Percent frequency distributionsfor each of the key variables: number of items purchased, net sales, method of payment, gender, marital status, and age. (20%)
  2. A sorted bar chartshowing the number of customer purchases attributable to the method of payment. (15%)
  3. A crosstabulationof type of customer (regular or promotional) versus net sales. Comment on any similarities of differences observed. (15%)
  4. A scatter chartto explore the relationship between net sales and customer age. (15%)
  5. A chart (i.e., scatter chartwith trendline) to examine whether the relationship between net sales and age depends on the marital status of the customer. (20%)
  6. A side-by-side bar chartto examine the method of payment by customer type (regular or promotional). Comment on any differences you observe between the methods of payments used by the different types of customers. (15%)
ustome Type ethod of Customer Regular Items Net Sales Рауment Gender Status Age 19.50 Discover 102.40 Proprietary Card Female 22. 50 Proprietary Card Female 100.40 Proprietary Card Female 2 Male Мarried 32 Promotiona 1 Married 36 4 Regular Married 32 4 Promotional Married 28 6. Married Regular Regular Promotiona Regular 54.00 MasterCard Female 34 6 44.50 MasterCard Female Married 44 78.00 Proprietary Card Female Married 30 9 22.50 Visa Female Married 40 56.52 Proprietary Card Female 44.50 Proprietary Card Female 29.50 Proprietary Card Female 31.60 Proprietary Card Female 10 Promotional Married 46 Regular Regular 10 Мarricd 36 12 13 11 Married 48 12 Promotional Married 40 14 13 Promotional 160.40 Visa Female Married 40 Promotiona Regular 15 14 64.50 Visa Female Мarricd 46 16 15 49.50 Visa Single Single Single Male 24 16 Promotional 2 71.40 Proprietary Card Male 94.00 Proprietary Card Female Female 36 18 17 Promotional 22 19 20 21 22 18 Regular 54.50 Discover Мarricd 40 19 Promotional 2 3850 MasterCard Female Married 32 20 Promotional 61 44.80 Proprietary Card Female 31.60 Proprietary Card Female Single 70.82 Proprietary Card Female 266.00 American Exprer Female 74.00 Proprietary Card Female Мarricd 56 21 Promotiona 28 23 22 Promotional Married 18 24 25 23 Promotional Мarricd 50 24 Regular Promotiona 2 Мarricd 42 26 25 2 39.50 Visa Male Married 48 27 28 29 26 Promotional 1 30.02 Proprietary Card Female 44.50 Proprietary Card Female 192.80 Proprietary Card Female 71.20 Proprietary Card Female 18.00 Proprietary Card Female Married 60 27 Regular Promotiona Мarricd 54 28 Single 42 29 Promotiona Married 32 31 30 Promotional Married 70 32 33 31 Promotional 63.20 MasterCard Female Married 28 32 Regular Promotiona Regular 1 75.00 Proprietary Card Female 63.20 Proprietary Card Female Мarricd 52 34 33 Мarricd 44 35 36 37 38 34 40.00 Proprietary Card Female Married 34 35 Promotional 105.50 MasterCard Female Мarricd 56 36 Regular Regular 29.50 MasterCard Male Single Female Single 36 37 2 102.50 Visa 42 39 38 Promotional 117.50 Proprietary Card Female 13.23 Proprietary Card Female 52.50 Proprietary Card Female 198.80 Proprietary Card Female Мarricd 50 40 39 Promotiona Married 44 41 40 Regular 2 Married 58 Married 42 43 41 Promotional 13 42 Promotiona Regular 42 19.50 Visa Female Мarricd 46 123.50 Proprietary Card Female 62.40 Proprietary Card Female 23.80 Proprietary Card Female 39.60 Proprietary Card Female Female 44 43 2 Married 48 45 46 47 48 44 Promotional Married 54 45 Promotiona 2 Married 38 46 Promotional Married 60 47 Regular 25.00 MasterCard Married 46 49 48 Promotional 3 63.64 Proprietary Card Female 14.82 Proprietary Card Female 145 20 MasterCard 176.62 Proprietary Card Female 118.80 Proprietary Card Male 58.00 Discover Married 30 50 51 49 Promotional 1 Мarried 32 50 Promotiona Female Married 46 52 51 Promotiona Маrricd 38 53 52 Promotional Мarried 68 54 53 Regular Regular Regular Female Single Female Single 78 55 56 54 74.00 Visa 20 55 2 49.50 MasterCard Female Мarried 32
Transcribed Image Text:ustome Type ethod of Customer Regular Items Net Sales Рауment Gender Status Age 19.50 Discover 102.40 Proprietary Card Female 22. 50 Proprietary Card Female 100.40 Proprietary Card Female 2 Male Мarried 32 Promotiona 1 Married 36 4 Regular Married 32 4 Promotional Married 28 6. Married Regular Regular Promotiona Regular 54.00 MasterCard Female 34 6 44.50 MasterCard Female Married 44 78.00 Proprietary Card Female Married 30 9 22.50 Visa Female Married 40 56.52 Proprietary Card Female 44.50 Proprietary Card Female 29.50 Proprietary Card Female 31.60 Proprietary Card Female 10 Promotional Married 46 Regular Regular 10 Мarricd 36 12 13 11 Married 48 12 Promotional Married 40 14 13 Promotional 160.40 Visa Female Married 40 Promotiona Regular 15 14 64.50 Visa Female Мarricd 46 16 15 49.50 Visa Single Single Single Male 24 16 Promotional 2 71.40 Proprietary Card Male 94.00 Proprietary Card Female Female 36 18 17 Promotional 22 19 20 21 22 18 Regular 54.50 Discover Мarricd 40 19 Promotional 2 3850 MasterCard Female Married 32 20 Promotional 61 44.80 Proprietary Card Female 31.60 Proprietary Card Female Single 70.82 Proprietary Card Female 266.00 American Exprer Female 74.00 Proprietary Card Female Мarricd 56 21 Promotiona 28 23 22 Promotional Married 18 24 25 23 Promotional Мarricd 50 24 Regular Promotiona 2 Мarricd 42 26 25 2 39.50 Visa Male Married 48 27 28 29 26 Promotional 1 30.02 Proprietary Card Female 44.50 Proprietary Card Female 192.80 Proprietary Card Female 71.20 Proprietary Card Female 18.00 Proprietary Card Female Married 60 27 Regular Promotiona Мarricd 54 28 Single 42 29 Promotiona Married 32 31 30 Promotional Married 70 32 33 31 Promotional 63.20 MasterCard Female Married 28 32 Regular Promotiona Regular 1 75.00 Proprietary Card Female 63.20 Proprietary Card Female Мarricd 52 34 33 Мarricd 44 35 36 37 38 34 40.00 Proprietary Card Female Married 34 35 Promotional 105.50 MasterCard Female Мarricd 56 36 Regular Regular 29.50 MasterCard Male Single Female Single 36 37 2 102.50 Visa 42 39 38 Promotional 117.50 Proprietary Card Female 13.23 Proprietary Card Female 52.50 Proprietary Card Female 198.80 Proprietary Card Female Мarricd 50 40 39 Promotiona Married 44 41 40 Regular 2 Married 58 Married 42 43 41 Promotional 13 42 Promotiona Regular 42 19.50 Visa Female Мarricd 46 123.50 Proprietary Card Female 62.40 Proprietary Card Female 23.80 Proprietary Card Female 39.60 Proprietary Card Female Female 44 43 2 Married 48 45 46 47 48 44 Promotional Married 54 45 Promotiona 2 Married 38 46 Promotional Married 60 47 Regular 25.00 MasterCard Married 46 49 48 Promotional 3 63.64 Proprietary Card Female 14.82 Proprietary Card Female 145 20 MasterCard 176.62 Proprietary Card Female 118.80 Proprietary Card Male 58.00 Discover Married 30 50 51 49 Promotional 1 Мarried 32 50 Promotiona Female Married 46 52 51 Promotiona Маrricd 38 53 52 Promotional Мarried 68 54 53 Regular Regular Regular Female Single Female Single 78 55 56 54 74.00 Visa 20 55 2 49.50 MasterCard Female Мarried 32
56 Promotional 141.60 Proprietary Card Female 123.10 Proprietary Card Female Married 38 57 Promotiona 6 Married 54 80.40 Proprietary Card Female Female 58 Promotional 2 Married 48 50 59 Promotional 4 65.20 MasterCard Married 46 60 Promotional 4 113.00 Proprietary Card Female 108.80 Proprietary Card Female 59.91 Proprietary Card Female 53.60 Proprietary Card Female 31.60 Proprietary Card Female 49 50 Proprietary Card Female 39.60 Proprietary Card Female 59.50 Proprietary Card Female 146.80 Proprietary Card Female 47.20 Proprietary Card Male 95.05 Proprietary Card Female 155 32 Proprietary Card Female Single 50 52 53 54 55 61 Promotional Married 46 62 Promotional Single 30 63 Promotional Married 54 64 Promotional 1 Single 42 56 65 Promotiona 2 Маrried 48 57 66 Promotional Married 62 58 67 Promotional 2 Married 34 59 68 Promotional Мarricd 28 69 Promotional 2 Married 46 70 Promotiona Married 54 2 71 Promotional Married 30 72 Promotional 4 58.00 MasterCard Female Мarricd 32 14 73 Regular 1 69.00 Proprietary Card Female Single 22 46.50 Proprietary Card Female 45.22 Proprietary Card Female 84.74 Proprietary Card Female 39.00 Proprietary Card Female 111.14 Proprietary Card Female 86.80 Proprietary Card Female 74 Promotional 2 Married 32 75 Promotional 2 Married 74 76 Promotional 4 Married 62 Regular 2 Married 42 19 78 Promotional 4 Married 28 79 Promotional 3 Married 38 31 80 Regular 2 89.00 Discover Female Married 54 81 Promotional 2 78.00 MasterCard Female Married 68 82 Promotional 53.20 Proprietary Card Female 58.50 Visa Single 30 34 83 Promotiona 4 Female Married 36 Married 35 36 84 Promotional 46.00 Proprietary Card Female 44 85 Regular Promotional Regular Regular 2 37.50 Visa Female Married 44 86 20.80 Proprietary Card Female Female Married 62 87 6 144.00 MasterCard Single 48 39 107.00 Proprietary Card Female 31.60 Proprietary Card Female 57.60 Proprietary Card Female 95.20 Proprietary Card Female 22.42 Proprietary Card Female 159.75 Proprietary Card Femake 229.50 Proprietary Card Female 66.00 American Expres Female 39.50 MasterCard 253.00 Proprietary Card Female 287.59 Proprietary Card Female 47.60 Proprietary Card Female 28.44 Proprietary Card Female 88 4 Married 36 89 Promotional Single 20 90 Promotional Married 42 91 Promotiona 4 Маrried 54 92 Promotional Married 54 94 93 Regular Promotional Regular Regular Married 72 94 17 Married 30 96 95 Married 46 96 Female Married 44 97 Promotional 9 Married 30 98 Promotional 10 Married 52 00 01 ml 99 Promotional 2 Married 30 100 Promotional Married 44
Transcribed Image Text:56 Promotional 141.60 Proprietary Card Female 123.10 Proprietary Card Female Married 38 57 Promotiona 6 Married 54 80.40 Proprietary Card Female Female 58 Promotional 2 Married 48 50 59 Promotional 4 65.20 MasterCard Married 46 60 Promotional 4 113.00 Proprietary Card Female 108.80 Proprietary Card Female 59.91 Proprietary Card Female 53.60 Proprietary Card Female 31.60 Proprietary Card Female 49 50 Proprietary Card Female 39.60 Proprietary Card Female 59.50 Proprietary Card Female 146.80 Proprietary Card Female 47.20 Proprietary Card Male 95.05 Proprietary Card Female 155 32 Proprietary Card Female Single 50 52 53 54 55 61 Promotional Married 46 62 Promotional Single 30 63 Promotional Married 54 64 Promotional 1 Single 42 56 65 Promotiona 2 Маrried 48 57 66 Promotional Married 62 58 67 Promotional 2 Married 34 59 68 Promotional Мarricd 28 69 Promotional 2 Married 46 70 Promotiona Married 54 2 71 Promotional Married 30 72 Promotional 4 58.00 MasterCard Female Мarricd 32 14 73 Regular 1 69.00 Proprietary Card Female Single 22 46.50 Proprietary Card Female 45.22 Proprietary Card Female 84.74 Proprietary Card Female 39.00 Proprietary Card Female 111.14 Proprietary Card Female 86.80 Proprietary Card Female 74 Promotional 2 Married 32 75 Promotional 2 Married 74 76 Promotional 4 Married 62 Regular 2 Married 42 19 78 Promotional 4 Married 28 79 Promotional 3 Married 38 31 80 Regular 2 89.00 Discover Female Married 54 81 Promotional 2 78.00 MasterCard Female Married 68 82 Promotional 53.20 Proprietary Card Female 58.50 Visa Single 30 34 83 Promotiona 4 Female Married 36 Married 35 36 84 Promotional 46.00 Proprietary Card Female 44 85 Regular Promotional Regular Regular 2 37.50 Visa Female Married 44 86 20.80 Proprietary Card Female Female Married 62 87 6 144.00 MasterCard Single 48 39 107.00 Proprietary Card Female 31.60 Proprietary Card Female 57.60 Proprietary Card Female 95.20 Proprietary Card Female 22.42 Proprietary Card Female 159.75 Proprietary Card Femake 229.50 Proprietary Card Female 66.00 American Expres Female 39.50 MasterCard 253.00 Proprietary Card Female 287.59 Proprietary Card Female 47.60 Proprietary Card Female 28.44 Proprietary Card Female 88 4 Married 36 89 Promotional Single 20 90 Promotional Married 42 91 Promotiona 4 Маrried 54 92 Promotional Married 54 94 93 Regular Promotional Regular Regular Married 72 94 17 Married 30 96 95 Married 46 96 Female Married 44 97 Promotional 9 Married 30 98 Promotional 10 Married 52 00 01 ml 99 Promotional 2 Married 30 100 Promotional Married 44
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 5 steps with 2 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Follow-up Questions
Read through expert solutions to related follow-up questions below.
Follow-up Question

Evaluate the different types of visual representations which can be used to communicate the findings.

Solution
Bartleby Expert
SEE SOLUTION
Knowledge Booster
Point Estimation, Limit Theorems, Approximations, and Bounds
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, statistics and related others by exploring similar questions and additional content below.
Similar questions
Recommended textbooks for you
MATLAB: An Introduction with Applications
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
Statistics for The Behavioral Sciences (MindTap C…
Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
Elementary Statistics: Picturing the World (7th E…
Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON
The Basic Practice of Statistics
The Basic Practice of Statistics
Statistics
ISBN:
9781319042578
Author:
David S. Moore, William I. Notz, Michael A. Fligner
Publisher:
W. H. Freeman
Introduction to the Practice of Statistics
Introduction to the Practice of Statistics
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman
SEE MORE TEXTBOOKS