4h) Expected Spending = Correction Factor*Predicted Spending 0361*500 records in dataset = 18.07 => 18'h record Predicted Spending = 5540750156 Expected Spending = (0.1065)*($407.50156) Expected Spending = $43.40 Gross Profit From Data Mining = (Probability of Purchase)*(Curnulative Lift of 18'h record)*(# of catalogs mailed)*(Average Consumer Spending) 2*(# of catalogs mailed) Gross Profit From Data Mining = (0.053)* (5.449566)*(180,000)*($103) - (2* 180,000) Gross Profit From Data Mining = $4,994,852.54 Refer to TestDataScored tab - row 19 for data used for the Cumulative Lift of 18 \"1 record