appropriately for each PivotTable. •Create a PivotChart for each PivotTable you just created to describe the fractionof customers along each dimension (Age, Gender, and Genre). Be sure to add the appropriate title for each chart, appropriate data labels, legend, and axis labels (if applicable). [NOTE: You should have 3 PivotCharts] Choose the Chart Type that you think best illustrates the fractionof customers along each dimension. •In your report, describe the fraction of customers in each dimension in words. Be sure to include your PivotCharts as a reference. Customer segment comparison (30 points) •Create a new worksheet called “PivotTable-Segments” and position it to the right of “PivotTable-Dimensions.” Using PivotTables based on the customer data (all 10,000 customers), analyze separatelyhow each of the following two focused customer segments responded to the December 2009 promotion compared to November 2009 both in terms of the average number of songs purchased per customer and the average revenue per customer (be sure to examine Offers A, B, and C in November and December 2009): •Segment 1: Female customers who prefer Alternative music •Segment 2: Customers under 14 who prefer Hip-Hop/Rap music [NOTE: You may create a separate worksheet for each segment if you’d like – just name the worksheets appropriately (e.g. “PivotTable-Segment 1”)] Be sure to label each table appropriately as you did in the “PivotTable-Dimensions” tables. •Include an analysis in your report of how the average number of songs purchased as well as the average revenue per customer varied across those customers in each focused segment that were made Offer A, Offer B and Offer C respectively. Perform this comparison for each of the two focused segments. Assess and describe whether the offers were profitable in each focused segment, and also whether Offer B worked better than Offer C. I suggest you summarize this information in a chart for each of the focused segments. For instance, the following chart summarizes how the average revenue per customer varied across those customers who were made Offer A, Offer B and Offer C within Segment 1 [NOTE: Be sure to include value labels in your charts if you choose to use them – they are excluded below for obvious reasons]:
ISM 3011, Spring 2010, Section 014 Excel Project 8 Based on your analysis, decide which of the two offers (if any) that gTunes should make to customers in each of these focused segments in the future, and explain your recommendations.
You've reached the end of your free preview.
Want to read all 8 pages?
- Fall '09
- Revenue, gTunes