Login

Welcome, Guest. Please login or register.

November 01, 2025, 10:03:04 am

Author Topic: Time series smoothing data calculator?  (Read 12031 times)  Share 

0 Members and 1 Guest are viewing this topic.

Green

  • Victorian
  • Trailblazer
  • *
  • Posts: 43
  • Respect: 0
  • School: Wellington Secondary College
Time series smoothing data calculator?
« on: October 29, 2013, 01:34:00 pm »
0
i having trouble getting the concept of smoothing. Is it possoble do it on calculator?
if you cannot please explain how do it by hand with table and graph

Damoz.G

  • Guest
Re: Time series smoothing data calculator?
« Reply #1 on: October 29, 2013, 01:36:37 pm »
0
No, you can't do it on your CAS, except for like finding the average of data by doing it manually.

Could you may be post an example of a question so that I can explain it for you? :)

Green

  • Victorian
  • Trailblazer
  • *
  • Posts: 43
  • Respect: 0
  • School: Wellington Secondary College
Re: Time series smoothing data calculator?
« Reply #2 on: October 29, 2013, 01:44:05 pm »
0
2011 vcaa exam 1 question 13
2012 vcaa exam 1 question 9

Damoz.G

  • Guest
Re: Time series smoothing data calculator?
« Reply #3 on: October 29, 2013, 01:58:49 pm »
0
Okay, 2012 Exam 1, Q9.

Its asking for 5-Median Smoothing, so immediately the first thing that comes to my mind is that we need to get rid of 2 "dots" from EACH SIDE of the Graph when smoothing. If it was 3-Median Smoothing, we would get rid of 1 "dot" from each side. So for this question, there should be nothing for January and February as well as November and December. IMMEDIATELY, Options A, C and E are crossed off because it does not satisfy this. So we're left with B and D. :)

The first 5 numbers on the graph are: 4,7,5,2,7
Now we put them in order from lowest to highest: 2,4,5,7,7
Therefore, what's our median for these first 5 numbers? 5. Check that 5 is in both Options B and D for March, and it is.

Then move onto the next 5: 7,5,2,7,6. In order from lowest to highest: 2,5,6,7,7. Median is therefore 6. Immediately, we can then cross out Option D, because for April the Median Value is roughly 5.5≠6.

Therefore, we can straight away say that the correct Option is B. :)

If it wasn't this obvious, then you would just keep repeating this same process until you get the correct answer. I don't think VCAA would make you Smooth data until the end of the Graph to get the correct answer because it would take a while, but they ARE allowed to do it. :)

Hope this helps! I'll let you try 2011 Exam 1, Q13. Have a go at doing it.

Green

  • Victorian
  • Trailblazer
  • *
  • Posts: 43
  • Respect: 0
  • School: Wellington Secondary College
Re: Time series smoothing data calculator?
« Reply #4 on: October 29, 2013, 02:08:38 pm »
0
what difference between mean and median smoothing odd and even numbers pf it?

Green

  • Victorian
  • Trailblazer
  • *
  • Posts: 43
  • Respect: 0
  • School: Wellington Secondary College
Re: Time series smoothing data calculator?
« Reply #5 on: October 29, 2013, 02:09:58 pm »
0
i always have trouble choosing which value to smooth for instance 2011 exam question  dont you choose values each side or next two values when it saus two point mean?

Damoz.G

  • Guest
Re: Time series smoothing data calculator?
« Reply #6 on: October 29, 2013, 02:11:53 pm »
0
what difference between mean and median smoothing odd and even numbers pf it?

Well, it will always tell you what number and if its Mean/Median Smoothing. e.g. 2 Mean Smoothing.

Mean is where you find the AVERAGE of the values, depending on the number in the Question.

Median is where you find the MIDDLE number of the values, depending on the number in the Question.

Damoz.G

  • Guest
Re: Time series smoothing data calculator?
« Reply #7 on: October 29, 2013, 02:18:35 pm »
0
i always have trouble choosing which value to smooth for instance 2011 exam question  dont you choose values each side or next two values when it saus two point mean?

When it says two-point moving mean with centering, you have to smooth and centre twice.

So find the Average of 2005 and 2006, and then 2006 and 2007. Then find the Average of the two numbers you get in order to obtain the answer for 2006.
(2,016,000+3,900,000)/2=2,958,000 AND (3,900,000+4,830,000)/2=4,365,000

Then Average of 2,958,000 and 4,365,000 = 3,661,500. Therefore, Option D is correct. :)

Green

  • Victorian
  • Trailblazer
  • *
  • Posts: 43
  • Respect: 0
  • School: Wellington Secondary College
Re: Time series smoothing data calculator?
« Reply #8 on: October 29, 2013, 02:20:03 pm »
0
yeah. But do you take values for either side when you doing mean. In 2011 question
do i take 2006 and 2007 and 2008
or 2005 2006 and 2007 that what i dont get

Damoz.G

  • Guest
Re: Time series smoothing data calculator?
« Reply #9 on: October 29, 2013, 02:21:39 pm »
0
yeah. But do you take values for either side when you doing mean. In 2011 question
do i take 2006 and 2007 and 2008
or 2005 2006 and 2007 that what i dont get


You take the average of 2005 and 2006 as well as the average of 2006 and 2007.

Once you have found those two, then you find the average of the two numbers you just found.

Green

  • Victorian
  • Trailblazer
  • *
  • Posts: 43
  • Respect: 0
  • School: Wellington Secondary College
Re: Time series smoothing data calculator?
« Reply #10 on: October 29, 2013, 02:25:14 pm »
0
say i was doing it wanted 3 mean? what values do i take?
if was medium is it the same?

sorry for asking all this questions
just smoothing is really fustrating

TrueTears

  • TT
  • Honorary Moderator
  • Great Wonder of ATAR Notes
  • *******
  • Posts: 16363
  • Respect: +667
Re: Time series smoothing data calculator?
« Reply #11 on: October 29, 2013, 03:33:44 pm »
+1
i having trouble getting the concept of smoothing. Is it possoble do it on calculator?
if you cannot please explain how do it by hand with table and graph
There are two very different concepts in time series analysis, one is smoothing, and the other is filtering. They are closely related but fundamentally different. I'll try illustrate what each of the two are.

Assume some model where , for , denotes the observation at time and then denotes the state at time . Let's look at the simplest model of all, the dynamic linear model (DLM). It is characterized by:

Observation (measurement) equation:
System (State) equation:

As you can see, the observation equation is the observed data value and noisy components. The state equation only consists of the underlying noisy components that drive the observed data. Now , and can all be vector valued. We assume that the DLM error terms and are distributed as:


where and are both symmetric variance-covariance matrices for and , respectively.

Also it is important to note that the error term at time t is independent of all information at earlier times. Formally, is independent of for .

Under the above assumptions, note the probability distribution of is completely characterized by , that is, . Similarly, . This result will be very useful in deriving the filtering and smoothing recursions later.

Note that we need to start off the process somehow, so assume .

Filtering

Filtering means we update the state at each , conditional on the data observed at time . More formally, we use to produce the updated (or filtered) state, . To do this, start off with and use the state equation to predict the one step ahead state distribution , with and .

Next, note the joint distribution of can be viewed as a function of so that:


This implies that:


Now conditioning on , we have the filtered state of as:



Smoothing

Smoothing means to find the probability distribution of given ALL information, that is, finding . Can see you the subtle differences? Filtering means to find while smoothing is conditioned on (CAPITAL t). To prove the smoothing procedure is much much harder than filtering, so I won't bother, but if you're interested you can take a look at: http://en.wikipedia.org/wiki/Kalman_filter#Fixed-lag_smoother



For your second query, I don't think there are any calculator packages that can do high-tech smoothing, it requires quite a bit of computing power depending on how much data you have. Also you would need to program a bit depending on what model you use. By hand, smoothing would probably take your forever, so unless you only have 2-3 datapoints to smooth (why would you smooth if you had that little data points anyway :P), then I'd use some computing software. I use R to implement smoothing. Here are some plots to illustrate the differences between filtering and smoothing. So I have data on the Nile river flow as follows:


The following shows the constant level DLM


Next we apply filtering!


The following shows the one step ahead prediction distribution


Finally, some summary statistics to compare




I forgot to mention, the filtered states are generally "wider" than smoothed states at the beginning of the procedure. Think about this intuitively. You have lots of data points, by conditioning on the first few, you're not gaining as much information as you would by conditioning on ALL data points (smoothing). Thus, your variance would be larger and hence, your one step ahead distribution will be less accurate. But as the series progresses, your filtered states will become better and better (conditioned on more information), in fact the last filtered state IS a smoothed state (since both are conditioned on all information). So the filtered state should "converge" to a smoothed state as you have more and more data.
« Last Edit: October 29, 2013, 04:14:05 pm by TrueTears »
PhD @ MIT (Economics).

Interested in asset pricing, econometrics, and social choice theory.

Damoz.G

  • Guest
Re: Time series smoothing data calculator?
« Reply #12 on: October 29, 2013, 03:35:35 pm »
+1
WOW, TT! That looks very complicated, even as a Methods student myself.

I think it would be quicker to do it by hand.......

TrueTears

  • TT
  • Honorary Moderator
  • Great Wonder of ATAR Notes
  • *******
  • Posts: 16363
  • Respect: +667
Re: Time series smoothing data calculator?
« Reply #13 on: October 29, 2013, 08:57:38 pm »
0
Also for anyone that's interested, I've attached a document (split into two parts due to attachment size), that goes into more detail of what I was describing. It has (and explains) the relevant R code that I utilized to generate the plots and the recursion procedure.
PhD @ MIT (Economics).

Interested in asset pricing, econometrics, and social choice theory.