Regression analysis

%3CLINGO-SUB%20id%3D%22lingo-sub-1978268%22%20slang%3D%22en-US%22%3ERegression%20analysis%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1978268%22%20slang%3D%22en-US%22%3E%3CP%3EHello!%3CBR%20%2F%3ECan't%20figure%20out%20how%20to%20do%20discontinuous%20regression%20analysis.%3CBR%20%2F%3EI%20enter%20the%20formula%20(%24%20D%242%3A%24D%2416%3B%24F%242%3A%24G%2416)%20into%20the%20input%20interval%20X%2C%20and%20he%20writes%20to%20me%3A%20%22The%20interval%20must%20be%20a%20reference%20to%20a%20contiguous%20region.%22%3CBR%20%2F%3EI%20just%20need%20to%20exclude%20one%20center%20block%20from%20the%20regression%20analysis.%3CBR%20%2F%3EIt%20works%20only%20with%20such%20a%20formula%20(%24D%242%3A%24G%2416)%2C%20but%20it%20is%20necessary%20that%20such%20an%20area%20be%20selected%2C%20as%20described%20above.%3CBR%20%2F%3EHow%20to%20do%20it%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1978268%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1988445%22%20slang%3D%22en-US%22%3ERe%3A%20Regression%20analysis%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1988445%22%20slang%3D%22en-US%22%3EI%20would%20suggest%20to%20create%20a%20separate%20area%20that%20serves%20as%20the%20input%20of%20your%20regression.%20In%20that%20area%20you%20only%20include%20the%20data%20you%20want%20to%20use%20for%20the%20regression.%3C%2FLINGO-BODY%3E
Frequent Visitor

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 @Jan Karel Pieterse  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