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) |