I have six data points and need to calculate growth along a varying growth curve. My data is:
Year 2008 amount = 60
Year 2009 amount = 200
Year 2010 amount = 360
Year 2011 amount = 570
Year 2012 amount = 855
Year 2013 amount = 1,195
I know that year 2008 is made up of Q3 = 25 and Q4 = 35.
I am trying to break the yearly amounts down to quarterly amounts. Each quarter amount must be greater than the previous quarter. Assume exponential growth from 1 year to the next.
What would be the formula to calculate Q1, Q2, Q3, and Q4 for 2009 so that all for quarters equal 200?