Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default remove outliers in a time series

How can we remove outliers in a time series using MS Office Excel or Eviews.
What are different methods and how efficient those menthods are?
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5,939
Default remove outliers in a time series

Define outliers??? You can compare the value of any individual amount against
a stadard deviation of the series and exclude values based on 1 or more
deviations... Just remember that any time you exclude data you run the risk
of excluding value...
--
HTH...

Jim Thomlinson


"Shamil" wrote:

How can we remove outliers in a time series using MS Office Excel or Eviews.
What are different methods and how efficient those menthods are?

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Time Series and Creating data points within a series Cristal Excel Discussion (Misc queries) 2 November 30th 09 08:07 PM
Remove series from pivot chart Alexander Caravitis Charts and Charting in Excel 1 December 6th 08 05:33 AM
How do I remove series FrankE New Users to Excel 2 October 28th 07 08:00 PM
Remove Legend Series GregBausman Charts and Charting in Excel 1 March 1st 05 11:07 PM
need Thompson tau on Excel to remove outliers mike mostert Excel Programming 0 January 5th 05 06:09 PM


All times are GMT +1. The time now is 03:48 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"