Spread Formula Reference
Formula Functions / Functions D to G / FORECAST.LINEAR
In This Topic
    FORECAST.LINEAR
    In This Topic

    This function calculates future value by using existing values.

    Syntax

    FORECAST.LINEAR(x, known_y, known_x)

    Arguments

    This function has the following arguments:

    Argument Description
    x Refers to the numeric data specyfing data point to predict a value for.
    known_y Refers to the numeric data (array) specifying known y-values.
    known_x Refers to the numeric data (array) specifying known x-values.

    Remarks

    This function predicts a new value on a linear basis. Hence, if the data follows seasonal variances, this function is not useful.

    Data Types

    Accepts only numeric data. Returns numeric data.

    Examples

    FORECAST.LINEAR( 7, B4:B8, C4:C8 )

    Version Available

    This function is available in product version 11.0 or later.