LINEAR1

Sheet1

Y=C+K*X
LINEAR1
INPUT C=
10
y_intercept
INPUT K=
5
slope
X
Y=C+K*X
Y_CODE
0
10
 =$B$2+$B$3*A5
1
15
 =$B$2+$B$3*A6
2
20
 =$B$2+$B$3*A7
3
25
 =$B$2+$B$3*A8
4
30
 =$B$2+$B$3*A9
5
35
 =$B$2+$B$3*A10
intercept
10
 =intercept(B5:B10,A5:A10)
slope
5
 =slope(B5:B10,A5:A10)
rsq
1
 =rsq(B5:B10,A5:A10)
physicsmatayom_link

Sheet2

Sheet3