# hw 7 segmentation analysis the tables in the attached file show a cross tabulation of frequent flier mileage categories high med low by age category younger older please see following for details

HW 7 – Segmentation Analysis

The tables in the attached file show a cross-tabulation of frequent -flier mileage categories (high, med, low) by Age-category (younger, older). A travel offer was made to 5000 people in the analytic sample

â€¢Table 1 shows the counts of the 5000 people in the analytic sample.

â€¢Table 2 shows the counts as a percentage of the 5000 people in the analytic sample

â€¢Table 3 shows the number of orders placed for the travel offer.

â€¢Table 4 shows the response rate for the travel offer

HW:

1.Create a new table showing indexes of observed response rates, relative to the overall rate. Then based on the index table you created, create 3 segments labeled as follows (if nec., refer to textbook chapter 7, and slides from week 3, for a refresher on Indexes)

2.Segments: Yes (index >= 120), Maybe (index between 100-120), No (index <=100)

3.If the entire customer file is 100,000 customers, how many customers are there in each of the â€œYesâ€, â€œMaybeâ€, and â€œNoâ€ categories?

4.What might be the observed response rate for the â€œYesâ€ segment that you want to market to?

5.Past marketing efforts (before this new segmentation) showed an overall response rate of 5.24%. If new offers are to be sent and targeted to the â€œYesâ€ segment, what is the expected response rate for the â€œYesâ€ segment? And what is the response rate index?

6. How many orders to the travel offer would you expect?

Attached excel is the file of cross-tabulation of frequent -flier mileage categories. Attached slides(week8) is the related contents weekly slides. Please see the slides first and then do the chart for the highest accurate.

##### Looking for a Similar Assignment? Our Experts can help. Use the coupon code SAVE30 to get your first order at 30% off!

Hi there! Click one of our representatives below and we will get back to you as soon as possible.

Chat with us on WhatsApp