Home Forums Ask Anything Random Here Credit Analysis Project – Loan_Reason Analysis Issue

  • Credit Analysis Project – Loan_Reason Analysis Issue

  • Tundra.L

    Member
    November 26, 2020 at 10:25 am
    Up
    0
    Down

    My finding is: for both best and worst tier, 0 group’s debtCon/homelep ratio is always higher than 1 group, and the trends is almost the same cross those 10 tiers(decile)

  • norahx

    Member
    November 26, 2020 at 4:38 pm
    Up
    0
    Down

    Thanks for reply. Your observation is consistent with my chi-square test, which is Good group people tend to have more “debt consolidation “ Loan reason. Because both of them are relationships between “Loan reason “and “BAD“.. But when we observe the credit model, best group doesn’t seem to have more “DebtCondolidation” than worst group. That’s what I’m confused.

  • norahx

    Member
    November 26, 2020 at 6:28 am
    Up
    0
    Down

    The chi-square test and Group factor analysis gave me conflicted results, have anyone had the same problem?

    I. Chi-Square test –

    I tried to see how does Loan_Reason impact on Bad rate. So I did chi-square test.

    Null Hypothesis is DebtCon and HomeImp doesn’t have significant difference on Bad rate.

    Result Pvalue=0.0001, Hypothesis is rejected.

    So it shows DebtCon and HomeImp have difference on Bad rate.

    And through comparing observed and expected table I found

    Good Group(Bad=0) has more DebtCon percentage than HomeImp.

    II. Group factor

    When I took a look at the DebtCon Ratio, I found ,

    In the Best group DebtCon percentage=62%,

    In the worst group DebtCon percentage=68%.

    It conflicts with the chi-square conclusion.


    • This discussion was modified 3 months, 1 week ago by  norahx.
    • This discussion was modified 3 months, 1 week ago by  norahx.
    • This discussion was modified 3 months, 1 week ago by  norahx.
    • This discussion was modified 3 months, 1 week ago by  norahx.

Log in to reply.

Original Post
0 of 0 posts June 2018
Now