Question: Transformed Data used for Descriptive analysis, Correlation , and regression I did the project but i need to know what to explain in the presentation

 Transformed Data used for Descriptive analysis, Correlation , and regression I

did the project but i need to know what to explain inthe presentation but im not sure what all this is...Please Help!!!! LM M N o Key Variable Loan Status Conversion Raw Fully Paid

Transformed Data used for Descriptive analysis, Correlation , and regression

I did the project but i need to know what to explain in the presentation but im not sure what all this is...Please Help!!!!

L M M N o Key Variable Loan Status Conversion Raw Fully Paid Charged Off 1 0 Term 36 Months 60 Months 36 60 o P Q R S T Descriptive Analysis Data Loan Paid Term of Loan loan_amnt int_rate annual_ing dti 1 36 5000 0.11 24000 27.65 0 60 2500 0.15 30000 1 1 36 2400 0.16 12252 8.72 1 36 10000 0.13 49200 20 1 60 3000 0.13 80000 17.94 1 36 5000 0.08 36000 11.2 1 60 7000 0.16 47004 23.51 1 36 3000 0.19 48000 5.35 0 60 5600 0.21 40000 5.55 0 60 5375 0.13 15000 18.08 1 60 6500 0.15 72000 16.12 1 36 12000 0.13 75000 10.78 0 36 9000 0.13 30000 10.08 1 36 3000 0.10 15000 12.56 0 36 10000 0.11 100000 7.06 1 36 1000 0.16 28000 20.31 1 36 10000 0.15 42000 18.6 1 36 3600 0.06 110000 10.52 1 36 6000 0.12 84000 18.44 1 36 9200 0.06 77385.19 9.86 1 60 20250 0.15 43370 26.53 0 36 21000 0.12 105000 13.22 1 36 10000 0.12 50000 11.18 1 36 10000 0.12 50000 16.01 600 012 700 24 B D H K Loan Paid G int_rate Term of Loan loan_amnt annual_inc dti Mean Standard Error Median Mode Standard Deviation Sample Variance Kurtosis Skewness Range Minimum Maximum Sum Count 0.857487558 Mean 0.001752591 Standard Error 1 Median 1 Mode 0.349579343 Standard Deviation 0.122205717 Sample Variance 2.183554101 Kurtosis -2.045346997 Skewness 1 Range O Minimum 1 Maximum 34116 Sum 39786 Count 42.44849947 Mean 11231.36028 Mean 0.053336778 Standard Error 37.42295482 Standard Error 36 Median 10000 Median 36 Mode 10000 Mode 10.6387822 Standard Deviation 7464.542832 Standard Deviation 113.1836867 Sample Variance 55719399.69 Sample Variance -0.910763125 Kurtosis 0.763136391 Kurtosis 1.043687051 Skewness 1.057864295 Skewness 24 Range 34500 Range 36 Minimum 500 Minimum 60 Maximum 35000 Maximum 1688856 Sum 446850900 Sum 39786 Count 39786 Count 0.120278734 Mean 68979.06676 Mean 0.000186874 Standard Error 319.6694351 Standard Error 0.1186 Median 59000 Median 0.1099 Mode 60000 Mode 0.037274665 Standard Deviation 63762.63452 Standard Deviation 0.001389401 Sample Variance 4065673561 Sample Variance -0.449043149 Kurtosis 2303.219566 Kurtosis 0.292969924 Skewness 30.94133112 Skewness 0.1917 Range 5996000 Range 0.0542 Minimum 4000 Minimum 0.2459 Maximum 6000000 Maximum 4785.4097 Sum 2744401150 Sum 39786 Count 39786 Count 13.31779395 0.033481184 13.41 0 6.678300272 44.59969452 -0.850829816 -0.027761063 29.99 0 29.99 529861.75 39786 F G dti B D E Loan Paid Term of Loan loan_amnt int_rate annual_inc 1 -0.149150863 1 -0.05003481 0.362123181 1 -0.197918213 0.452884314 0.310480613 1 0.041167915 0.046809444 0.271339536 0.053485388 1 -0.041983622 0.082821683 0.06713646 0.111149219 -0.122537459 1 SS MS F Significance F 0 391.596563 228.0805786 4633.873878 45.61611573 0.116487528 4861.954456 Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0% 0.008253462 138.2431705 0 1.124807742 1.157161702 1.124807742 1.157161702 0.000187157 -14.25699276 5.2667E-46 -0.003035133 -0.002301468 -0.003035133 -0.002301468 2.60103E-07 3.543715272 0.000394983 4.11922E-07 1.43154E-06 4.11922E-07 1.43154E-06 0.05246377 -30.1090933 6.0367E-197 -1.682466772 -1.476806316 -1.682466772 -1.476806316 2.82198E-08 9.16163662 5.34829E-20 2.03228E-07 3.13851E-07 2.03228E-07 3.13851E-07 0.000260756 -2.424974469 0.015313885 -0.001143414 -0.000121239 -0.001143414 -0.000121239 L M M N o Key Variable Loan Status Conversion Raw Fully Paid Charged Off 1 0 Term 36 Months 60 Months 36 60 o P Q R S T Descriptive Analysis Data Loan Paid Term of Loan loan_amnt int_rate annual_ing dti 1 36 5000 0.11 24000 27.65 0 60 2500 0.15 30000 1 1 36 2400 0.16 12252 8.72 1 36 10000 0.13 49200 20 1 60 3000 0.13 80000 17.94 1 36 5000 0.08 36000 11.2 1 60 7000 0.16 47004 23.51 1 36 3000 0.19 48000 5.35 0 60 5600 0.21 40000 5.55 0 60 5375 0.13 15000 18.08 1 60 6500 0.15 72000 16.12 1 36 12000 0.13 75000 10.78 0 36 9000 0.13 30000 10.08 1 36 3000 0.10 15000 12.56 0 36 10000 0.11 100000 7.06 1 36 1000 0.16 28000 20.31 1 36 10000 0.15 42000 18.6 1 36 3600 0.06 110000 10.52 1 36 6000 0.12 84000 18.44 1 36 9200 0.06 77385.19 9.86 1 60 20250 0.15 43370 26.53 0 36 21000 0.12 105000 13.22 1 36 10000 0.12 50000 11.18 1 36 10000 0.12 50000 16.01 600 012 700 24 B D H K Loan Paid G int_rate Term of Loan loan_amnt annual_inc dti Mean Standard Error Median Mode Standard Deviation Sample Variance Kurtosis Skewness Range Minimum Maximum Sum Count 0.857487558 Mean 0.001752591 Standard Error 1 Median 1 Mode 0.349579343 Standard Deviation 0.122205717 Sample Variance 2.183554101 Kurtosis -2.045346997 Skewness 1 Range O Minimum 1 Maximum 34116 Sum 39786 Count 42.44849947 Mean 11231.36028 Mean 0.053336778 Standard Error 37.42295482 Standard Error 36 Median 10000 Median 36 Mode 10000 Mode 10.6387822 Standard Deviation 7464.542832 Standard Deviation 113.1836867 Sample Variance 55719399.69 Sample Variance -0.910763125 Kurtosis 0.763136391 Kurtosis 1.043687051 Skewness 1.057864295 Skewness 24 Range 34500 Range 36 Minimum 500 Minimum 60 Maximum 35000 Maximum 1688856 Sum 446850900 Sum 39786 Count 39786 Count 0.120278734 Mean 68979.06676 Mean 0.000186874 Standard Error 319.6694351 Standard Error 0.1186 Median 59000 Median 0.1099 Mode 60000 Mode 0.037274665 Standard Deviation 63762.63452 Standard Deviation 0.001389401 Sample Variance 4065673561 Sample Variance -0.449043149 Kurtosis 2303.219566 Kurtosis 0.292969924 Skewness 30.94133112 Skewness 0.1917 Range 5996000 Range 0.0542 Minimum 4000 Minimum 0.2459 Maximum 6000000 Maximum 4785.4097 Sum 2744401150 Sum 39786 Count 39786 Count 13.31779395 0.033481184 13.41 0 6.678300272 44.59969452 -0.850829816 -0.027761063 29.99 0 29.99 529861.75 39786 F G dti B D E Loan Paid Term of Loan loan_amnt int_rate annual_inc 1 -0.149150863 1 -0.05003481 0.362123181 1 -0.197918213 0.452884314 0.310480613 1 0.041167915 0.046809444 0.271339536 0.053485388 1 -0.041983622 0.082821683 0.06713646 0.111149219 -0.122537459 1 SS MS F Significance F 0 391.596563 228.0805786 4633.873878 45.61611573 0.116487528 4861.954456 Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0% 0.008253462 138.2431705 0 1.124807742 1.157161702 1.124807742 1.157161702 0.000187157 -14.25699276 5.2667E-46 -0.003035133 -0.002301468 -0.003035133 -0.002301468 2.60103E-07 3.543715272 0.000394983 4.11922E-07 1.43154E-06 4.11922E-07 1.43154E-06 0.05246377 -30.1090933 6.0367E-197 -1.682466772 -1.476806316 -1.682466772 -1.476806316 2.82198E-08 9.16163662 5.34829E-20 2.03228E-07 3.13851E-07 2.03228E-07 3.13851E-07 0.000260756 -2.424974469 0.015313885 -0.001143414 -0.000121239 -0.001143414 -0.000121239

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 Accounting Questions!