Artículos con :
Cerrar
Changelog
Cerrar
Artículos con :
Cerrar
Pruébelo en la nube

TREND Function

The TREND function is one of the statistical functions. It is used to calculate a linear trend line and returns values along it using the method of least squares.

Syntax

TREND(known_y’s, [known_x’s], [new_x’s], [const])

The TREND function has the following arguments:

Argument Description
known_y’s The set of y-values you already know in the y = mx + b equation.
known_x’s The optional set of x-values you might know in the y = mx + b equation.
new_x’s The optional set of x-values you want y-values to be returned to.
const An optional argument. It is a TRUE or FALSE value where TRUE or lack of the argument forces b to be calculated normally and FALSE sets b to 0 in the y = mx + b equation and m-values correspond with the y = mx equation.

Notes

Please note that this is an array formula. To learn more, please read the Insert array formulas article.

How to apply the TREND function.

Examples

The figure below displays the result returned by the TREND function.

TREND Function

Volver a la página anterior
Probar ahora gratis Pruebe y tome su decisión No se necesita instalar algo para
ver todas las posibilidades en la acción