Please post answer in excel screenshots and typing (no scratch paper)

Problem #9 (Classification): Use discriminant analysis to classify the new records in the Excel file Credit Approval Decisions Discriminant Analysis (D2L Content > Datasets by Chapter > Chapter 10 > CreditApproval DecisionsDiscriminantAnalysis.xlsx) using only Credit Score and Years of Credit History as input variables. SUMMARY OUTPUT Scar FinStoritier Multiple R 0.911190975 R Square 0.830268992 AdjurtdR Square 0.810981374 Standard Error 0.218884522 Ostian 50 ANOWA Sawiticae 43.04674383 7.33307E-16 Regrerrian Roridual Total of 5 44 44 mes 2.062388181 0.047910434 10.3119409 2.108059097 12.02 11,700 tier Intercopt 0.567045247 HomeBuner 0.149103522 Credit Score 0.000464676 Years of Credit Hirto 0.004198118 Revolving Balance -8.6449E-07 Repuina iliti -109861334 Stardor d'Erre 0.478648652 0.090877595 0.00059988 0.006744824 3.79441E-06 0.146.484054 1 Stor 1.184679712 1.640707181 0.774615018 0.622420643 -0.22703217 -5.57721602 Pou Louw w Loww ws' 0.242503847 -0.39760763 1.53169832 -0.39760763 1.53169832 0.107988621 -0.03404824 0.33225528 -0.03404824 0.33225528 0.442710032 -0.0007443 0.00167365 -0.0007443 0.00167365 0.536877785 -0.00939518 0.01779142 -0.00939518 0.01779142 0.820831342 -3.5116E-06 6.7826E-06 -8.5116E-06 6.7826E-06 140586E-06 144560862 -0.70161805 -144560862 -0.70161805 9,700 1.0482 1 Cudit Approval Decirinn 2 Dircrisisest 3 HEDURE redit Scorer of Credit Hirtel in Baal in UtilizatiD.ciries 1 1 725 20 $ 11,320 25% 1 0.8526 5 1 677 11 $ 20,000 55% 1 0.4554 E 1 795 22 $ 9,000 12% 1 1.0383 7 0 733 7 7 $ 35,200 20% 1 0.6869 I 1 660 24 $ 4,200 35% 1 0.7) 11 3 1 700 19 19 $ 22,000 18% 1 0.9044 11 1 774 13 $ 6,100 7% 1 1.0482 11 1 802 10 $ 10,500 5% 1 1.0668 12 1 1 811 20 $ 13,400 3% 1 1.1324 15 1 642 13 $ 16,000 25% 1 0.7806 14 0 688 3 $ 3,300 11% 1 0.7756 15 1 649 12 $ 7,500 5% 1 1.0067 16 1 695 15 $ 20,300 227 1 0.8426 17 1 1 701 9 $ 15%. 1 0.9048 11 1 677 12 $ 7.600 1 0.9757 13 1 699 17 $ 12,600 27% 1 0.8046 21 1 703 22 $ 10,000 20% 1 0.9068 21 1 16 $ 11% 1 0.9770 22 1 774 13 $ 6,100 7% 1 23 1 802 10 $ 10,500 5%. 1 1.0666 24 1 801 20 $ 13,400 1 1 1.1270 25 1 702 11 $ 11,700 15%. 1 0.9136 26 1 733 15 $ 13,000 24% 1 27 1 573 9 $ 7,200 70% O 0.2449 21 O 625 15 $ 12,600 65% O 0.1953 25 V 527 12 $ 5,700 752 O 0.0334 1 0 620 5 $ 22,800 62% O 0.1753 1 31 591 17 $ 16,500 50% O 12 1 500 16 $ 12,500 0 0.0930 13 1 565 6 $ 7,700 70% 0 0.2282 1 0 620 3 $ 37,400 87% O -0.1204 15 0 640 7 944 $ 59% O 0.2307 36 O 523 14 $ 27,000 79% O -0.0224 17 0 763 2 $ 11,200 70% O 0.1513 1 0 555 4 $ 2,500 100% O -0.2590 35 0 617 9 $ 8.400 O 0.5107 0 635 7 $ 29,100 85% O -0.0675 11 0 507 2 $ 2,000 100% 0 12 0 485 5 $ 1.000 O -0.0664 12 O 582 104 3 $ 65% O 134 0.1286 4 O 585 18 $ 31,000 78% 0 0.0307 15 1 620 8 $ 16,200 55% 0 0.4196 16 0 640 7 $ 17,200 59% O 0.2207 17 0 536 14 $ 27,000 79% O -0.0164 V 760 Z $ 11,200 70% 0 0.1499 13 0 567 4 $ 2,200 95% 0 -0.1983 51 O 600 10 $ 12,050 81% O -0.0125 5 51 1 636 8 $ 29,100 85% 0 0.0863 52 0 509 3 $ 2,000 1004 0 -0.2842 53 O 595 18 29,000 78% O 0.0371 54 Azer. 55 Appray 0.9130 723.3913 14.5217 12622.6087 0.1648 1 0.9083 SE Raject 0.2222 591.7037 8.4444 15061.1111 0.7459 0 0.0781 1 Record to Clurify Dircrisisest H----user redit Scorur of Credit Histovali, Bal.sv-lvis Utilizat Scor. Decirias 700 $21,000 15% Approva O 520 1 1 $4,000 90% -0.1793 Reject 1 6.50 10 $8,500.00 25% 0.7782 Approve 602 7 $16,300.00 702 0.0930 Rejest 549 2 $2,500.00 40% -0.1604 Reject 1 742 15 $16,700.00 18% 0.9117 Approve O 0 17,300 Cutoff value 0.49321076 Problem #9 (Classification): Use discriminant analysis to classify the new records in the Excel file Credit Approval Decisions Discriminant Analysis (D2L Content > Datasets by Chapter > Chapter 10 > CreditApproval DecisionsDiscriminantAnalysis.xlsx) using only Credit Score and Years of Credit History as input variables. SUMMARY OUTPUT Scar FinStoritier Multiple R 0.911190975 R Square 0.830268992 AdjurtdR Square 0.810981374 Standard Error 0.218884522 Ostian 50 ANOWA Sawiticae 43.04674383 7.33307E-16 Regrerrian Roridual Total of 5 44 44 mes 2.062388181 0.047910434 10.3119409 2.108059097 12.02 11,700 tier Intercopt 0.567045247 HomeBuner 0.149103522 Credit Score 0.000464676 Years of Credit Hirto 0.004198118 Revolving Balance -8.6449E-07 Repuina iliti -109861334 Stardor d'Erre 0.478648652 0.090877595 0.00059988 0.006744824 3.79441E-06 0.146.484054 1 Stor 1.184679712 1.640707181 0.774615018 0.622420643 -0.22703217 -5.57721602 Pou Louw w Loww ws' 0.242503847 -0.39760763 1.53169832 -0.39760763 1.53169832 0.107988621 -0.03404824 0.33225528 -0.03404824 0.33225528 0.442710032 -0.0007443 0.00167365 -0.0007443 0.00167365 0.536877785 -0.00939518 0.01779142 -0.00939518 0.01779142 0.820831342 -3.5116E-06 6.7826E-06 -8.5116E-06 6.7826E-06 140586E-06 144560862 -0.70161805 -144560862 -0.70161805 9,700 1.0482 1 Cudit Approval Decirinn 2 Dircrisisest 3 HEDURE redit Scorer of Credit Hirtel in Baal in UtilizatiD.ciries 1 1 725 20 $ 11,320 25% 1 0.8526 5 1 677 11 $ 20,000 55% 1 0.4554 E 1 795 22 $ 9,000 12% 1 1.0383 7 0 733 7 7 $ 35,200 20% 1 0.6869 I 1 660 24 $ 4,200 35% 1 0.7) 11 3 1 700 19 19 $ 22,000 18% 1 0.9044 11 1 774 13 $ 6,100 7% 1 1.0482 11 1 802 10 $ 10,500 5% 1 1.0668 12 1 1 811 20 $ 13,400 3% 1 1.1324 15 1 642 13 $ 16,000 25% 1 0.7806 14 0 688 3 $ 3,300 11% 1 0.7756 15 1 649 12 $ 7,500 5% 1 1.0067 16 1 695 15 $ 20,300 227 1 0.8426 17 1 1 701 9 $ 15%. 1 0.9048 11 1 677 12 $ 7.600 1 0.9757 13 1 699 17 $ 12,600 27% 1 0.8046 21 1 703 22 $ 10,000 20% 1 0.9068 21 1 16 $ 11% 1 0.9770 22 1 774 13 $ 6,100 7% 1 23 1 802 10 $ 10,500 5%. 1 1.0666 24 1 801 20 $ 13,400 1 1 1.1270 25 1 702 11 $ 11,700 15%. 1 0.9136 26 1 733 15 $ 13,000 24% 1 27 1 573 9 $ 7,200 70% O 0.2449 21 O 625 15 $ 12,600 65% O 0.1953 25 V 527 12 $ 5,700 752 O 0.0334 1 0 620 5 $ 22,800 62% O 0.1753 1 31 591 17 $ 16,500 50% O 12 1 500 16 $ 12,500 0 0.0930 13 1 565 6 $ 7,700 70% 0 0.2282 1 0 620 3 $ 37,400 87% O -0.1204 15 0 640 7 944 $ 59% O 0.2307 36 O 523 14 $ 27,000 79% O -0.0224 17 0 763 2 $ 11,200 70% O 0.1513 1 0 555 4 $ 2,500 100% O -0.2590 35 0 617 9 $ 8.400 O 0.5107 0 635 7 $ 29,100 85% O -0.0675 11 0 507 2 $ 2,000 100% 0 12 0 485 5 $ 1.000 O -0.0664 12 O 582 104 3 $ 65% O 134 0.1286 4 O 585 18 $ 31,000 78% 0 0.0307 15 1 620 8 $ 16,200 55% 0 0.4196 16 0 640 7 $ 17,200 59% O 0.2207 17 0 536 14 $ 27,000 79% O -0.0164 V 760 Z $ 11,200 70% 0 0.1499 13 0 567 4 $ 2,200 95% 0 -0.1983 51 O 600 10 $ 12,050 81% O -0.0125 5 51 1 636 8 $ 29,100 85% 0 0.0863 52 0 509 3 $ 2,000 1004 0 -0.2842 53 O 595 18 29,000 78% O 0.0371 54 Azer. 55 Appray 0.9130 723.3913 14.5217 12622.6087 0.1648 1 0.9083 SE Raject 0.2222 591.7037 8.4444 15061.1111 0.7459 0 0.0781 1 Record to Clurify Dircrisisest H----user redit Scorur of Credit Histovali, Bal.sv-lvis Utilizat Scor. Decirias 700 $21,000 15% Approva O 520 1 1 $4,000 90% -0.1793 Reject 1 6.50 10 $8,500.00 25% 0.7782 Approve 602 7 $16,300.00 702 0.0930 Rejest 549 2 $2,500.00 40% -0.1604 Reject 1 742 15 $16,700.00 18% 0.9117 Approve O 0 17,300 Cutoff value 0.49321076