My Math Forum  

Go Back   My Math Forum > College Math Forum > Real Analysis

Real Analysis Real Analysis Math Forum

LinkBack Thread Tools Display Modes
October 19th, 2012, 08:07 AM   #1
Joined: Oct 2012

Posts: 1
Thanks: 0

Rolling 3 months YOY data to Monthly YOY data

Hi Guys,

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.

Kind regards,
lumpa is offline  

  My Math Forum > College Math Forum > Real Analysis

data, monthly, months, rolling, yoy

Search tags for this page
Click on a term to search for related topics.
Thread Tools
Display Modes

Similar Threads
Thread Thread Starter Forum Replies Last Post
Modelling Data Help! jimmy_neutron987 Algebra 5 February 18th, 2013 10:52 AM
Data Analysis DataGeek Real Analysis 1 January 25th, 2013 03: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

Copyright © 2019 My Math Forum. All rights reserved.