MKTG462_AA1_Questions
docx
keyboard_arrow_up
School
Portland State University *
*We aren’t endorsed by this school
Course
462
Subject
Industrial Engineering
Date
Apr 3, 2024
Type
docx
Pages
4
Uploaded by DrTapirMaster523
NAMES:__James Nguyen
_________________________
AA1 - MKTG462: PCs Unlimited Example - (100 points)
DIRECTIONS:
Using the data in the PCs_Unlimited.xlsx Excel file posted on D2L, answer the questions below. First, calculate the answer in a NEW tab (Q1, Q2, Q3…etc.), and THEN Copy/Paste the output for each question (e.g. a histogram, table etc.) into the space below. Turn in this document AND the Excel file showing your work on D2L. You may work on this with another student, but BOTH names must be on
this document AND your Excel file showing your work. Each student must turn in their own copies.
1.
(5pts) What percentage
of female (gender=1) vs. male customers responded
to the latest
offering from PCsUnlimited?
27% men and 73% women responded to the latest offering from PCsUnlimited.
2.
(5pts) Create a histogram
showing the distribution of customer ages
.
20
25
30
35
40
45
50
55
60
65
More
0
50
100
150
200
250
300
350
400
450
500
0
5
37
263
433
230
23
7
1
1
0
Histogram
Frequency
Bin Values (Age)
Frequency
3.
(10pts) Determine how many customers are from each region
. Then create a bar chart showing the number of customers in each region
.
There was a total of 227 customers in region 1, 167 customers in region 2, 81 customers in region 3, 263 customers in region 4, 98 customers in region 5, and 164 customers in region 6.
NAMES:__James Nguyen
_________________________
1
2
3
4
5
6
0
50
100
150
200
250
300
227
167
81
263
98
164
Customer Frequency by Region
Regions
Frequency
4.
(10pts) What is the A) total dollar spent by all customers B) the average dollar
spent
per customer, C) the largest (max)
and D) smallest (min)
amounts spent by any customer? Repeat for number of purchases
.
Total Dollar Spent = $335,229
Average Dollar Spent = $335.229
Min. = $50
Max. = $8,763
Total Number of Purchases = 1,822
Average Number of Purchases = 1.822
Min. = 1
Max = 15
5.
(10pts) Compute the correlation
between total dollar spent and number of purchases
.
The correlation between total dollar spent and number of purchases was 0.86.
6.
(10pts) How do male vs. female (gender=1) customers compare in terms of total number of purchases
?
From the total number of purchases of 1,822. Men had 496 purchases and women had 1,326 purchases.
7.
(10pts) Graph (X,Y plot)
the relationship between total dollar spent and the total number of purchases
.
NAMES:__James Nguyen
_________________________
0
2
4
6
8
10
12
14
16
0
1000
2000
3000
4000
5000
6000
7000
8000
9000
10000
Total Purchases and Total Dollar Spent
Total Purchases
Total Dollar Spent
8.
(10pts) Compute the average purchase dollar amount
. Now, divide
your customers into two groups
: one-time purchases and repeat customers (more than once). What’s the average spend of each group?
9.
(10pts) Calculate the quintile values of total dollars spent
.
Q1 Value = $57.00
Q2 Value = $67.00
Q3 Value = $98.40
Q4 Value = $277.80
10.
(10pts) Calculate total dollar spent and the total number of purchases only for those customers who live in the Northeast (region=1)
.
Customers who live in the Northeast spent a total of $86,427 and had a total number of purchases of 449.
11.
(10pts) Create a table to answer the following: What is A) the number
and B) percent
of customers in each region. Additionally, show the C) total dollar spent
, D) total number of purchases
, E) average dollar spent
, and F) percent
of overall total dollar spent by customers in each region
.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
NAMES:__James Nguyen
_________________________