Documentation/Calc Functions/TREND

From The Document Foundation Wiki
Jump to navigation Jump to search


Under construction.
For now, see the system Help files.

Function name:





Returns values along a linear trend.


TREND(DataY; DataX; NewDataX; LinearType)



DataY represents the Y Data array.

DataX (optional) represents the X Data array.

NewDataX (optional) represents the array of the X data, which are used for recalculating values.

LinearType (optional). If LinearType = 0, then lines will be calculated through the zero point. Otherwise, offset lines will also be calculated. The default is LinearType <> 0.

In the LibreOffice Calc functions, parameters marked as "optional" can be left out only when no parameter follows. For example, in a function with four parameters, where the last two parameters are marked as "optional", you can leave out parameter 4 or parameters 3 and 4, but you cannot leave out parameter 3 alone.

More explanations on top of this page.

Additional details:


Select a spreadsheet range in which the trend data will appear. Select the function. Enter the output data or select it with the mouse. Mark the Array field, click OK. The trend data calculated from the output data is displayed.

Related LibreOffice functions:

ODF standard:

Equivalent Excel functions: