INTERCEPT : General Usage
1
data_Y
data_X
2
4
1
3
5
1.7
4
10
2.3
5
23
5
6
7
8
Result
Formula
9
-1.891067538
=INTERCEPT(A2:A5,B2:B5)
10
0
=INTERCEPT({2,4,6}, {1,2,3})
11