Can I Use an IF Statement for Regression in Excel?

Click For Summary
SUMMARY

Using an IF statement for regression analysis in Excel is not directly supported when filtering data. Instead, the recommended approach is to sort the dataset by the "Vacant" column and create a scatter plot for the subset where "Vacant = 1". This method allows for a clear visualization of the regression line, resulting in the equation Price = 69.9 * SQFT - 4793 for vacant houses. Excel's hands-on capabilities facilitate this process effectively.

PREREQUISITES
  • Familiarity with Excel's regression analysis tools
  • Understanding of scatter plots and data visualization techniques
  • Knowledge of basic Excel functions, particularly the IF function
  • Concept of filtering data based on specific criteria
NEXT STEPS
  • Learn how to create scatter plots in Excel for data visualization
  • Explore advanced regression techniques in Excel, such as using the Data Analysis Toolpak
  • Research filtering data in Excel using logical functions
  • Study the implications of regression equations in real estate pricing models
USEFUL FOR

Data analysts, real estate professionals, and anyone interested in performing regression analysis using Excel to evaluate housing prices based on specific criteria.

MaxManus
Messages
268
Reaction score
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.
 

Attachments

Last edited:
Physics news on Phys.org
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

Thanks.
 

Similar threads

MATLAB To what extent is the fit to experimental data good?
  • · Replies 12 ·
Replies
12
Views
4K
Undergrad Linear regression, feature scaling, and regression coefficients
  • · Replies 8 ·
Replies
8
Views
3K
Simple overestimate of slope uncertainty in regression
  • · Replies 11 ·
Replies
11
Views
5K
Undergrad Coefficient sign flip in linear regression with correlated predictors
  • · Replies 13 ·
Replies
13
Views
5K
Undergrad What are the commonly used estimators in regression models?
  • · Replies 23 ·
Replies
23
Views
4K
Undergrad How do leaf nodes behave in regression decision trees?
  • · Replies 6 ·
Replies
6
Views
3K
Undergrad What is Nonlinear Least Squares in Regression Analysis?
  • · Replies 4 ·
Replies
4
Views
2K
What engineering and math features is Excel missing?
  • · Replies 17 ·
Replies
17
Views
4K
High School Comparing Approaches: Linear Regression of Y on X vs X on Y
  • · Replies 64 ·
3
Replies
64
Views
6K
Use linear regression to find Planck’s constant
  • · Replies 10 ·
Replies
10
Views
2K