- m6082552emf1
- E=V+r*I
- I=E/(R+r)
- V=I*R
- I=(E/r)-(1/r)*V
- R=independent variable
- V=X_axis=independent var.
- I=Y_axis=dependent var.
- Y_intercept=E/r
- slope=-1/r
- r=-1/slope
- E=X_intercept=Y_intercept*r
- spreadsheet_Excel data analysis
- m6082552emf1.xls
spreadsheet and vbscript physics
A1 | B1 | C1 |
x | y=5+2*x | y_excel_code |
0 | 5 | =5+2*A3 |
1 | 7 | =5+2*A4 |
2 | 9 | =5+2*A5 |
3 | 11 | =5+2*A6 |
4 | 13 | =5+2*A7 |
5 | 15 | =5+2*A8 |
X-AXIS | Y-AXIS | C9 |