1st Individual Homework

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