SVG xy scattergraph template

This template is designed to be used in conjunction with a generating spreadsheet.

SVG xy scatter graph of image depth versus object depth major grid lines axes data points as squares linear regression line text layers Image versus object depth If y-intercept = 0: use LINEST image depth ί (cm) object depth δ (cm) y-axis labels 0.5 0.7 1.0 1.2 1.5 1.7 1.9 2.2 2.4 2.7 2.9 x-axis labels 0.3 0.5 0.6 0.8 0.9 1.1 1.3 1.4 1.6 1.7 1.9

Data table

image depth ί (cm)object depth δ (cm)
0.30.5
0.51.0
1.01.4
1.42.4
1.92.9

Typically used functions in conjunction with regressions

Linear Regression Functions
Statistic or ParameterMath symbolStat symbolOpenOffice
Slopemb=SLOPE(y-data;x-data)
Interceptba=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)