Dummy Variables
=IF(A2="H",1,0)
"rz-illini85" wrote:
I have a column of 4 different Letters(H,B,A,S) and i want to create three
different dummy columns of 1's and 0's to do a regression. How do i create
an if statement to say if column A is H then 1 if not then 0? I've tried:
=if(A2=H,1,0) and it said there was Name error
Help Please
|