Excel functions / Statistics

FORECAST function

Predicts a y value for a new x from the best-fit straight line through known data.

Syntax

=FORECAST(x, known_y, known_x)

Arguments

When to use it

FORECAST predicts a y value for a new x from the best-fit straight line through your known data. In one function it does INTERCEPT + SLOPE × x.

The arguments are the new x first, then the known y values, then the known x values. Excel 2016 and later also call it FORECAST.LINEAR; both names work.

Examples

  1. Sales for a planned ad spend

    ABCD
    1Ad spendSales
    210120276.6
    315150
    420168
    525205
    630222

    In D2: =FORECAST(40, B2:B6, A2:A6) → 276.6

    Try this example

  2. Next month from a monthly series

    ABC
    1MonthRevenue
    2142
    3245
    4344
    5449
    6552
    7650
    8
    9753.6
    108

    In C9: =FORECAST(A9, $B$2:$B$7, $A$2:$A$7) → 53.6

    Lock the known ranges with $ before copying it down for more months.

    Try this example

Common mistakes

FORECAST in other languages

Excel shows function names in its own language. In these languages it also puts a semicolon between arguments where English has a comma.

Translate a whole formula

Also written as FORECAST.LINEAR.

Try FORECAST in the playground

Practise it

Related functions