Microsoft's Excel software for Mac can execute a number of statistical functions, including finding the y-intercept of the line formed by a set of data points. Excel's intercept function.

To do so, isolate ‘y’ on one side of the equation as follows: y = ax + b. In this example, ‘a’ represents the slope, and ‘b’ is the y-intercept. 3. Using Points on the Graph to Calculate Y-Intercept.

The simplest way to find the x-intercept is by setting the function equal to zero and solving for x. This method works well for linear functions (such as y = mx + b) and many quadratic functions. For ...