My Math Forum  

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

Real Analysis Real Analysis Math Forum


Reply
 
LinkBack Thread Tools Display Modes
October 19th, 2012, 09:07 AM   #1
Newbie
 
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,
Magnus
lumpa is offline  
 
Reply

  My Math Forum > College Math Forum > Real Analysis

Tags
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 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 07:43 PM
Analyzing a Set of Data minicoop503 Algebra 1 September 8th, 2009 04:06 PM
How to regress actual data towards projected data. BigLRIP Advanced Statistics 1 May 18th, 2009 11:01 AM





Copyright © 2017 My Math Forum. All rights reserved.