Weight of Evidence / Information Value

[CraigAlexander]

Does anyone know how to code this in Excel?

 

[Mike Blackman]

Hi Craig and welcome to the board,

I think your going to give us a lot more information than just that i'm afraid. What exactly are you trying to do?

 

[CraigAlexander]

Hi Mike

Thank you for the welcome!

I'm not sure whether or not this can be done in Excel but I'm trying to build a credit scorecard taking the log of the good:bad odds - this I've achieved already but the next step (achieving the information value) has me stumped, I'm afraid.

 

[Boller]

Have you tried an internet search for Excel Weight of Evidence / Information Value ?

This is outside of my knowledge of statistics but the above search produces some links that might be useful to you.

 

[Mike Blackman]

Hi Craig,

Most things can be achieved in Excel with the use of VBA but as I am getting an idea of what your trying to do, I still don't know what your trying to do.

Can you post some data using the HTML maker found here.

 

[Boller]

Mike Blackman

I think this summarises what the OP wants to do :-

http://en.wikipedia.org/wiki/Bayes_factor