I need to run a regression of an individuals wage on a male dummy, equal to 1 for males and 0 for females.

[noblec]

using an average male wage and an average female wage, im having trouble being able to use the dummies and cant find any help regarding how to do this?


any help would be much appreciated

 

[Andrew Poulsom]

This may help you:

http://www.mrexcel.com/forum/showthread.php?t=89436

The Analysis ToolPak Add-In must be installed.

 

[noblec]

Do you always get a value for the intercept of zero?

 

[Andrew Poulsom]

I don't know, I haven't tried it.