SAS dataset HeinzHunts has data on grocery store purchases of Hunts and Heinz ketchup. Each observation corresponds to one purchase occasion.

INSTRUCTIONS TO CANDIDATES

ANSWER ALL QUESTIONS

Homework 4

The SAS dataset HeinzHunts has data on grocery store purchases of Hunts and Heinz ketchup. Each observation corresponds to one purchase occasion (of one of these brands) and consists of the following variables:

1. Heinz : =1 if Heinz was purchased, =0 if Hunts was purchased
2. PriceHeinz : Price of Heinz
3. PriceHunts : Price of Hunts
4. DisplHeinz : = 1 if Heinz had a store display, =0 if Heinz did not have a store display
5. DisplHunts : = 1 if Hunts had a store display, =0 if Hunts did not have a store display
6. FeatureHeinz : = 1 if Heinz had a store feature, =0 if Heinz did not have a store feature
7. FeatureHunts : = 1 if Hunts had a store feature, =0 if Hunts did not have a store feature

 

1. Create a variable LogPriceRatio = log (PriceHeinz/PriceHunts).

 

2. Randomly select 80% of the data set as the training sample, remaining 20% as test sample

 

3. Estimate a logit probability model for the probability that Heinz is purchased – using LogPriceRatio, DisplHeinz, FeatureHeinz, DisplHunts, FeatureHunts as the explanatory variables. Include interaction terms between display and feature for a particular brand (e.g., DisplHeinz * FeatureHeinz).

 

4. Interpret the results. What promotional methods (feature / display) are effective for Hunts? For Heinz? How would you interpret the results for the interaction effects?

 

5. Based on the estimated model, and using the logit probability formula, calculate the change in predicted probability that Heinz is purchased if LogPriceRatio changes from 0.5 to 0.6 and Heinz does not use a feature or display, while Hunts uses a feature and a display.

 

Recall that in the logit model:  , where Y is the outcome variable, X are the predictor variables, and  are the estimated model coefficients.

 

6. The estimated model is to be used for targeting customers for Hunts coupons to build loyalty for the brand. Coupons are to be sent to customers who are likely to buy Hunts, and not to customers who are likely to buy Heinz. Therefore, the coupons should be sent to customers whose predicted probability of buying Heinz is below a certain threshold level that needs to be determined based on the costs of misclassifications (incorrectly sending / not sending a coupon)

 

The following information about the costs of incorrect classification is available: The cost of incorrectly sending a coupon to a customer who would have bought Heinz is $1 per customer, and the cost of incorrectly failing to send a coupon to a customer who would have bought Hunts is $0.25 per customer.

Based on these costs, what is the optimal threshold probability level that should be used with the estimated model to decide which consumers should receive coupons.

(HINT: Step 1: Using the appropriate SAS command, create an ROC table for the test data from the estimated model. The ROC table provides the number of false positive and false negative classifications for each possible probability threshold.

Step 2: Using the cost information, calculate the total cost of misclassification for each probability threshold.

Total Cost = # of False Positives * False Positive Cost + # of False Negatives * False Negative Cost

Think carefully as to what is false positive and negative in this context.

Step 3: Choose the probability threshold that leads to the lowest total cost.)

 

Related Questions

. The fundamental operations of create, read, update, and delete (CRUD) in either Python or Java

CS 340 Milestone One Guidelines and Rubric  Overview: For this assignment, you will implement the fundamental operations of create, read, update,

. Develop a program to emulate a purchase transaction at a retail store. This  program will have two classes, a LineItem class and a Transaction class

Retail Transaction Programming Project  Project Requirements:  Develop a program to emulate a purchase transaction at a retail store. This

. The following program contains five errors. Identify the errors and fix them

7COM1028   Secure Systems Programming   Referral Coursework: Secure

. Accepts the following from a user: Item Name Item Quantity Item Price Allows the user to create a file to store the sales receipt contents

Create a GUI program that:Accepts the following from a user:Item NameItem QuantityItem PriceAllows the user to create a file to store the sales receip

. The final project will encompass developing a web service using a software stack and implementing an industry-standard interface. Regardless of whether you choose to pursue application development goals as a pure developer or as a software engineer

CS 340 Final Project Guidelines and Rubric  Overview The final project will encompass developing a web service using a software stack and impleme