anniehung
12-28-2009, 05:43 PM
Hello, I am a complete newbie on VBA, so please help me to start.
Basically, I have to maximize
∑[θx* ln qx +(Ex-θx)* ln px] (where x is the subscript, denote the age)
θx and Ex are known,
I would like to model qx= Bc^x
and px=(1-qx)
I believe by using the VBA, subroutine function,
I would be able to get a good estimation of the unknown parameter B and c.
But would anyone suggest me how to start?
Thank you very much.
Basically, I have to maximize
∑[θx* ln qx +(Ex-θx)* ln px] (where x is the subscript, denote the age)
θx and Ex are known,
I would like to model qx= Bc^x
and px=(1-qx)
I believe by using the VBA, subroutine function,
I would be able to get a good estimation of the unknown parameter B and c.
But would anyone suggest me how to start?
Thank you very much.