Ask Your Question

How to calculate a multiple regression in calc? [closed]

asked 2017-07-20 17:39:02 +0200

galaxian gravatar image

updated 2020-08-02 12:12:57 +0200

Alex Kemp gravatar image

I have three, possibly four, independent variables, and one dependant variable. What is the best way to calculate their multiple regression please? Has anyone created a template for this yet? Thanks.

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2020-08-02 12:13:08.726783

1 Answer

Sort by » oldest newest most voted

answered 2017-07-20 20:12:42 +0200

Lupp gravatar image

You may search for "how to use linest for multiple regression". Most results will refer to Excel. Don't worry. Mathematics behind the LINEST function is most likely the same.
If you are interested to get an insight you can start reading the subchapter
6.18.41 LINEST of OpenDocument-v1.2-part2.
Specialise to the case Y : 1 column, X : multiple columns; equal number of rows.

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2017-07-20 17:39:02 +0200

Seen: 2,344 times

Last updated: Jul 20 '17