Create a new table showing indexes of observed response rate

Assignment Help Marketing Management

Reference no: EM132571717

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

Question 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)

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

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

Question 4. What might be the observed response rate for the "Yes" segment that you want to market to?

Question 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?

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

Attachment:- travel expert.zip

Reference no: EM132571717

Questions Cloud

What exactly does convenience mean : How important is the privacy of your personal information to you? Why? Will this motivate you to stay away from using social media?

A 0.3 kg ball moving in the positive x-axis direction at 20 : A 0.3 Kg ball moving in the positive x-axis direction at 20 m/s is hit by a bat. Its final velocity is 25 m/s in the negative x-axis direction. The bat acts on the ball for 0.02 seconds. Find the average force F exerted on the ball by the bat.

What is the process of developing a bayesian networks model : What is the relationship between Naïve Bayes and Bayesian networks? What is the process of developing a Bayesian networks model?

Describe the organizational culture : How would you describe the organizational culture of a previous or current place of employment? And why?

Create a new table showing indexes of observed response rate : If the entire customer file is 100,000 customers, how many customers are there in each of the "Yes", "Maybe", and "No" categories?

Craft strategy and execute strategy : Incorporating information from our coursework, do features of Salesforce.com culture influence its ability to craft strategy and execute strategy?

What are some concerns faced by group : Use your company (or a company or organization you've worked with) to provide an example that corresponds with each of the organizational stakeholders.

Analyze leadership and management roles in change management : Analyze leadership and management roles in change management. Identify and research two leadership strategies. Develop description of the leadership strategies.

What is a peer-reviewed and academic reference : What is a peer-reviewed, academic reference and why is this necessary? How can you avoid plagiarism when you are using academic references?

User Account

All Pages