Forum Discussion
Regression analysis
Hello! Can't figure out how to do discontinuous regression analysis. I enter the formula ($ D$2:$D$16;$F$2:$G$16) into the input interval X, and he writes to me: "The interval must be a reference t...
I would suggest to create a separate area that serves as the input of your regression. In that area you only include the data you want to use for the regression.
I totally agree with JKPieterse suggestion.
But if you just don't want to create a new area you could try something like (Office365):
FILTER($D$2:$G$16;COLUMN($D$2:$G$16)<>5)
which is just like creating a new area, but virtually
