iWorks Numbers
How to Plot Line of Best Fit
1) Enter your columns of X and Y
data.
2) Use the functions SLOPE(Y-data,X-data) and INTERCEPT(Y-data,X-data) to generate the formula for the line of best fit.
3) Use the resultant formula to calculate a second set of X and Y data but only for two points outside the range of your actual data. Have multiple entries for the two points so that you have the same total number of data points.
4) Graph both sets of X and Y data on the same chart.
5) Use the shape tool to manually draw the line of best fit between the two end points.
2) Use the functions SLOPE(Y-data,X-data) and INTERCEPT(Y-data,X-data) to generate the formula for the line of best fit.
3) Use the resultant formula to calculate a second set of X and Y data but only for two points outside the range of your actual data. Have multiple entries for the two points so that you have the same total number of data points.
4) Graph both sets of X and Y data on the same chart.
5) Use the shape tool to manually draw the line of best fit between the two end points.
