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 on coursehero.com
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
.
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