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 to a contiguous region."
I just need to exclude one center block from the regression analysis.
It works only with such a formula ($D$2:$G$16), but it is necessary that such an area be selected, as described above.
How to do it?
2 Replies
- 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
