Probably more of an algebraic question than it is an Excel question, but if I have 8 quarters' worth of year-over-year growth rates, is there a way to back into quarterly growth rates? For example:
Quarter ------- YoY Growth Rate
Q1'00 ------- 9%
Q2'00 ------- 11%
Q3'00 ------- 13%
Q4'00 ------- 17%
Q1'01 ------- 15%
Q2'01 ------- 10%
Q3'01 ------- 6%
Q4'01 ------- 4%
Is there a way I can use this data in Excel to back into what the growth rate was from Q3'01 to Q4'01?
Quarter ------- YoY Growth Rate
Q1'00 ------- 9%
Q2'00 ------- 11%
Q3'00 ------- 13%
Q4'00 ------- 17%
Q1'01 ------- 15%
Q2'01 ------- 10%
Q3'01 ------- 6%
Q4'01 ------- 4%
Is there a way I can use this data in Excel to back into what the growth rate was from Q3'01 to Q4'01?