The Portable Music Player

In this project, using the excel file – portablemusic.xlsx, we need to analyze the reviews on Portable Music Player. There are two text columns that you will analyze – “Q1: what do you like most about this portable music player?” and “Q2: what do you like least about this portable music player?”

The task is to create a product strategy (i.e., how to improve a product) and a marketing strategy (i.e., how to market a product) for the company that sells these portable music products. Your primary variables of interest are the two text columns (i.e., B and C) that contain feedback of customers. You should treat the other variables (i.e., columns D-H) as your predictor variables.

To create the product and marketing strategy, you need to answer the following questions:

Marketing Strategy

• Which profile (i.e., age, gender, music, activity) of customers are happy?
• Which profile (i.e., age, gender, music, activity) of customers are unhappy?

Product Strategy
​

• How the general feedback differs for the various products?
• What are the specific complaints about each of the products?

Data

portablemusic.xlsx
File Size:	41 kb
File Type:	xlsx

Download File

---