writer
5,435
edits
Changes
Jump to navigation
Jump to search
Line 21:
Line 21: + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
Manuals/calci/INTERCEPT (view source)
Revision as of 08:38, 31 December 2013
, 08:38, 31 December 2013→Examples
==Examples==
==Examples==
DATA1 DATA2
4 12
5 20
2 15
10 11
INTERCEPT(B5:B8,C5:C8)=10.13265306
DATA1 DATA2
25 10
-12 15
-9 -40
30 52
18 36
INTERCEPT(A2:A6,B2:B6)=4.754939085
{| class="wikitable"
|+Spreadsheet
|-
! !! A !! B !! C !! D!! E
|-
! 1
| 4 || 5 || 2 ||10 ||
|-
! 2
| 12 || 20 || 15 || 11 ||
|-
! 3
| 25 || -12 || -9 ||30 ||18
|-
! 4
| 10 ||15 || -40 ||52 ||36||
|-
! 5
| || || || ||
|}