PDA

View Full Version : To find the unknown parameters by using subroutine



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.

Mis_Sailesh
04-02-2010, 01:59 AM
Hi Anni,
I am not sure about the formula you have posted, however you can start learning VBA by trying to understand the codes posted on this site and trying on hands on small codes...
Please revert to me if you need any further help in starting to learn VBA...:help