Question: The Excel file attached has a dependent variable labeled Y and two independent variables labeled X 1 and X 2 . Create a series of

The Excel file attached has a dependent variable labeled Y and two independent variables labeled X1 and X2.
Create a series of indicator variables to categorize the variable X1 in the following way. Create a variable named Ind1M which takes on the value of one if the variable X1 has a value larger than 29 but less than 70 and is zero otherwise. Addtionally, create an indicator variable named Ind1H which takes on the value of one if the value of X1 is 70 or larger and zero otherwise..
If you run a multiple linear regression using Y as your dependent variable and only X2, Ind1M and Ind1H as your independent variables, then the impact that Ind1H has on Y is estimated as (choose the closest answer)
a)638.8422
b)-18.2375
c)952.3399
d)101.8809

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!