This template is designed to be used in conjunction with a generating spreadsheet.
Data table
| image depth ί (cm) | object depth δ (cm) |
|---|---|
| 0.3 | 0.5 |
| 0.5 | 1.0 |
| 1.0 | 1.4 |
| 1.4 | 2.4 |
| 1.9 | 2.9 |
Typically used functions in conjunction with regressions
| Linear Regression Functions | |||
|---|---|---|---|
| Statistic or Parameter | Math symbol | Stat symbol | OpenOffice |
| Slope | m | b | =SLOPE(y-data;x-data) |
| Intercept | b | a | =INTERCEPT(y-data;x-data) |
| Correlation | r | =CORREL(y-data;x-data) | |
| Coefficient of Determination | r2 | =(CORREL(y-data;x-data))^2 | |
| Slope for intercept forced equal to zero | =LINEST(y-data;x-data;0) | ||