LINEAR1

Sheet1

Y=C+K*X
Linear1
2/9/12 8:11
INPUT C=
10
y_intercept
INPUT K=
10
slope
X
Y=C+K*X
Y_CODE
0
10
 =$B$2+$B$3*A5
1
20
 =$B$2+$B$3*A6
2
30
 =$B$2+$B$3*A7
3
40
 =$B$2+$B$3*A8
4
50
 =$B$2+$B$3*A9
5
60
 =$B$2+$B$3*A10
intercept
10
 =intercept(B5:B10,A5:A10)
slope
10
 =slope(B5:B10,A5:A10)
rsq
1
 =rsq(B5:B10,A5:A10)
0

Sheet2

parabolar

Sheet3