(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?
(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.
Hi Guys,
I have a set of data which has daily and seasonal cycle and expands over ten years. I need to remove erroneous values using the rolling average of 5 pints at a time +/- 3 standard deviations. I might end up using more points for the rolling average (maximum of 24 values which represent the whole day) till I get something that just eliminates the wrong values. Also the +/- 3 standard deviations might be replaced by +/- 2 standard deviations as it suites my work.
Essentially I want to remove outliers based on a rolling average principle (averaging the whole sample would dampen the cycles I have)….
Can anyone suggest how to do this in Microsoft Excel?
Ideally, the method should show me the points it identifies as outliers before just deleting them.
Thank you,
Regards,
Abhilash
Printer-friendly version
Send to friendEmail: PPadmin@planningplanet.com
Replies