Question: The file RFMdata - dataFileForAssignment#3.xlsx Download RFMdata - dataFileForAssignment#3.xlsx contains the following data: Whether a person responded (dependent variable = 1) or did not respond

The file RFMdata - dataFileForAssignment#3.xlsxDownload RFMdata - dataFileForAssignment#3.xlsx contains the following data:

Whether a person responded (dependent variable = 1) or did not respond (dependent variable = 0) to the most recent direct mail campaign.

R: recency (time since last purchase) measured on a 1-5 scale; 5 indicates a recent purchase.

F: frequency (how many orders placed in the last year) measured on a 1-5 scale with a 5 indicating many recent purchases.

M: monetary value (total amount purchased in last year) measured on a 1-5 scale with a 5 indicating the person spent a lot of money in the last year on purchases.

Use this data to build a model to predict based on R, F, and M whether a person will respond to a mailing.

Note:- If the installed add ins (Real statistics and/or RegressIT) for some reason stop working, you need to install them again.

Here is the data.

R F M Respond
4 2 1 1
2 5 5 0
2 4 5 0
1 5 5 1
5 5 1 1
1 2 1 0
5 1 4 1
5 5 4 0
4 2 1 0
3 4 3 0
4 1 4 0
1 2 1 0
2 3 2 1
2 1 1 0
2 4 3 1
1 1 2 0
5 1 3 0
1 1 5 0
1 4 4 0
5 5 3 0
1 5 5 0
4 5 3 0
5 4 2 1
3 4 4 0
3 2 4 0
5 1 5 1
2 4 1 1
3 1 2 0
4 5 4 0
5 5 2 0
2 5 3 0
2 2 2 0
5 4 3 0
5 1 4 0
5 4 4 1
2 3 2 0
2 2 1 0
5 4 1 0
2 4 3 0
5 5 2 0
4 1 3 0
2 5 2 0
3 2 1 0
2 1 3 0
2 5 5 0
4 3 3 0
5 1 3 1
5 3 2 0
4 2 4 0
1 2 5 0
2 5 3 0
3 2 5 0
5 2 5 0
1 3 4 0
4 1 5 0
5 2 2 0
5 5 3 0
5 3 2 0
5 5 3 0
5 1 4 0
3 3 5 0
2 1 5 0
3 3 1 1
5 1 2 0
3 1 2 0
1 5 4 0
3 4 1 0
5 4 2 0
5 3 5 0
1 2 4 0
3 2 5 0
3 5 4 0
4 5 5 1
5 4 5 0
1 1 4 0
5 4 2 1
5 3 4 0
1 4 3 0
4 4 3 0
3 5 1 0
2 1 4 0
5 3 5 1
3 1 5 0
3 5 5 0
4 5 3 0
4 1 1 0
4 4 1 0
3 4 5 1
4 1 3 0
2 5 2 0
2 3 5 0
3 4 4 0
5 2 1 0
5 4 2 0
5 2 5 1
1 1 4 1
4 1 1 0
4 2 3 0
1 4 1 0
3 1 4 0
3 4 1 0
5 2 4 0
4 3 2 1
5 1 3 0
5 5 5 0
2 4 3 0
4 2 4 0
1 3 4 0
5 5 4 0
5 5 4 0
1 1 4 0
3 4 3 0
1 3 4 0
5 3 2 0
3 1 1 1
5 2 4 0
4 3 5 1
1 1 5 0
5 5 5 0
5 1 1 0
4 1 3 0
5 5 1 1
4 3 5 0
4 3 2 0
1 1 1 0
5 2 4 1
3 4 5 1
4 1 3 1
4 2 1 0
4 4 4 1
2 1 4 1
3 1 5 0
1 1 4 0
5 5 2 1
4 4 4 1
4 5 3 0
1 1 5 0
4 1 4 1
2 1 2 0
1 2 2 0
4 1 1 1
5 3 3 0
3 5 4 0
5 4 2 0
2 4 2 0
3 5 1 1
4 5 2 0
4 5 3 0
4 3 2 0
2 1 5 1
1 5 4 0
5 3 3 0
5 2 1 1
5 4 2 0
1 1 4 0
2 1 1 0
2 5 1 0
1 5 1 0
5 3 5 1
4 5 5 1
2 4 4 0
5 2 5 1
4 4 2 0
3 4 1 1
5 5 5 0
2 2 2 0
1 5 1 0
2 4 2 0
4 3 2 0
5 1 3 0
4 5 4 0
3 3 5 0
2 5 3 1
1 2 5 1
2 5 5 1
4 1 2 0
1 4 1 0
2 1 5 1
5 4 3 0
4 3 4 0
5 4 3 0
4 1 4 0
3 3 5 0
3 2 4 0
3 2 4 1
3 5 3 0
4 3 4 0
4 2 2 0
4 4 2 0
1 3 2 0
1 4 5 0
5 3 5 0
1 5 2 0
3 3 2 0
1 3 5 0
5 2 4 0
3 4 3 0
1 2 3 0
2 1 5 1
5 1 2 1
5 1 4 0
1 3 3 0
5 2 4 0
5 4 1 0
2 1 3 0
4 2 1 0
5 2 4 0
1 4 1 0
1 1 2 1
1 3 2 0
2 3 4 0
4 2 3 1
1 3 4 0
4 1 3 0
2 5 2 0
5 5 2 0
4 2 4 1
2 5 2 1
4 4 1 0
3 3 5 0
4 5 2 1
1 4 2 0
1 2 3 0
5 1 1 0
3 4 2 0
1 1 3 0
5 2 2 0
4 3 2 0
3 1 3 0
5 1 2 0
3 1 2 0
3 4 1 0
3 4 5 0
1 4 2 0
4 2 2 1
1 4 4 1
5 2 2 1
2 1 1 0
2 4 1 0
2 4 1 0
4 2 1 0
1 5 2 0
3 3 4 0
3 4 2 0
5 1 1 0
5 3 3 0
2 4 2 0
1 4 4 0
5 2 2 0
2 5 4 0
5 2 2 0
5 2 5 0
4 4 1 1
2 4 1 1
2 3 1 0
1 4 4 0
2 4 3 0
2 2 4 0
1 3 4 0
5 2 5 0
4 4 3 1
5 2 2 0
4 5 2 0
1 3 2 1
2 2 2 0
3 5 2 0
1 3 4 0
3 4 5 0
5 5 2 0
1 5 2 0
3 3 5 1
3 5 4 0
5 4 3 1
2 4 4 0
5 3 4 1
5 4 3 0
4 3 5 1
4 5 1 0
2 5 1 0
1 2 3 0
3 1 2 0
1 5 5 0
2 1 5 1
5 2 4 0
3 1 5 0
2 2 2 0
5 1 1 0
3 3 4 1
5 4 4 0
1 4 2 0
4 3 1 0
2 3 5 0
1 4 5 0
3 1 2 0
2 3 4 0
4 5 1 1
4 5 5 0
2 5 5 0
1 5 2 1
3 5 3 0
3 5 1 0
2 4 3 0
4 4 2 0
2 4 1 0
3 2 1 0
4 2 4 1
1 1 1 0
1 1 4 0
3 1 3 1
5 2 4 1
5 3 2 1
5 1 4 0
3 3 3 1
5 5 2 1
4 4 1 0
1 1 2 0
4 1 1 0
4 1 1 0
4 5 2 0
3 4 3 1
1 1 3 0
1 5 2 0
4 3 3 0
3 3 5 0
5 5 3 0
3 5 5 0
1 4 3 0
3 3 1 0
2 3 2 0
4 2 2 0
5 2 2 0
2 1 4 0
4 3 5 0
4 5 2 1
3 3 4 0
2 3 1 0
1 4 4 1
4 3 3 1
3 3 2 1
1 3 1 0
1 5 2 0
4 2 3 0
1 5 4 0
3 2 1 0
4 2 5 1
2 1 2 0
1 2 5 0
1 2 1 0
3 3 1 1
3 2 2 0
2 3 3 0
3 3 1 0
4 1 1 0
1 5 2 1
5 2 4 1
5 3 3 1
5 4 3 1
3 5 1 0
2 2 2 0
1 4 4 0
5 3 5 0
5 2 3 0
2 3 2 0
3 4 4 0
2 1 4 0
5 2 3 0
2 4 1 1
3 5 5 0
5 4 5 1
1 1 3 0
1 1 2 0
5 4 3 0
2 4 1 0
2 1 5 0
1 2 1 0
3 5 3 1
2 3 3 0
4 1 5 0
1 1 4 0
5 5 5 0
1 4 2 0
1 3 5 0
1 4 4 0
2 4 4 1
3 2 5 0
3 3 1 1
2 2 4 0
1 3 3 0
1 2 3 0
2 3 3 0
4 1 4 0
2 5 5 1
2 2 4 0
1 3 1 0
1 1 1 0
3 1 4 0
2 2 4 1
4 4 3 0
2 5 2 0
4 5 1 0
1 1 4 0
2 4 3 0
2 2 1 0
1 1 4 0
2 4 3 1
4 5 3 0
3 1 3 0
5 1 5 0
1 4 1 1
3 4 1 1
1 5 1 0
4 2 1 1
2 1 4 1
3 1 2 0
1 4 4 0
5 5 3 0
1 1 4 0
1 4 1 0
2 4 4 0
2 2 1 0
3 5 4 0
2 4 3 0
3 5 4 1
4 1 1 0
1 1 3 0
5 3 1 1
4 3 3 0
1 4 2 0
5 3 4 0
1 3 2 1
2 5 2 0
2 5 2 0
3 1 3 0
2 3 5 0
3 4 5 0
5 3 4 0
5 3 5 0
2 2 5 0
2 5 3 0
4 2 5 0
2 5 2 1
1 1 4 0
3 4 3 0
3 1 2 0
5 4 1 1
2 5 5 1
5 1 5 1
3 5 4 1
4 3 2 1
5 3 1 1
4 5 1 1
4 2 1 1
1 5 3 0
5 4 4 0
5 4 5 0
5 4 4 1
2 4 2 0
1 5 4 0
3 2 2 0
3 5 5 0
5 5 4 1
5 1 4 0
5 1 3 1
2 3 3 0
4 5 4 0
3 3 5 1
3 5 1 0
5 3 3 0
3 4 1 0
5 3 4 0
2 4 3 0
1 3 3 0
1 5 5 0
4 5 1 1
5 2 2 0
2 5 4 0
2 4 1 0
5 3 3 0
4 5 2 1
3 4 5 0
4 3 4 0
5 2 4 1
1 3 4 0
2 5 5 0
3 1 2 0
4 5 5 1
5 4 3 0
3 2 3 1
2 3 2 0
1 5 5 0
3 1 1 1
1 4 2 1
4 4 2 0
4 4 3 0
2 5 5 0
2 4 2 0
1 4 3 0
1 3 4 0
2 1 2 0
2 2 4 0
3 2 3 1
5 1 1 0
3 3 2 0
3 3 2 0
4 4 5 0
3 2 2 0
5 5 5 1
3 1 5 1
4 1 2 1
1 4 1 0
3 3 2 0
2 1 5 0
3 3 1 0
1 2 2 1
2 2 3 0
4 5 5 0
1 4 5 0
4 2 1 0
3 3 3 0
5 2 3 0
5 5 5 0
3 4 4 0
4 5 2 0
2 1 5 0
5 5 3 1
4 3 5 0
3 3 2 1
5 5 4 0
5 4 5 0
4 5 2 0
2 4 3 0
3 5 4 1
4 3 4 0
5 1 4 0
2 5 3 0
3 2 4 0
2 1 4 0
5 2 5 1
3 2 4 1
2 5 3 0
2 4 2 0
1 1 5 1
2 3 1 0
3 4 5 0
4 2 2 0
2 5 2 0
5 1 3 0
1 5 4 1
5 1 1 0
4 1 4 0
4 2 3 0
1 4 3 0
3 3 2 0
1 1 5 0
4 5 4 1
3 2 5 1
1 2 1 0
3 3 4 0
1 5 1 0
1 5 2 0
3 2 2 1
3 5 1 1
5 1 5 0
5 3 2 1
1 3 4 1
3 3 4 0
3 5 5 0
5 5 5 1
3 3 3 1
1 1 5 0
5 2 3 0
1 4 2 0
5 2 4 0
1 1 1 0
2 1 2 0
5 5 4 1
1 3 2 0
5 1 2 0
2 4 4 0
5 4 3 0
1 3 1 0
4 4 3 0
2 4 1 1
2 4 3 0
1 5 5 0
3 3 5 0

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Marketing Questions!