Individual Assignment 4 Name: UID: Please import the data file: assign4.xlsx into
Individual Assignment 4
Name: UID:
Please import the data file: assign4.xlsx into your SPSS and answer the following questions (attach calculation processes at the back of the assignment). The data is a panel data where we summarize the consumer purchase history in 2017 and first two quarters of 2018. The following table summarize all the variables:
Please clean the dataset before analyzing (don’t need to report)!
Please predict the consumer retention rate (the probability of stay active) across the 4 consumer segments in the 3rd and 4th quarter of 2018, using the classification tree model, and report your results in the table below:
Hints: 1) independent variables to use: year, quarter, member, cum_interaction, age, seg, ipo, gender; dependent variable: active; 2) to predict, create a new dataset including of two observations for each user, one is for 3rd quarter and the other is for 4th quarter of 2018 (already created in sheet “test” of assign4.xlsx); 3) take average of the predicted retention rate within the segment.
Segment 0
Segment 1
Segment 2
Segment 3
2018, 3rd
2018, 4th
Predict the overall profits (sum the profits in online and offline channels) across the 4 segments in 3rd and 4th quarter of 2018 using OLS and moderation analysis, and report your predicted results in the following table:
Hints: 1) calculate the overall profits for each consumer in each quarter; 2) exclude observations where consumers are inactive; 3) regress the overall profits on: year, quarter, member, cum_interaction, age, seg, ipo, gender, the interaction terms between segments and year, and the interaction terms between segments and quarter; 4) predict results using test dataset in sheet “test” and calculate the average profits across the 4 segments.
Segment 0
Segment 1
Segment 2
Segment 3
2018, 3rd
2018, 4th
Assume that the acquisition cost per customer for segment 0 is $50, segment 1 is $100, segment 2 is $70, and segment 3 is $90; the depreciation rate is 3% per quarter, please calculate the cumulative customer value of the 4 segments (remember to multiple the number of active customers in the segment) in the 3rd and 4th quarter of 2018, report your results in the following table:
Segment 0
Segment 1
Segment 2
Segment 3
2018, 3rd
2018, 4th
Paste your screenshots and other calculation process here, please write notes appropriately: