# FORECAST.LINEAR

Spread for WinForms provides advanced software components that support Excel import/export, full cell customization, an extensive calculation engine with over 450 functions and more, all with zero dependencies on Excel.

## Content



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.