|
A1 |
B1 |
C1 |
|
input c= |
5 |
intercept |
|
input m= |
2 |
slope |
|
x |
y=m*x+c |
y_CODE |
|
0 |
5 |
=$B$3*A5+$B$2 |
|
1 |
7 |
=$B$3*A6+$B$2 |
|
2 |
9 |
=$B$3*A7+$B$2 |
|
3 |
11 |
=$B$3*A8+$B$2 |
|
4 |
13 |
=$B$3*A9+$B$2 |
|
5 |
15 |
=$B$3*A10+$B$2 |
|
intercept(C)= |
5 |
=INTERCEPT(B5:B10,A5:A10) |
|
slope(m)= |
2 |
=SLOPE(B5:B10,A5:A10) |
|
rsq=m*(1/m) |
1 |
=RSQ(B5:B10,A5:A10) |
http://sathaporn.exteen.com/images/physicsmatayom_linear1.gif
http://sathaporn.exteen.com/images/linear/linear11.gif
Physicsmatayom_LINK(Spreadsheet_Online)
http://physicsmatayom.podbean.com
http://spreadsheets.google.com/pub?key=pU2ZoVWxdOsyp8OeGyNBbIw
http://www.editgrid.com/user/physicsmatayom/LINEAR1
edit @ 12 Oct 2007 18:39:11 by physicsmatayom
edit @ 15 Oct 2007 19:35:35 by physicsmatayom
