**Have a Question?**

**Phone:** +1 (888) 427-9486

+1 (312) 257-3777

Contact Us

# TSADD

Returns an array of cells for the sum of two time series.

## Syntax

**TSADD**(

**X**,

**Y**)

**X**

is the first univariate time series data (a one dimensional array of cells (e.g. rows or columns)).

**Y**

is the second univariate time series data. If a single value is passed, it will be added to all observations in the first time series.

## Remarks

- The time series is homogeneous or equally spaced.
- The two time series have an identical number of observations and time order, or the second series contains a single value.
- In the case where the two time series are identically sized, the two series are added together point-by-point:

Where:

- is the sum time series.
- is the first time series.
- is the second time series.

- In the case where the second time series is passed as a single value (), this constant is added to all points in the first time series:

Where:

- is the sum time series.
- is the first time series.
- is a constant value.

- The returned array has the same size and time order as the first input time series.

## Files Examples

## References

- Hamilton, J .D.; Time Series Analysis , Princeton University Press (1994), ISBN 0-691-04289-6
- Tsay, Ruey S.; Analysis of Financial Time Series John Wiley & SONS. (2005), ISBN 0-471-690740