Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

You are a marketing manager at an athlete clothing/gear company. You are up for promotion (good job!) and your task is to develop a to

You are a marketing manager at an athlete clothing/gear company. You are up for promotion (good job!) and your task is to develop a to suggest pricing strategy for the "Accelerator" product based on 'Amount Spent' by customers. Your marketing department has access to historical customer data who purchased similar products (athlete clothing/gear) and has developed customer records to learn what makes some customers spend more than others. The data set includes n = 1000 customers and the following variables: Age (of customer; old/middle/young); Gender (male/female); OwnHome (whether customer owns home; yes/no); Married (single/married); Location (far/close; in terms of distance to the nearest brick and mortar store that sells similar products); Salary (yearly salary of customer; in dollars); Children (number of children; 03); History (of previous purchase volume; low/medium/high/NA; NA means that this customer has not yet purchased); orders placed; and AmountSpent (in dollars). The aim is to develop a pricing strategy for the "Accelerator" product to support the executive summary you developed several weeks ago. Objectives and learning outcomes of this project: 1. To get exposed real world data 2. To be able to interpret statistical results and to draw actionable insights useful for company 3. Enhance the story-telling skills with data 4. Practice communication and presentation skills 5. Improve visualization skills - telling the story with data, statistical analysis, and insights Prepare a PowerPoint for an executive review (no more than 5 slides, you may include an appendix) covering the following: I Visualizations Please note, below is only a suggested guideline to help you start (use as thought starters), you do not need to do them all and you are free to make other visualizations as well. 1. What factors seem to influence Amount Spent? 2. Correlation between AmountSpent and Salary or Number of Children. 3. Do you see a difference in purchase behavior of married vs single customers? 4. Do you see a difference in purchase behavior of male vs female customers? 5. Do you see a difference in purchase behavior of people who have a history of purchasing with this customer? Please ensure you make at least three appropriate visualizations, properly labelled, and telling a story. II Regression and Statistical tests All of the below MUST be include in your presentation, you are free to include anything else. 1. Make a hypothesis of any variable with respect to amount spent. Please explain your null and alternate hypothesis in the presentation. 2. Perform test of means around location of customer and amount spent. 3. Interpret your results and recommend actionable insights. 4. Regression output of amount spent on relevant variables. In other words what factors influence amount spent by different customers. 5. Interpretation of coefficients of your regression output.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered 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

Students also viewed these Accounting questions