Excel, help with if statement

  • Thread starter MaxManus
  • Start date
  • #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 if-function 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

Last edited:

Answers and Replies

  • #2
4,464
65
Excel is mostly hands-on

The simple solution is sort on the vacancy column and then graph the data with vacancy=1 using scatter plot.
This would be the result: price = 69.9 SQFT - 4793
 

Attachments

  • #3
277
0
Thanks.
 

Related Threads for: Excel, help with if statement

  • Last Post
Replies
2
Views
735
  • Last Post
Replies
2
Views
1K
  • Last Post
Replies
6
Views
617
  • Last Post
Replies
0
Views
2K
Replies
2
Views
965
Replies
5
Views
7K
Replies
2
Views
1K
  • Last Post
Replies
14
Views
1K
Top