Excel, help with if statement

  • Thread starter MaxManus
  • Start date
  • #1
277
0
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

  • stockton2.xls
    76 KB · Views: 206
Last edited:

Answers and Replies

  • #2
4,488
73
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

  • stockton2(1).xls
    93 KB · Views: 227
  • #3
277
0
Thanks.
 

Related Threads on Excel, help with if statement

  • Last Post
Replies
2
Views
2K
  • Last Post
Replies
6
Views
881
  • Last Post
Replies
2
Views
982
  • Last Post
Replies
0
Views
2K
Replies
2
Views
1K
Replies
5
Views
7K
Replies
2
Views
2K
  • Last Post
Replies
14
Views
1K
Replies
1
Views
4K
  • Last Post
Replies
1
Views
1K
Top