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
    Thanks.
     
Know someone interested in this topic? Share this thread via Reddit, Google+, Twitter, or Facebook




Similar Discussions: Excel, help with if statement
  1. I need help with Excel (Replies: 2)

Loading...