Question
Q5. Next, we want to examine whether it will be worthwhile to send the Email_25 or Email_Taxi to the top two segments in the 1001
Q5. Next, we want to examine whether it will be worthwhile to send the Email_25 or Email_Taxi to the top two segments in the 1001 customers you analyzed in Q4. You will need to estimate the predicted acquisition probabilities if you send either of the two emails by using your model (you already know the mean value for the welcome email from your answer in Q4a). (p sure this is the calculations for the welcome email but need to double check it) You need to do this calculation in Excel. For the calculations, you will need a mean value for all the demographic variables used in your Q1D model for each of your two segments. For the two top segments from your analysis in Q4, calculate the mean values for all the variables in your final model using SPSS (see notes in the pre-discussion PPT). Then develop an EXCEL sheet to answer the following questions (use my sample excel sheet below for format as well as the calculations shown in the Pre-discussion PPTs). Using the average values of the relevant variables (viz. only of the ones in your model), please estimate the average probability of acquisition for each segment, for