Statistics - Regression Projects

Pelican Stores, a chain of women's apparel stores operating throughout the country, recently ran a promotion

Pelican Stores, a chain of women's apparel stores operating throughout the country, recently ran a promotion in which discount coupons were sent to customers of related stores. Data collected for a sample of 100 in-store credit card transactions during one day in November 2002 are contained in the file named Pelican. Table 1 shows the data set. A nonzero amount for the Discount variable indicates that the customer brought in the promotional coupons and used them. For a few customers, the discount amount is greater than the sales amount (see customer 4). The sales amount is net of returns.

Customer Method of Payment Items Discount Sales Gender Marital Status Age
1 Discover 1 0.00 39.50 Male Married 32
2 Proprietary Card 1 25.60 102.40 Female Married 36
3 Proprietary Card 1 0.00 22.50 Female Married 32
4 Proprietary Card 5 121.10 100.40 Female Married 28
5 Mastercard 2 0.00 54.00 Female Married 34
6 Mastercard 1 0.00 44.50 Female Married 44
7 Proprietary Card 2 19.50 78.00 Female Married 30
8 Visa 1 0.00 22.50 Female Married 40
9 Proprietary Card 2 22.48 56.52 Female Married 46
10 Proprietary Card 1 0.00 44.50 Female Married 36
11 Proprietary Card 1 0.00 29.50 Female Married 48
12 Proprietary Card 1 7.90 31.60 Female Married 40
13 Visa 9 103.60 160.40 Female Married 40
14 Visa 2 24.50 64.50 Female Married 46
15 Visa 1 0.00 49.50 Male Single 24
16 Proprietary Card 2 12.60 71.40 Male Single 36
17 Proprietary Card 3 53.00 94.00 Female Single 22
18 Discover 3 0.00 54.50 Female Married 40
19 Mastercard 2 19.00 38.50 Female Married 32
20 Proprietary Card 6 32.20 44.80 Female Married 56
21 Proprietary Card 1 7.90 31.60 Female Single 28
22 Proprietary Card 4 29.67 70.82 Female Married 38
23 American Express 7 66.50 266.00 Female Married 50
24 Proprietary Card 2 0.00 74.00 Female Married 42
25 Visa 2 14.50 39.50 Male Married 48
26 Proprietary Card 1 9.48 30.02 Female Married 60
27 Proprietary Card 1 0.00 44.50 Female Married 54
28 Proprietary Card 5 48.20 192.80 Female Single 42
29 Proprietary Card 3 37.30 71.20 Female Married 32
30 Proprietary Card 1 4.50 18.00 Female Married 70
31 Mastercard 2 15.80 63.20 Female Married 28
32 Proprietary Card 1 0.00 75.00 Female Married 52
33 Proprietary Card 3 15.80 63.20 Female Married 44
34 Proprietary Card 1 0.00 40.00 Female Married 34
35 Mastercard 5 10.00 105.50 Female Married 56
36 Mastercard 1 0.00 29.50 Male Single 36
37 Visa 2 0.00 102.50 Female Single 42
38 Proprietary Card 6 14.50 117.50 Female Married 50
39 Proprietary Card 5 25.02 13.23 Female Married 44
40 Proprietary Card 2 0.00 52.50 Female Married 58
41 Proprietary Card 13 62.70 198.80 Female Married 42
42 Visa 4 16.50 19.50 Female Married 46
43 Proprietary Card 2 0.00 123.50 Female Married 48
44 Proprietary Card 1 15.60 62.40 Female Married 54
45 Proprietary Card 2 35.20 23.80 Female Married 38
46 Proprietary Card 2 19.40 39.60 Female Married 60
47 Mastercard 1 0.00 25.00 Female Married 46
48 Proprietary Card 3 20.11 63.64 Female Married 30
49 Proprietary Card 1 4.68 14.82 Female Married 32
50 Mastercard 9 94.30 145.20 Female Married 46
51 Proprietary Card 6 58.88 176.62 Female Married 38
52 Proprietary Card 5 51.70 118.80 Male Married 68
53 Discover 1 0.00 58.00 Female Single 78
54 Visa 2 0.00 74.00 Female Single 20
55 Mastercard 2 0.00 49.50 Female Married 32
56 Proprietary Card 3 35.40 141.60 Female Married 38
57 Proprietary Card 6 56.40 123.10 Female Married 54
58 Proprietary Card 2 20.10 80.40 Female Married 48
59 Mastercard 4 28.30 65.20 Female Married 46
60 Proprietary Card 4 19.50 113.00 Female Single 50
61 Proprietary Card 1 19.20 108.80 Female Married 46
62 Proprietary Card 3 91.48 59.91 Female Single 30
63 Proprietary Card 5 37.40 53.60 Female Married 54
64 Proprietary Card 1 7.90 31.60 Female Single 42
65 Proprietary Card 2 9.50 49.50 Female Married 48
66 Proprietary Card 1 9.90 39.60 Female Married 62
67 Proprietary Card 2 29.50 59.50 Female Married 34
68 Proprietary Card 5 36.70 146.80 Female Married 28
69 Proprietary Card 2 11.80 47.20 Male Married 46
70 Proprietary Card 8 18.95 95.05 Female Married 54
71 Proprietary Card 5 57.18 155.32 Female Married 30
72 Mastercard 4 10.00 58.00 Female Married 32
73 Proprietary Card 1 0.00 69.00 Female Single 22
74 Proprietary Card 2 15.50 46.50 Female Married 32
75 Proprietary Card 2 14.28 45.22 Female Married 74
76 Proprietary Card 4 46.26 84.74 Female Married 62
77 Proprietary Card 2 0.00 39.00 Female Married 42
78 Proprietary Card 4 35.11 111.14 Female Married 28
79 Proprietary Card 3 31.20 86.80 Female Married 38
80 Discover 2 0.00 89.00 Female Married 54
81 Mastercard 2 19.50 78.00 Female Married 68
82 Proprietary Card 6 29.31 53.20 Female Single 30
83 Visa 4 14.50 58.50 Female Married 36
84 Proprietary Card 3 19.50 46.00 Female Married 44
85 Visa 2 0.00 37.50 Female Married 44
86 Proprietary Card 1 5.20 20.80 Female Married 62
87 Mastercard 6 0.00 144.00 Female Single 48
88 Proprietary Card 4 0.00 107.00 Female Married 36
89 Proprietary Card 1 7.90 31.60 Female Single 20
90 Proprietary Card 6 46.40 57.60 Female Married 42
91 Proprietary Card 4 158.30 95.20 Female Married 54
92 Proprietary Card 1 7.08 22.42 Female Married 54
93 Proprietary Card 5 0.00 159.75 Female Married 72
94 Proprietary Card 17 33.00 229.50 Female Married 30
95 American Express 3 0.00 66.00 Female Married 46
96 Mastercard 1 0.00 39.50 Female Married 44
97 Proprietary Card 9 82.75 253.00 Female Married 30
98 Proprietary Card 10 18.00 287.59 Female Married 52
99 Proprietary Card 2 31.40 47.60 Female Married 30
100 Proprietary Card 1 11.06 28.44 Female Married 44

Pelican’s management wants to use this sample data to learn about its customer base and to evaluate the promotion involving discount coupons.

Question set A:

  1. What is the average age of the customers?
  2. What is the average age of the married customers?
  3. What is the average age of the single customers?
  4. What are the percentages of female and male customers?
  5. Compare the average sales of single customers to married customers.

Question set B:

  1. Develop a frequency distribution table for the Method of Payment.
  2. Develop a relative frequency distribution (percent frequency distribution) table for the Method of Payment.
  1. Construct a bar graph
  2. Construct a pie chart
  3. On the basis of this sample, which method of payment has the largest percent of customers.

Question set C (you can use MINITAB or by hand tallies)

  1. Develop a Stem and Leaf display of the variable "Age".
  2. How many customers are there between age 20 and 29?
  3. Develop a frequency distribution of ages using 6 classes starting from 20-29, 30-39, 40-49 and so on .
  4. Develop a relative frequency distribution of ages using 6 classes starting from 20-29, 30-39, 40-49 and so on.
  5. Develop a percent frequency distribution of ages using 6 classes starting from 20-29, 30-39, 40-49 and so on.
  6. Construct a cumulative frequency distribution table for the ages of the customers using 6 classes starting from 12-29, 30-30 and so on.
  7. Develop a frequency histogram table of ages using 6 classes starting from 20-29, 30-39, 40-49 and so on.

Question set D:

  1. Provide a cross tabulation of Gender and Marital status.
  2. Compute the row percentages for your cross tabulation Table
  3. Show the frequency distribution for gender and marital status.
  4. Comment on the relationship between Gender and Marital status.

Question E:

Compute the mean, median,25 th percentile, 75 th percentile, variance and standard deviation, range, coefficient of variation and compute the box plot of the variables Age, and sales.

Price: $21.89
Solution: The downloadable solution consists of 15 pages, 689 words and 12 charts.
Deliverable: Word Document



∴ Other downloads you may be interested in ∴

log in to your account

Forgot password?
Don't have a membership account?
REGISTER

reset password

Back to
log in

sign up

Back to
log in