"In order to perform a separate equations regression for males and females, we will need to create an indicator variable for either males or for females. In order to create an indicator variable for males, in cell J2 use the following command.
=IF(G2="M",1,0)
This will result in a 1 for males and a 0 for females. We will also need to multiply this zero/one column of numbers by the values in the GPA column. The result will be a column that will repeat the value of GPA if the gender is male, otherwise there will be a zero."
These are the instructions I was given, however I am having difficulty creating the excel command. I need to create a command that, if cell G2 came up as "male," multiplies the GPA (in cell I2) by one. It also needs to multiply the GPA by zero if the cell G2 comes up as "female." I've attached an image to give you some sort of idea.
https___uwmad.courses.wisconsin.edu_content_enforced_1479144-stat301_006_fa11_Project 3 - Separa.jpg
Thanks, and help!!
Bookmarks