An online retail company is trying to predict customer spending in the first three months of the year. Brian Duffy, the marketing analyst of the company, has compiled a data set on 200 existing customers that includes sex (Female: 1 = Female, 0 otherwise), annual income in 1,000s (Income), age (Age, in years), and total spending in the first three months of the year (Spending). A portion of the E-Retailer_Data worksheet is shown in the accompanying table. Create a regression tree model for predicting customer spending during the first three months of the year (Spending). Select the best-pruned tree for scoring and display the full-grown, best-pruned, and minimum error trees.

a. Display the best-pruned tree. How many leaf nodes are in the best-pruned tree? 

b. What are the RMSE and MAD of the best-pruned tree on the test data? 

c. Score the 10 new customers in the E-Retailer_Score worksheet using the best-pruned tree. What are the mean and median values of the predicted spending amounts according to your model?

Transcribed Image Text:

Female Income 0 87.5 1 66.5 ⠀ ⠀ 0 51.9 Age 52 43 B 61 Spending 156.88 275.16 ⠀ 159.51