Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I.) You are given data on a sample of 20C! customers of Apollo, a (fictional) direct marketing company, for the current year. The variables are

image text in transcribed
image text in transcribed
I.) You are given data on a sample of 20C! customers of Apollo, a (fictional) direct marketing company, for the current year. The variables are dened as follows: Person I a code for the customer Age = a code for the age category, 1 = 30 or younger, 2 = if 31 to 55, 3 if 56 or older Gender : 1 if male, 0 if female Own Home = 1 if customer owns home, I] if renting Married 2 1 if married, [1 if not Close = 1 if lives close to stores (with similar merchandise), 0 if not Salary 2 annual household salary in 33 Children = number of children living with this customer Catalogs = number of catalogs this customer was sent this year (6, 12, 13 or 24) Region = region in the US where the customer lives State = state where the customer lives Amount Spent = Amount spent total on purchases this year (a) Create a PivotTable with rows = Gender, columns = Salary, and values = average of amount spent. In addition, group the Salary values in increments of 2U,UUD, i.e., the column Labels should be: (ll19999, ZDDDDSSSSS, etc. (b) Overall, does the average amount spent increase or decrease with the salaly? Is the trend the same for both male and female? {c} Create another PivotTable, this time with rows = Region, columns = Close, and values = average of amount spent. (d) From either PivotTable, determine the average amount customers spend. (You should get the same answer from either table.) From (c), answer (e) and (f). {e} Customers in which region tend to spend the most? (f) Who spends more at Apollo? The people who live close to stores with similar merchandise or the people who don't? {g} Now make 2 copies of this Pivot Table. Filter the new Pivot Tables such that one contains only the homeowners' data and the other contains only the nonhomeowners' data. (b) On the average, do the homeowners spend more or less than non-homeowners}I Support your answer with numbers

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Business Intelligence

Authors: Efraim Turban, Ramesh Sharda, ...more

2nd Edition

013610066X, 9780136100669

More Books

Students also viewed these General Management questions

Question

Wear as little as possible

Answered: 1 week ago

Question

Be relaxed at the hips

Answered: 1 week ago