stratascratch
  • Interview Questions
    • Interview Loops
    • Analytical
    • Algorithm
    • ML Coding
    • Stats Coding
    • Visualization
    • Concept
  • Data Labs
    • Discover
    • Your Notebooks
  • Mock Interview
  • Learn
  • Blog
  • Pricing
  • About
Log in
  • Interview Questions

    • Interview Loops
    • Analytical
    • Algorithm
    • ML Coding
    • Stats Coding
    • Visualization
    • Concept
  • Data Labs

    • Discover
    • Your Notebooks
  • Mock Interview
  • Learn
  • Blog
  • Pricing
  • About
Log inSign up
Back to Projects
  1. Assignment
  2. Your Solution
  3. Solution
  4. Solutions from Users
  5. Discussion

Treadmill Buyer Profile

You must be logged in to download the datasets

Best Buy: Match customers to ideal treadmills using probabilistic segmentation. Python, Pandas, Seaborn, Matplotlib.

Assignment

The market research team at Best Buy wants to identify the characteristics of the target audience for each type of treadmill offered by the company, to provide a better recommendation of the treadmills to new customers. The team decides to investigate whether there are differences across the product with respect to customer characteristics.

Perform descriptive analytics to create a customer profile for each Best Buy treadmill product by developing appropriate tables and charts. For each Best Buy treadmill product, construct two-way contingency tables and compute all conditional and marginal probabilities along with their insights/impact on the business.

Product Portfolio:

  • The KP281 is an entry-level treadmill that sells for $1,500;
  • The KP481 is for mid-level runners and sells for $1,750;
  • The KP781 treadmill is having advanced features and it sells for $2,500.

Data Description

The company collected data on individuals who purchased a treadmill from Best Buy stores during the prior three months. The dataset in aerofit_treadmill_data.csv has the following features:

  • Product - product purchased: KP281, KP481, or KP781
  • Age - in years
  • Gender - male/female
  • Education - in years
  • MaritalStatus - single or partnered
  • Usage - the average number of times the customer plans to use the treadmill each week
  • Fitness - self-rated fitness on a 1-5 scale, where 1 is the poor shape and 5 is the excellent shape
  • Income - annual income in US dollars
  • Miles - the average number of miles the customer expects to walk/run each week

Practicalities

Analyze the provided data and provide insights to the best of your abilities. Include the relevant tables/graphs/visualization to explain what you have learned about the market. Make sure that the solution reflects your entire thought process including the preparation of data - it is more important how the code is structured rather than just the final result or plot.

This question is part of an interview loop

See the full interview round by round, with questions for each stage.

E-commerce & retail · Analytics Engineer