General Topics
Markets
Technical Topics
Brokerage Firms
Community Lounge
Site Support

# Any statistician or math wiz or excel gurus? Need help w/ data charting.

Discussion in 'Data Sets and Feeds' started by Froglet, Sep 27, 2011.

1. ### Froglet

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

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.

3. ### 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.

4. ### Froglet

I would have to buy the software?

5. ### Froglet

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.

6. ### Soon2Bgreat

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.

7. ### trefoil

Quoting from myself: "...and it's free."

8. ### stock777

if you're still at the point of asking "Is creating a simple average in excel hard" you are wasting your time.

better you find existing charts and use them

9. ### Froglet

To simplify, I have a lemonade stand w/ yellow, white, pink versions for the year.
jan2011 - 3 White, 3 pink, 1 Yellow

etc etc

I have already plotted the points on a line chart, but wanted to use the trendline function, but was stuck w/ the MOVING AVERAGE PERIOD PART.

What are they referencing when it comes to period? How can I throw in a moving average?

10. ### Froglet

Not bad, I managed to get the function working.

I guess my question is, how would you folks chart qtr to qtr change?

Would you take average of jan,feb, march vs apr, may june average? or just end of march and june balance?

#10     Oct 4, 2011
ET IS FREE BECAUSE OF THE FINANCIAL SUPPORT FROM THESE COMPANIES: