Samir,
I am not sure if this is what you want (I have never
use the glm command in Stata). Hopefully it helps.
Note that the A,B,C and D are the Excel columns and
1-3 represent Excel rows.
A B C D
1
2 x y power
3 2 =GAMMALN(B3^D3) -1.5
Regards,
Ana Rios
--- "Samir K.C." <[email protected]> wrote:
> Dear Statalisters,
> I ran following line
>
> glm y x, family(gamma) link(power -1.5)
>
> With the results (xb and _cons), how can I predict y
> for a given x. I
> know how to do it in stata, but I need the formula
> to run it in
> excel. Please help.
> Samir
>
> *
> * For searches and help try:
> *
> http://www.stata.com/support/faqs/res/findit.html
> * http://www.stata.com/support/statalist/faq
> * http://www.ats.ucla.edu/stat/stata/
>
____________________________________________________________________________________
Park yourself in front of a world of choices in alternative vehicles. Visit the Yahoo! Auto Green Center.
http://autos.yahoo.com/green_center/
*
* For searches and help try:
* http://www.stata.com/support/faqs/res/findit.html
* http://www.stata.com/support/statalist/faq
* http://www.ats.ucla.edu/stat/stata/