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])