In order to work with gradients and straight lines successfully, a good understanding of coordinates and linear graphs is needed. The gradient of a line is calculated by dividing the difference in the ...

Excel's intercept function takes the data points that define a line on a graph and calculates the y value for the point on the graph where x is equal to zero.

Watch this video to find out how the equation 𝑦 = 𝑚𝑥 + 𝑐 can be used to work out the gradient and 𝑦-intercept on a straight line graph.