multiple indipendent variable for linear regression in Google Sheets
05:47 02 Jul 2020

in google sheets i got error when i try to make a linear regression with multiple (2) indipendent variables.

A         B       C

field1  field2  field3
33         2    580
33         3    1245
33         4    1156
33         5    3535
33         6    4976
33         7    3050
33         8    5779

my code is

=LINEST(C2:C8;A2:B8;1)

and the error is #NUM! --> Result was not a number.

Another error that came out is #N/A --> Cannot perform regression in LINEST due to linearly dependent variables.

what i'm writing wrongly?

https://support.google.com/docs/answer/3094249?hl=en

Here google sais that If known_data_y is a one-dimensional array or range, known_data_x may represent multiple independent variables in a two-dimensional array or range where:

LINEST(known_data_y, [known_data_x], [calculate_b], [verbose])

google-sheets linear-regression google-sheets-api