This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
This macro enables you to detect outlier data points by a variety of methods. You can identify, delete or modify the points. The macro is in beta and any feedback about the functions or how the macro works would be appreciated.
For outlier replacement, I have rarely seen routines that can replace the outlier with a "rolling avg" of the observations before/after the outlier itself.
Helpful when data series have trends or seasonal patterns.
