Dummy Variables
 

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

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

Dummy Variables
 

=--A2="H"

etc.

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)
"rz-illini85" wrote in message
...
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

Dummy Variables
 

Bob

Wouldn't that need to be:

=--(A2="H")

Richard



Bob Phillips wrote:

=--A2="H"

etc.

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)
"rz-illini85" wrote in message
...
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

Dummy Variables
 

Of course it would, I kep making that error <g

Bob

(change the xxxx to gmail if mailing direct)
"RichardSchollar" wrote in message
oups.com...
Bob

Wouldn't that need to be:

=--(A2="H")

Richard



Bob Phillips wrote:

=--A2="H"

etc.

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)
"rz-illini85" wrote in message
...
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