DECOMPOSE

Trend & Season Decomposition in Google Sheets.

Sample Usage

DECOMPOSE(A1:A100, {7, 168})

Syntax

=DECOMPOSE(data_y, array_season)

  • data_y - The range representing the array or matrix of dependent data.

  • array_season - An array of seasonal periods.

Notes

  • Any text in the encountered in the value will throw an error.

Examples