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: 141
Last edited:

Answers and Replies

  • #2
4,465
72
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: 159
  • #3
277
0
Thanks.
 

Related Threads on Excel, help with if statement

  • Last Post
Replies
2
Views
1K
  • Last Post
Replies
2
Views
842
  • Last Post
Replies
0
Views
2K
  • Last Post
Replies
6
Views
723
Replies
2
Views
1K
Replies
5
Views
7K
Replies
2
Views
1K
  • Last Post
Replies
14
Views
1K
Replies
1
Views
3K
  • Last Post
Replies
6
Views
2K
Top