exponetial's in Excell 97

  • Thread starter Thread starter gbuter
  • Start date Start date
G

gbuter

exponetial(5.228-1.154*LN(VAR1))-0.2038LN(var2)-(0.299 if Female)+(0.19
if African-American)
LN=natural log
How do I use this formula in Excell 9
 
=EXP(5.228-1.154*LN(VAR1))-0.2038*LN(var2)+IF(Gender="Female",-0.299,0)+IF(E
thnicity="African-American",0.192,0)

where VAR1, var2, Gender and Ethnicity are named cells carrying the related
parameters.
 
Back
Top