Can someone please explain how exactly I can get the "Proportion" variable column and run a regression on excel with the steps shown clearly please?

Transcribed Image Text:

Gender Married Married Male No Female No Male Yes Male Yes Female No Female No Male Yes Male Yes Male Yes Male No Male Yes Male Yes Male No Male Yes Male Yes Male Yes Male Yes Male Yes Female No Male No Male Yes Male No Female No Male No Male Yes Male Yes Male Yes Male Yes Male No Female No Female No Male No Education Self Employed ApplicantIncome CoapplicantIncome LoanAmount Credit_History Property_Area Not Graduate No Graduate No Graduate No Graduate No Graduate Yes Graduate No Graduate No Graduate No Not Graduate No Graduate No Graduate Yes Not Graduate No Graduate Yes Graduate No Not Graduate No No No Not Graduate No Graduate No Not Graduate Yes Not Graduate No Graduate Yes Graduate No Not Graduate No Graduate No Graduate No Not Graduate No Graduate No Graduate No Graduate No Graduate No Graduate Yes Graduate Graduate 3189 8333 3155 5500 3463 3812 3315 5819 2510 2965 6250 3406 6050 9703 6608 2882 1809 1668 3427 2583 2661 16250 3083 6045 5250 14683 4931 6083 2060 3481 7200 5166 2598 0 1779 1260 0 0 0 5000 1983 5701 1300 4417 4333 0 0 1843 1868 3890 0 2167 7101 0 0 0 0 2100 0 4250 2209 0 0 0 120 280 140 170 122 112 96 120 140 155 108 123 120 112 137 123 90 201 138 104 279 192 255 115 94 304 128 330 134 155 120 128 1 Rural 1 Semiurban 1 Semiurban 1 Rural 0 Urban 1 Rural Semiurban 1 Rural 1 Urban 1 Urban 1 Rural 1 Semiurban 1 Urban 1 Urban 1 Urban 1 Semiurban Urban 0 Semiurban 1 Urban 1 Rural 1 Semiurban 0 Urban 1 Rural O Rural 1 Urban 1 Rural 0 Semiurban 0 Urban 1 Semiurban 1 Semiurban 1 Rural 1 Semiurban Loan_Status Married_dummy Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y 0 0 1 1 0 0 1 1 1 0 1 1 0 1 1 1 1 1 0 0 1 0 0 0 1 1 1 1 0 0 0 0 Gender Married Married Male No Female No Male Yes Male Yes Female No Female No Male Yes Male Yes Male Yes Male No Male Yes Male Yes Male No Male Yes Male Yes Male Yes Male Yes Male Yes Female No Male No Male Yes Male No Female No Male No Male Yes Male Yes Male Yes Male Yes Male No Female No Female No Male No Education Self Employed ApplicantIncome CoapplicantIncome LoanAmount Credit_History Property_Area Not Graduate No Graduate No Graduate No Graduate No Graduate Yes Graduate No Graduate No Graduate No Not Graduate No Graduate No Graduate Yes Not Graduate No Graduate Yes Graduate No Not Graduate No No No Not Graduate No Graduate No Not Graduate Yes Not Graduate No Graduate Yes Graduate No Not Graduate No Graduate No Graduate No Not Graduate No Graduate No Graduate No Graduate No Graduate No Graduate Yes Graduate Graduate 3189 8333 3155 5500 3463 3812 3315 5819 2510 2965 6250 3406 6050 9703 6608 2882 1809 1668 3427 2583 2661 16250 3083 6045 5250 14683 4931 6083 2060 3481 7200 5166 2598 0 1779 1260 0 0 0 5000 1983 5701 1300 4417 4333 0 0 1843 1868 3890 0 2167 7101 0 0 0 0 2100 0 4250 2209 0 0 0 120 280 140 170 122 112 96 120 140 155 108 123 120 112 137 123 90 201 138 104 279 192 255 115 94 304 128 330 134 155 120 128 1 Rural 1 Semiurban 1 Semiurban 1 Rural 0 Urban 1 Rural Semiurban 1 Rural 1 Urban 1 Urban 1 Rural 1 Semiurban 1 Urban 1 Urban 1 Urban 1 Semiurban Urban 0 Semiurban 1 Urban 1 Rural 1 Semiurban 0 Urban 1 Rural O Rural 1 Urban 1 Rural 0 Semiurban 0 Urban 1 Semiurban 1 Semiurban 1 Rural 1 Semiurban Loan_Status Married_dummy Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y 0 0 1 1 0 0 1 1 1 0 1 1 0 1 1 1 1 1 0 0 1 0 0 0 1 1 1 1 0 0 0 0

Answer rating: 100% (QA)

To get the Proportion variable column you can use the following steps Open the Excel file loan appli... View the full answer