Dismiss Notice
Join Physics Forums Today!
The friendliest, high quality science and math community on the planet! Everyone who loves science is here!

Excel, help with if statement

  1. May 12, 2009 #1
    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.

    Attached Files:

    Last edited: May 12, 2009
  2. jcsd
  3. May 12, 2009 #2
    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

    Attached Files:

  4. May 14, 2009 #3
Know someone interested in this topic? Share this thread via Reddit, Google+, Twitter, or Facebook

Similar Threads - Excel help statement Date
Sumproduct help in Excel Jun 12, 2016
Excel - linest function with blanks help Feb 13, 2015
I need help with Excel Dec 12, 2014
Help with MS Excel equation May 27, 2014
Help reading an Excel file with Matlab Dec 2, 2013