Search found 3 matches

by mcline
Wed Dec 03, 2008 6:47 am
Forum: Data Manipulation
Topic: Calculating weighted average of a time period
Replies: 5
Views: 14484

Re: Calculating weighted average of a time period

This does help, thank you for the assistance.
by mcline
Tue Dec 02, 2008 4:27 pm
Forum: Data Manipulation
Topic: Calculating weighted average of a time period
Replies: 5
Views: 14484

Re: Calculating weighted average of a time period

Thanks for this method, it works very well. I just wish there was some inherent way to calculate this directly. The workfile I am working with has about 2000 series in it and having to create an intermediary series for each just clutters things up a bit.
by mcline
Tue Dec 02, 2008 2:19 pm
Forum: Data Manipulation
Topic: Calculating weighted average of a time period
Replies: 5
Views: 14484

Calculating weighted average of a time period

Is it possible to convert data from monthly frequency to annual frequency, but employing a weighted average rather than just a simple straight average of the twelve values? If not, is there some kind of workaround that is possible? The root of my problem is that I need to calculate an annual average...

Go to advanced search