CODEWITHSUNDEEP
regressionlinear-regressionmissing-datalibreofficelibreoffice-calc
patapouf_ai
patapouf_ai

Reputation: 18693

Libreoffice Calc doing a linear regression with missing data values

In Libreoffice calc, if you try to do a linear regression where some of the data is missing it just returns an Error Err:502. Is there a way for me to ask Calc to just drop/ignore the datapoints with missing values, without me having to explicitly delete the datapoints with incomplete values (since I want to keep this information)?

While doing the linear regression that doesn't seem to be an option. It would be easy to make an extra line with a boolean to say whether to use that datapoint in the linear regression or not, but then I don't know how to tell the linear regression to only use data based on the boolean. Is there for example a way to hide some of the columns from the linear regression based on a boolean?

enter image description here

In the above image, I would want to omit column D from the linear regression be I don't want to delete that column because I don't want to loose the data it contains.

Any help welcome.

Upvotes: 1

Views: 442

Answers (1)

Jim K
Jim K

Reputation: 13790

On another sheet, possibly hidden, you could use formulas to copy over the data to include. Then do the regression on that sheet and output the regression results back to the main sheet.

Sheet2.A1 to D4

These formulas could no doubt be modified based on the boolean row if you want to do that rather than simply specifying directly in the formula which columns to use.

Upvotes: 1

Related Questions