Função do Google Sheets

FORECAST

Calculates or predicts a future value by using existing values along a linear trend.

Gerar uma fórmula com IA A mesma função no Excel

Esta função funciona no Google Sheets da mesma forma que no Excel — mesma sintaxe e argumentos.

Sintaxe

FORECAST.LINEAR(x, known_ys, known_xs)

The FORECAST.LINEAR function uses linear regression to predict a value based on historical data. It is the updated version of the legacy FORECAST function, providing better compatibility and clarity for linear trend analysis.

Argumentos

xobrigatórioThe data point for which you want to predict a value.
known_ysobrigatórioThe dependent array or range of data.
known_xsobrigatórioThe independent array or range of data.

Exemplos

=FORECAST.LINEAR(6, {10, 20}, {1, 2})

Resultado: 60

Predicts the y-value for x=6 based on the linear trend of points (1,10) and (2,20).

Perguntas frequentes

What is the difference between FORECAST and FORECAST.LINEAR?

They are functionally identical; FORECAST.LINEAR is the modern naming convention introduced to improve clarity.

Funções relacionadas

TREND LINEST SLOPE