Return to the original test data partition. Note that this test data partition includes both purchasers and nonpurchasers. Create a new data frame called Score Analysis that contains the test data portion of this dataset.

a. Add a column to the data frame with the predicted scores from the logistic regression.

b. Add another column with the predicted spending amount from the prediction model chosen.

c. Add a column for “adjusted probability of purchase” by multiplying

“predicted probability of purchase” by 0.107. This is to adjust for oversampling the purchasers (see earlier description).

d. Add a column for expected spending: adjusted probability of purchase

× predicted spending.