 #1
 277
 0
Main Question or Discussion Point
Regression in Excel
I want to make an regression of some data, but I only want to use some of the data. The data I want use is where Vacant = 1.
Is this possible in excel?
I have tried to use the iffunction but the regression does not like "false"
More info
I want to make a regression of Price = B1 + B2*sqft for the vacant houses.
I want to make an regression of some data, but I only want to use some of the data. The data I want use is where Vacant = 1.
Is this possible in excel?
I have tried to use the iffunction but the regression does not like "false"
More info
I want to make a regression of Price = B1 + B2*sqft for the vacant houses.
Attachments

76 KB Views: 121
Last edited: