Manuals/calci/LINEST
Jump to navigation
Jump to search
LINEST(Y,X,C,stats)Where Y is the set of y-values and X is an optional set of x-values that in the relationship y = mx + b.
C is a logical value specifying whether to force the constant b to equal 0 and stats are a logical value specifying whether to return additional regression statistics.
This function calculates the k-th largest value in a data set.
· When there is only one independent x-variable, then the slope and y-intercept values directly by using the following formulas:
Slope:
=INDEX(LINEST(Y,X),1)
Y-intercept:
=INDEX(LINEST(Y,X) 2)
· The accuracy of the line is calculated by using LINEST.
Formulas:-
LINEST
Lets see an example,
LINEST(Y,X,C,Stats)
B C
1 0
9 4
5 2
7 3
=LINEST(B2:B5,C2:C5,FALSE)
=LARGE(B2:C6,8) is 5
Syntax
Remarks
Examples
Description
| Column1 | Column2 | Column3 | Column4 | |
| Row1 | 1 | 0 | ||
| Row2 | 9 | 4 | ||
| Row3 | 5 | 2 | ||
| Row4 | 7 | 3 | ||
| Row5 | ||||
| Row6 |
