 |
Froglet
Registered: Jun 2011
Posts: 151 |
09-27-11 11:37 PM
Hi,
I was wondering if there were any gurus that could help me w/ something.
I wanted to plot data points in excel and generate a chart. For example a 12- month rolling average of some sort.
More so, when people say seasonally adjusted, how would you adjust the data? For example, job numbers, and holidays being temporary jobs, how would you remove it?
Thanks
|
| |
|
Edit/Delete • Quote • Complain |
sametrade
Registered: Sep 2011
Posts: 32 |
09-28-11 01:21 AM
You can find one by posting an ad in your local University's campus newspaper. Pay them $8/hr and they will flock to you.
|
| |
|
Edit/Delete • Quote • Complain |
trefoil
Registered: Mar 2007
Posts: 3383 |
09-28-11 02:27 AM
Seasonal adjustment software from the census: http://www.census.gov/srd/www/x12a/
This uses something called auto-regressive integrated moving average. This is used all over the world by all kinds of institutions to do seasonal adjustments, and it's completely free.
I tried it a while back for someone else, seems to work OK. You have to read the manuals carefully to get anywhere, not the most user-friendly package in the world. But as I recall, once you get to the point where you're able to use it, it outputs some pretty neat graphs and such.
|
| |
|
Edit/Delete • Quote • Complain |
Froglet
Registered: Jun 2011
Posts: 151 |
09-28-11 07:56 PM
Quote from trefoil:
Seasonal adjustment software from the census: http://www.census.gov/srd/www/x12a/
This uses something called auto-regressive integrated moving average. This is used all over the world by all kinds of institutions to do seasonal adjustments, and it's completely free.
I tried it a while back for someone else, seems to work OK. You have to read the manuals carefully to get anywhere, not the most user-friendly package in the world. But as I recall, once you get to the point where you're able to use it, it outputs some pretty neat graphs and such.
I would have to buy the software?
|
| |
|
Edit/Delete • Quote • Complain |
Froglet
Registered: Jun 2011
Posts: 151 |
09-28-11 08:00 PM
The question I have is, what exactly is seasonally adjustment in a time series? What is removed?
Is creating a simple average in excel hard? I've been using the excel tutorials and trying to chart housing prices for the year on a chart and show an average.
GOsh, I hate statistics. ugh.
|
| |
|
Edit/Delete • Quote • Complain |
Soon2Bgreat
Registered: Apr 2006
Posts: 500 |
09-28-11 09:34 PM
Quote from Froglet:
Is creating a simple average in excel hard?
Just use the Average function. If your time series is in Column A and you want a 3 period MA, insert a formula into Cell B3 that says "=AVERAGE(A1:A3)".
You can then copy/paste that formula down all of Column B to create a rolling moving average.
|
| |
|
Edit/Delete • Quote • Complain |
| Receive
an email whenever a new post is added to this thread by subscribing
to it. |
|
|
|
|
