Question:
Create a pivot table for the training data with Online as a column variable, CC as a row variable, and Loan as a secondary row variable. The values inside the cells should convey the count (how many records are in that cell).
Consider the task of classifying a customer who owns a bank credit card and is actively using online banking services. Analyse the pivot table and calculate the probability that this customer will accept the loan offer. Note: This is the probability of loan acceptance (Loan=1) conditional on having a bank credit card (CC=1) and being an active user of online banking services (Online=1).
Design two separate pivot tables for the training data. One will have Loan (rows) as a function of Online (columns) and the other will have Loan (rows) as a function of CC. Compute the following quantities [P(A | B) means “the probability of A given B”].
Answer:
| CCAvg |
Education |
Mortgage |
Personal Loan |
Securities Account |
CD Account |
Online |
CreditCard |
| 1.6 |
1 |
0 |
0 |
1 |
0 |
0 |
0 |
| 1.5 |
1 |
0 |
0 |
1 |
0 |
0 |
0 |
| 1 |
1 |
0 |
0 |
0 |
0 |
0 |
0 |
| 1 |
2 |
0 |
0 |
0 |
0 |
0 |
1 |
| 1.5 |
2 |
0 |
0 |
0 |
0 |
1 |
0 |
| 0.6 |
2 |
104 |
0 |
0 |
0 |
1 |
0 |
| 8.9 |
3 |
0 |
1 |
0 |
0 |
0 |
0 |
| 2.4 |
3 |
0 |
0 |
0 |
0 |
0 |
0 |
| 2.5 |
2 |
0 |
0 |
0 |
0 |
1 |
0 |
| 1.5 |
3 |
0 |
0 |
0 |
0 |
1 |
1 |
| 0.9 |
2 |
111 |
0 |
0 |
0 |
1 |
0 |
| 2 |
3 |
0 |
0 |
0 |
0 |
1 |
0 |
| 1.2 |
1 |
260 |
0 |
0 |
0 |
1 |
0 |
| 0.7 |
1 |
163 |
0 |
1 |
0 |
0 |
0 |
| 3.9 |
1 |
159 |
0 |
0 |
0 |
0 |
1 |
| 0.5 |
1 |
97 |
0 |
0 |
0 |
1 |
0 |
| 0.2 |
3 |
0 |
0 |
0 |
0 |
0 |
0 |
| 2.4 |
1 |
0 |
0 |
0 |
0 |
1 |
1 |
| 2.2 |
3 |
0 |
0 |
0 |
0 |
1 |
1 |
| 3.3 |
2 |
0 |
1 |
0 |
1 |
1 |
1 |
| 1.2 |
3 |
122 |
0 |
0 |
0 |
1 |
0 |
| 2 |
2 |
0 |
0 |
0 |
0 |
1 |
0 |
| 5 |
3 |
0 |
1 |
1 |
1 |
1 |
0 |
| 2.3 |
1 |
0 |
0 |
0 |
0 |
0 |
0 |
| 1.1 |
2 |
412 |
1 |
0 |
0 |
1 |
0 |
| 0.7 |
1 |
0 |
0 |
0 |
0 |
1 |
0 |
| 5.7 |
1 |
0 |
0 |
0 |
0 |
1 |
1 |
| 2.5 |
1 |
0 |
0 |
0 |
0 |
0 |
1 |
| 4.5 |
3 |
0 |
0 |
0 |
0 |
0 |
1 |
| 1.8 |
1 |
0 |
0 |
0 |
0 |
0 |
1 |
| 0.7 |
2 |
0 |
0 |
1 |
0 |
1 |
0 |
| 2.9 |
1 |
0 |
0 |
0 |
0 |
1 |
0 |
| 0.1 |
1 |
207 |
0 |
0 |
0 |
0 |
0 |
| 8 |
1 |
0 |
0 |
0 |
0 |
1 |
0 |
| 0.1 |
2 |
0 |
0 |
1 |
1 |
1 |
0 |
| 1.2 |
3 |
0 |
1 |
0 |
0 |
0 |
0 |
| 4.5 |
1 |
455 |
0 |
0 |
0 |
0 |
0 |
| 2.8 |
1 |
336 |
0 |
0 |
0 |
0 |
0 |
| 2.1 |
1 |
0 |
0 |
0 |
0 |
1 |
1 |
| 3.5 |
1 |
0 |
0 |
0 |
0 |
0 |
1 |
| 1 |
2 |
0 |
0 |
0 |
0 |
1 |
0 |
| 5 |
1 |
0 |
0 |
0 |
0 |
0 |
1 |
| 4 |
3 |
0 |
0 |
0 |
0 |
1 |
1 |
| 0.5 |
2 |
0 |
0 |
0 |
0 |
0 |
0 |
| 2.6 |
3 |
0 |
1 |
0 |
0 |
0 |
0 |
| 2.7 |
2 |
0 |
0 |
0 |
0 |
1 |
0 |
| 4 |
3 |
0 |
0 |
0 |
0 |
1 |
0 |
| 1.8 |
3 |
0 |
0 |
0 |
0 |
0 |
0 |
| 1.1 |
1 |
0 |
0 |
0 |
0 |
1 |
0 |
| 1.1 |
3 |
0 |
0 |
0 |
0 |
1 |
0 |
| 2 |
1 |
0 |
0 |
0 |
0 |
0 |
0 |
| 0.2 |
3 |
0 |
0 |
0 |
0 |
1 |
0 |
| 0.1 |
3 |
0 |
0 |
0 |
0 |
1 |
0 |
| 1.2 |
1 |
0 |
0 |
0 |
0 |
1 |
0 |
| 1.3 |
2 |
0 |
0 |
0 |
0 |
0 |
0 |
| 0.3 |
2 |
0 |
0 |
0 |
0 |
1 |
0 |
| 2.9 |
1 |
0 |
0 |
0 |
0 |
1 |
1 |
| 0.6 |
3 |
166 |
0 |
0 |
0 |
1 |
0 |
| 1 |
2 |
0 |
0 |
0 |
0 |
0 |
0 |
| 1.3 |
2 |
0 |
0 |
0 |
0 |
1 |
0 |
| 1 |
1 |
309 |
0 |
0 |
0 |
0 |
0 |
| 2.8 |
1 |
103 |
0 |
0 |
0 |
0 |
0 |
| 2.3 |
3 |
193 |
0 |
0 |
0 |
1 |
0 |
| 3 |
1 |
0 |
0 |
0 |
0 |
1 |
0 |
| 0.2 |
3 |
0 |
0 |
0 |
0 |
1 |
0 |
| 0.9 |
3 |
0 |
0 |
0 |
0 |
1 |
0 |
| 3.6 |
2 |
0 |
0 |
1 |
0 |
0 |
0 |
| 2.4 |
1 |
118 |
0 |
0 |
0 |
1 |
0 |
| 0.5 |
1 |
0 |
0 |
0 |
0 |
1 |
0 |
| 2.7 |
2 |
251 |
0 |
0 |
0 |
1 |
0 |
| 0.5 |
3 |
0 |
0 |
0 |
0 |
0 |
1 |
| 2.1 |
1 |
0 |
0 |
0 |
0 |
1 |
1 |
| 0.4 |
1 |
0 |
0 |
0 |
0 |
0 |
0 |
| 1.5 |
1 |
0 |
0 |
1 |
1 |
0 |
1 |
| 0.4 |
3 |
161 |
0 |
0 |
0 |
1 |
1 |
| 2.1 |
3 |
0 |
0 |
0 |
0 |
0 |
1 |
| 3.6 |
3 |
188 |
0 |
0 |
0 |
1 |
0 |
| 7.5 |
1 |
0 |
0 |
0 |
1 |
1 |
1 |
| 1.3 |
3 |
0 |
0 |
0 |
0 |
0 |
0 |
| 0.4 |
1 |
0 |
0 |
0 |
0 |
0 |
1 |
| 2.666666667 |
1 |
0 |
0 |
0 |
0 |
1 |
1 |
| 1.5 |
3 |
0 |
0 |
0 |
0 |
1 |
1 |
| 6.5 |
3 |
0 |
1 |
0 |
0 |
0 |
0 |
| 2.6 |
1 |
0 |
0 |
0 |
0 |
1 |
0 |
| 1.1 |
1 |
0 |
0 |
1 |
0 |
0 |
0 |
| 1.5 |
1 |
0 |
0 |
0 |
0 |
1 |
0 |
| 1 |
1 |
0 |
0 |
0 |
0 |
1 |
0 |
| 2.1 |
3 |
0 |
0 |
0 |
0 |
0 |
1 |
| 2 |
1 |
0 |
0 |
0 |
0 |
1 |
0 |
| 0.4 |
1 |
0 |
0 |
1 |
0 |
0 |
0 |
| 7.8 |
1 |
0 |
0 |
0 |
0 |
1 |
0 |
| 1.1 |
2 |
0 |
0 |
1 |
0 |
1 |
0 |
| 1 |
2 |
135 |
0 |
0 |
0 |
1 |
0 |
| 1.8 |
2 |
244 |
0 |
0 |
0 |
0 |
0 |
| 0.1 |
1 |
0 |
0 |
0 |
0 |
1 |
0 |
| 1 |
3 |
164 |
0 |
0 |
0 |
1 |
0 |
| 0.7 |
2 |
81 |
0 |
0 |
0 |
0 |
0 |
| 2.1 |
1 |
122 |
0 |
0 |
0 |
1 |
0 |
| 1.4 |
1 |
0 |
0 |
0 |
0 |
1 |
0 |
| 4.3 |
1 |
0 |
0 |
0 |
0 |
1 |
0 |
| 0.6 |
1 |
0 |
0 |
0 |
0 |
1 |
1 |
| 1 |
1 |
95 |
0 |
1 |
0 |
1 |
0 |
| 0 |
1 |
90 |
0 |
1 |
0 |
1 |
0 |
