Instructions:
1. Import your Excel file from the Table Checker, OR enter values manually below.
2. Select which columns to use for x and y axes.
3. Click Plot Graph to see your data on the O-Level grid.
4. Click two points on the graph to draw your line of best fit.
5. Enter gradient triangle coordinates and your calculated gradient.
6. Click Check to verify.
Import Data from Excel
Import an Excel file. Row 1 = column headings, Row 2 onwards = data. Select which columns to plot as x and y.
No file selected
Select columns for graph axes:
Axis Labels
Axis Scales (leave blank for auto-scale)
x-axis
y-axis
Data Values
Pt
x values
y values
Your Graph (click two points on the graph to draw line of best fit)
Data points (×)
Your line
Best fit line
Anomalous point
Click two points on the graph to draw your line of best fit.
Model Graph (program's suggested scale)
Gradient & Y-Intercept Calculation
Enter the two points you used from your line (not data points) to calculate the gradient, your calculated gradient, and y-intercept.