# 1st Individual Homework

Topics: Gender, Male, Female Pages: 5 (609 words) Published: February 13, 2015
﻿Homework One Xin Weng B# 00481171
1. What percent of BookBinders customers are female?
66.6% of customers are female.
Gender

Frequency
Percent
Valid Percent
Cumulative Percent
Valid
Female
33302
66.6
66.6
66.6

Male
16698
33.4
33.4
100.0

Total
50000
100.0
100.0

2. Which three states account for the largest percentage of BookBinders’s customers? New Jersey, New York and Pennsylvania are the three largest states. State

Frequency
Percent
Valid Percent
Cumulative Percent
Valid
APO (Military)
5
.0
.0
.0

Connecticut
2512
5.0
5.0
5.0

District of Columbia
339
.7
.7
5.7

Delaware
711
1.4
1.4
7.1

Massachusetts
4252
8.5
8.5
15.6

Maryland
4172
8.3
8.3
24.0

Maine
343
.7
.7
24.7

New Hampshire
665
1.3
1.3
26.0

New Jersey
11068
22.1
22.1
48.1

New York
16530
33.1
33.1
81.2

Pennsylvania
8718
17.4
17.4
98.6

Rhode Island
402
.8
.8
99.4

Virginia
27
.1
.1
99.5

Virgin Islands
45
.1
.1
99.6

Vermont
211
.4
.4
100.0

Total
50000
100.0
100.0

3. What is the average Total \$ spent, the average Total # of purchases, and the average number of months since last purchase? The average Total \$ spent is 208.32, the average Total # of purchases is 3.89 and the average number of months since last purchase is 12.36. Descriptive Statistics

N
Mean
Total \$ spent
50000
208.3183
Months since last purchase
50000
12.36
Total # purchases
50000
3.890
Valid N (listwise)
50000

4. Is there a significant correlation between customers’ total spending on books and their total spending on non-book products? There is no significant correlation between customers’ total spending on books and their total spending on non-book products.

Correlations

Total \$ spent on books
Total \$ spent on non-book products
Total \$ spent on books
Pearson Correlation
1
.157**

Sig. (2-tailed)

.000

N
50000
50000
Total \$ spent on non-book products
Pearson Correlation
.157**
1

Sig. (2-tailed)
.000

N
50000
50000
**. Correlation is significant at the 0.01 level (2-tailed).

5. Which book categories have sold the most books? Which have sold the least? By comparing their means, we can tell the cookbook category has sold the most books and the reference category has sold the least books.

Descriptive Statistics

N
Mean
# purchases, Children's books
50000
.85
# purchases, Youth books
50000
.39
# purchases, Cookbooks
50000
.94
# purchases, Do-it-yourself books
50000
.46
# purchases, Reference books
50000
.31
# purchases, Art books
50000
.39
# purchases, Geography books
50000
.55
Valid N (listwise)
50000

6. Create a bar chart showing the average total spending on books for males and females.

7. For both males and females, find the total number and also the percent who bought “The Art History of Florence.”

Gender * Bought "Art History of Florence?" Crosstabulation

Bought "Art History of Florence?"
Total

No
Yes

Gender
Female
Count
30913
2389
33302

% within Bought "Art History of Florence?"
68.0%
52.8%
66.6%

Male
Count
14565
2133
16698

% within Bought "Art History of Florence?"
32.0%
47.2%
33.4%
Total
Count
45478
4522
50000

% within Bought "Art History of Florence?"
100.0%
100.0%
100.0%

9. Determine the minimum, the maximum, and the average number of months between customers’ first purchase and their most recent purchase.

Descriptive Statistics

N
Minimum
Maximum
Mean
F_L
50000
0
72
13.31
Valid N (listwise)
50000

10. What percent of repeat customers (those with two or more total purchases) bought “The Art History of Florence?”

10.3% of the repeat customer bought “The Art History of Florence”.

Bought "Art History of Florence?" * F_L > 0 (FILTER) Crosstabulation

F_L > 0 (FILTER)
Total

Selected

Bought "Art History of Florence?"
No...