+ Reply to Thread
Results 1 to 2 of 2

How to detrend time series, and how to use moving average

  1. #1
    Registered User
    Join Date
    North dakota
    MS-Off Ver
    Excel 2010

    How to detrend time series, and how to use moving average

    I'm new to this forum and I'm also a noob at Excel, so I struggle with some problems which may be simple for you but hard for me.

    I am supposed to detrend a time series (excel file of the time series is attached, but I have no clue how to do it.
    I am also supposed to use a moving average of the values but this is also something I don't understand how to do.

    These problems have bugged me for several hours now so I would be very thankful if someone knew how to solve them. I also have more questions regarding the time series but I think it would be enough to start with these to questions. Below I have added the teachers explanation (which I did not understand), if it makes it easier for you to understand what I mean.

    Thank you.

    "First detrend the unemployment series. For the unemployment series, we will use a moving average of the previous 21 quarters values. That is use excel’s “=average(b1:b22) to obtain the trend value for quarter 23. Then drag the command down to find the rest of trend values. Take the difference from the actual value and you will have the percentage point deviation from trend. You should see a negative value during recessions."
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    Childers QLD, Australia
    MS-Off Ver
    Excel 2003, 2007 & 2013

    Re: How to detrend time series, and how to use moving average


    I am not 100% sure what you may be looking for.

    I believe that I have added the formula's as you discribed and achieved a Trend Value.

    However, I am unsure about the Quarters 21 and 23 you refered to.

    Anyway see if this helps any.


    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] How to apply a 30 second moving average to data with inconsistent time intervals
    By WE5T in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-13-2012, 05:58 AM
  2. How to add moving average trendline for summation of 2 data series
    By ramyaarian in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 10-08-2012, 01:38 PM
  3. [SOLVED] Moving average/average function/adjustable length
    By Lv27 in forum Excel General
    Replies: 3
    Last Post: 08-16-2012, 09:43 AM
  4. Charts 5 day moving average, 10 day moving average
    By monalisa in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-28-2008, 09:50 PM
  5. Moving average of a moving average in the same cell
    By philroberts1983 in forum Excel General
    Replies: 8
    Last Post: 09-16-2008, 07:36 AM


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1