INTERCEPT Function in Apple Numbers: Best-Fit Line Y-Intercept

=INTERCEPT(y-values, x-numbers)

Both arguments are mandatory. No optional arguments or defaults are documented. Apple’s INTERCEPT help requires the collections to have the same size. Its second argument is explicitly named x-numbers, whereas Apple’s SLOPE uses x-values; that is a material type restriction, not a decorative difference. Exact Apple INTERCEPT reference.

Put y first, x second, just as for SLOPE. The corresponding CORREL function labels its arrays x then y. Changing the columns changes which variable the regression is trying to predict.

These formulas are documented in Apple Formulas and Functions Help 15.4 (reviewed 2026-10-12). This is a documentation-version attribution, not a claim that the function was introduced in Numbers 15.4 or behaves identically on every older Mac, iPhone, iPad, or iCloud release. Apple Numbers native execution across platforms was not available for this review. Apple’s Numbers release documentation should be checked for availability in a particular installation.

The worked formulas are written for an English locale with a period as the decimal separator; arguments are separated with commas. Apple explicitly instructs that if the decimal separator is a comma, use a semicolon as the manually typed argument separator, for example a two-argument formula =FUNCTION(A2:A6;B2:B6) instead of =FUNCTION(A2:A6,B2:B6). The formula separator is not a data-range separator: A2:A6 still uses a colon. Function names are case-insensitive. See Apple’s Functions overview.

The simple ranges in the examples are in one Numbers table. Numbers supports table-qualified and sheet-qualified references when formulas refer to other tables or sheets; use Numbers’ cell-reference picker when working across tables instead of copying Excel’s Sheet!A2:A6 syntax. See Apple’s cell-reference guide.

1. Create a new Numbers table named Observations with at least six rows and four columns. Use row 1 as the header row. Enter X (hours) in A1 and Y (tasks) in B1. The observations are illustrative only; they are not evidence that hours cause task output.
2. Enter the following values as numeric cells, without typing hours or tasks into the number cells. Leave C2:C6 blank initially.
3. Enter the example formula in an unused cell such as D2, outside its two source ranges. Format the result cell to show enough decimal places if needed.

Every expected result below comes from independent calculation or Apple’s published worked example, not from execution in Apple Numbers.

First calculation: expected intercept of 2.2

=INTERCEPT(B2:B6,A2:A6)

Expected result: 2.2. With x̄ = 3, ȳ = 4, and a checked slope of 0.6, the regression intercept is a = ȳ − b×x̄ = 4 − (0.6 × 3) = 2.2. This is a mathematical calculation, not a result observed inside Numbers.

1. Recreate the equation of the line

Use the following in separate unused cells, not within A2:B6:

The fitted equation is ŷ = 2.2 + 0.6x. At x=3, its expected prediction is 4; the actual table observation is y=5. A fitted line summarizes trend rather than passing through every observed point.

For a one-cell formula predicting the outcome at x=6, use:

=INTERCEPT(B2:B6,A2:A6)+SLOPE(B2:B6,A2:A6)*6

Expected result: 5.8. The observed x-range is 1–5, so x=6 is outside the measured sample and the prediction is an extrapolation, not established performance.

2. Why changing the x origin moves the intercept

Enter 11, 12, 13, 14, 15 as numeric cells in C2:C6 (a second x-series formed by adding 10 to each original x). Keep the B column unchanged and enter:

=INTERCEPT(B2:B6,C2:C6)

Expected result: −3.8, despite the underlying relationship being unchanged. The transformed x-series has the same slope 0.6, but its zero point moved, so the line written in terms of C becomes ŷ = −3.8 + 0.6C. This teaches why intercepts must always be interpreted with their x-units and zero points.

3. Check a perfect declining line

Replace B2:B6 with numeric 8, 6, 4, 2, 0; retaining x=1..5 gives the fitted line ŷ = 10 − 2x. The independently calculated expected INTERCEPT is 10, with a SLOPE of −2. Restore the original observations when finished.

4. Apple’s heating-oil sample

Apple’s INTERCEPT help shows a ten-row oil-price/thermostat-setting example where =INTERCEPT(B2:B11,A2:A11) is approximately 78. Recomputing from the ten published pairs gives about 77.6805673923, which rounds to 78. Because x=0 is outside the example’s observed price range, Apple describes that result as extrapolating beyond the highest hypothetical setting. These ten records are not the five example rows on this page.

• Different numbers of x and y observations: Apple requires collections of the same size; B2:B6 with A2:A5 does not meet that requirement. Pair each row correctly.
• Non-numeric independent inputs: Apple’s x-numbers argument expressly requires number values. If your x column contains formatted date/time or duration values, do not assume SLOPE’s more permissive description applies to INTERCEPT. Consider a properly documented, explicit numeric transformation after reviewing its units.
• All x values are identical: If there is no change in x, the best-fit slope and corresponding intercept are mathematically not uniquely defined. The specific Numbers error text is not confirmed by a native run.
• Too few usable paired numeric points: One pair alone does not determine the least-squares line used here. This tutorial does not invent an Apple-specific error code for that situation.
• Intercept taken as an observation: The value at x=0 can be unobserved (or physically impossible); always state the actual range of x and whether extrapolation is involved.
• Surprising changes after unit conversion: Changing x from hours to minutes modifies its coefficient; changing the x origin also changes intercept. This is not necessarily a formula error.
• Blanks, text and Booleans: The INTERCEPT help page does not document all alignment and omission behavior in detail. Enter complete numeric pairs for reproducibility and validate missing-data behavior natively before publishing stronger claims.
• Cross-table or locale errors: Use a valid Numbers table reference, not copied Excel Sheet!B2:B6 notation, and a semicolon argument separator when comma decimals are in use.

• Microsoft Excel: INTERCEPT is documented as INTERCEPT(known_y's,known_x's) for a numeric best-fit line. The y-then-x order matches Numbers. Excel’s specific error messages and missing-data handling are not automatically Numbers rules.
• Google Sheets: INTERCEPT likewise uses INTERCEPT(data_y,data_x) with dependent values first.
• Important type limitation: Apple’s INTERCEPT specifies that its x-numbers collection must contain numbers. This differs in wording from Apple’s SLOPE documentation, which also allows appropriate date/time and duration input collections. Do not assume a cross-application import will preserve every input type or conversion.

• AVERAGE for means of the source series
• CORREL for Pearson correlation
• SLOPE for the fitted line rate of change

Official Apple documentation, accessed 2026-10-12: function reference; Functions overview; table references; Numbers release documentation. The help URL specifies documentation version 15.4; no first-supported-release claim is made.

• DOCUMENTATION CHECK: Function purpose, names, argument order, allowed value types and documented limitations were transcribed from Apple, then paraphrased. There is no claim that Excel or Sheets documentation proves Numbers behavior.
• INDEPENDENT CALCULATION: Five-row worked examples and secondary computations were checked using transparent arithmetic (sum of centered products and sums of squared deviations). Expected results are not observed application outputs.
• APPLE PUBLISHED EXAMPLE: The heating-oil example is described as Apple’s example, with independently reproduced arithmetic; the quoted approximate output is not a native test performed here.
• NOT VALIDATED: Apple Numbers application execution, screenshots, regional-device testing and older-release behavior.

If a real Numbers installation disagrees, keep the discrepancy visible for investigation instead of hiding an error behind IFERROR.