Question

Cardio Good Fitness Case StudyCardio Good Fitness Case Study-1.xlsx download
The market research team at AdRight is assigned the task to identify the profile of the typical customer for each treadmill product offered by CardioGood Fitness. The market research team decides to investigate whether there are differences across the product lines with respect to customer characteristics. The team decides to collect data on individuals who purchased a treadmill at a CardioGoodFitness retail store during the prior three months. The data are stored in the "Data" worksheet.
CardioGood Fitness is a developer of cardiovascular exercise equipment. Its product line includes these treadmill models and prices:
· TM195: $1500
· TM498: $1750
· TM798: $2500
CardioGood Fitness has a goal to increase sales of treadmills. They have hired your company as advertising consultants to identify the target markets that are most likely to buy more treadmills. Once these markets are identified targeted advertising will be used to generate product interest and increase consumer preference for CardioGood Fitness treadmills over other brands.
The TM195 is an entry-level treadmill. It has the least number of programs and features between the models. It is most suitable for customers who prefer less programming and more simplicity in their treadmill.
The TM498 shares the same structural housing as the TM195 but offers two built-in training programs and up to 15% elevation grade.
The TM798 is structurally larger and heavier than the other models. The model features an LCD backlit console, quick speed and incline keys, wireless heart rate monitor, remote speed control, and a graphical human anatomical figure to measure your gait and identify your minimally and maximally used muscles. This model features a non-folding platform, designed to handle frequent, rigorous usage. This helps to distinguish it from other models.
Goal:
To identify any customer profiles that may exist for a particular product. This information will be used to match customers with advertisements. This strategy is meant to optimize advertising costs across products. Think about it in terms of what relationships exist within consumers and products, and how might the features of the products be exploited in a way to increase sales.
Data:
Product = Product purchased
Age = Age of customers
Gender
Education = Years of education
MaritalStatus
Usage = Average expected product weekly usage count
Fitness = Self-score fitness sacle 1=least fit, 5=most fit
Income = Annual income
Miles = Average number of miles expected to walk weekly
1. Which variables are categorical?
2. Which variables are numerical?
3. Which variables are discrete?
4. Begin creating a customer profile for each product line by developing a descriptive statistics table per profile.
Descriptive Statistics, TM195
Descriptors
Mean
Median
Mode
Range
Variance
Standard Deviation
Coefficient of Variation
Interquartile Range
Outlier
Kurtosis
Skewness Shape
Descriptive Statistics, TM498
Descriptors
Mean
Median
Mode
Range
Variance
Standard Deviation
Coefficient of Variation
Interquartile Range
Outlier
Kurtosis
Skewness Shape
Descriptive Statistics, TM798
Descriptors
Mean
Median
Mode
Range
Variance
Standard Deviation
Coefficient of Variation
Interquartile Range
Outlier
Kurtosis
Skewness Shape
5. What can you interpret about each product line’s average customer?
Visualize:
6. Construct scatter plots visualizing the relationships discovered through your descriptive statistics table: education versus income, age versus education, expected miles versus usage
7. Construct any bar charts, line graphs, or polygons that support your views. Which ones help to develop your viewpoint the best. Remember the purpose is to define a market to create a targeted advertising scheme for.
8. Construct two-way contingency tables of gender, education, relationship status, and self-fit reporting.
9. Compute all conditional and marginal probabilities from the tables developed.
10. Which types of customers have the highest probability of purchases across products?
11. Does this match with descriptive statistics from your original profiles?
Deliverable:
Write a report to be presented to the management team of CardioGoodFitness detailing your findings of customer profiles/product. What types of profiles should be targeted to optimally advertise? Please submit your Excel working.

Answer 1

Answer:

please submit your excle working