Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Segmentation Exercise: This exercise builds directly off the Product Optimization Exercise we just did. The exercise calls for follow up work to characterize the segments.

Segmentation Exercise:
This exercise builds directly off the Product Optimization Exercise we just did. The exercise
calls for follow up work to characterize the segments. For this exercise, apart from the files
from the Product Optimization Exercise, we need demographics data, which are provided in
this file: demographics-full.xlsx. The demographics variable are: income (in thousands of
dollars per year), age (in years), sports (=1 if the person is sports active, 0 if not), gradschl
(=1, if the person has a master's degree or beyond, 0 if not).
If you did the Product Optimization Exercise correctly you have a file similar to this
one: mugs-analysis-full-incl-demographics.xlsx. You are given data on the preference parameters of 311 consumers in this file: mugs-
preference-parameters-full.xlsx. This is the same input file used in the Product Optimization
Exercise.
Your tasks for Part (A):
1. Compute and report the characteristics of the affinity-based segment for Product 3
(our candidate as given above). Report the characteristics in terms of the following
descriptors: IPr, Iin, ICp, ICl, ICn, IBr, I*pPr30, I*pPr10, I*pPr05, I*pIn0.5, I*pIn1,
I*pIn3, I*pCp12, I*pCp20, I*pCp32, I*pClD, I*pClF, I*pClE, I*pCnSl, I*pCnSp,
I*pCnLk, I*pBrA, I*pBrB, I*pBrC, and the demographics income, age, sports and
gradschl. For this you need to compute the weighted average of all the columns in the
"for-cluster-analysis" worksheet, weighted by the probabilities given in column BF of
the "mugs-full" worksheet. You should not do this in Excel directly. You are to load
the data into python or R and compute the weighted averages in R or python; this is to
help you build familiarity with these languages and prepare you better for your job.

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

Databases Demystified

Authors: Andrew Oppel

1st Edition

0072253649, 9780072253641

More Books

Students also viewed these Databases questions

Question

What does it mean to buy the market?

Answered: 1 week ago

Question

How we can improve our listening skills?

Answered: 1 week ago

Question

How do artifacts affect interaction between members of the team?

Answered: 1 week ago