In the Excel file Credit Risk Data, classify the following record:
Loan education Checking 600 Savings 3500 Months Customer 30 Months Employed 45 Gender M Marital Status Single Age 27 Housing Rent Years 3 Job skilled
Using k-NN algorithm for k=1 to 5.
Using discriminant analysis.
G
Credit Risk Data 2
3
JobCredit Risk 3 Unskilled Low 1 Skilled High 4 Management High 2 Unskilled High 3 Skilled Low 1 Skilled Low 3 Unskilled Low 1 Unskilled Low 2 Skilled High 1 Skilled High 2 Management High 2 Unskilled Low 1 Skilled Low 1 Skilled High 3 Unskilled Low 4 Management Low 2 Skilled High 2 Skilled Low 4 Skilled Low 2 Skilled High 4 Skilled High 4 Skilled High 4 Skilled High 2 Management High 2 Unskilled Low 3 Skilled Low 4 Skilled High 1 Skilled Low 4 Skilled Low 2 Skilled Low 4 Skilled High
4 Small Appliance 5 Furniture 6 New Car 7 Furniture 8 Education 9 Furniture 10 New Car 11 Business 12 Small Appliance Small Appliance 14 Business 15 New Car 16 Business 17 New Car 18 New Car 19 Used Car 20 Furniture 21 New Car 22 Repairs 23 Education 24 Furniture 25 Furniture 26 Furniture 27 Furniture 28 New Car 29 Business 30 Used Car 31 Used Car 32 Small Appliance 33 Small Appliance 34 Education
$0 $739 $0 $1,230 $0 $389 $638 $347 $963 $4,754 $2,827 $0 $0 $229 $0 $533 $6,509 $493 $966 $0 $0 $989 $0 $3,305 $322 $578 $0 $821 $396 $228 $0 $129 $652 $732 $708 $683 $207 $0 $287 $12,348 $0$17,545 $101 $3,871 $0 $0 $0 $485 $0 $10,723 $141 $245 $0 $0 $2,484 $0 $237 $236 $0 $485 $335 $1,708
13 25 19 13 40 11 13 14 37 25 49 11 10 25 13 31 49 13 28 7 34 13 25 37 11 22 19 49 37 19 37
12 0 119 14 45 13 16 2 9 4 0 15 14 63 26 8 4 33 116 2 16 5 23 23 15 33 58 46 24 12 7
M M M M M M M M M F M M M M M M F M M F F F M F M M M M M M M
Single 23 Own Divorced 32 Own Single 38 Own Single 36 Own Single 31 Rent Married 25 Own Married 26 Own Single 27 Own Single 25 Own Divorced 43 Own Single 32 Rent Single 34 Rent Married 26 Own Single 44 Own Single 46 Own Divorced 39 Own Divorced 25 Own Single 31 Own Single 47 Own Divorced 23 Rent Divorced 22 Own Divorced 26 Rent Married 19 Own Divorced 27 Own Single 39 Rent Single 26 Own Single 50 Other Single 34 Other Single 23 Rent Single 23 Own Single 46 Other