Detrend Function
I try to use the detrend function and input a 32-cell array as x.
However, the output is a single value instead of a 32-cell array. Did I do something wrong please?
I try to use the detrend function and input a 32-cell array as x.
However, the output is a single value instead of a 32-cell array. Did I do something wrong please?
Comments
The detrend function returns the detrended time series as an array. Please, see this article for arry-type excel functions:
https://support.numxl.com/hc/en-us/articles/207840813-What-does-Function-XYZ-is-an-array-function-mean-
You would need to select the target cells-range and place the results there (see the article above)
Please sign in to leave a comment.