|October 19th, 2012, 08:07 AM||#1|
Joined: Oct 2012
Rolling 3 months YOY data to Monthly YOY data
I'm sorry if I'm not posting this problem under the correct topic.
I'm trying to break down a time series of "Rolling 3 month average" year over year growth numbers into monthly YOY numbers but i'm having some trouble doing that.
Basically I want to calculate the implied monthly Year over Year change for the most recent datapoint when the only number I get is the Rolling 3 month year over year growth.
I have attached a sheet with the example. I want to identify the implied values in cells BR2, BR5 and BR6 based upon the value in BR4.
If I havent expressed myself clearly enough please ask for more details.
|data, monthly, months, rolling, yoy|
|Search tags for this page|
Click on a term to search for related topics.
|Thread||Thread Starter||Forum||Replies||Last Post|
|Modelling Data Help!||jimmy_neutron987||Algebra||5||February 18th, 2013 11:52 AM|
|Data Analysis||DataGeek||Real Analysis||1||January 25th, 2013 04:04 PM|
|Data Plotting Help||TranzRail||New Users||6||October 8th, 2009 06:43 PM|
|Analyzing a Set of Data||minicoop503||Algebra||1||September 8th, 2009 03:06 PM|
|How to regress actual data towards projected data.||BigLRIP||Advanced Statistics||1||May 18th, 2009 10:01 AM|