Growth rates question

[valenc]

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?

 

[Asman_Kei]

I do not think this is possible. Below are two scenarios where the YOY growth rates match the numbers above, but the Q3'01 to Q4'01 quarterly growth rate differs:

Scenario 1 Scenario 2 Quarter Revenue Revenue YoY Q1'99 10000.00 10000.00 Q2'99 10200.00 10200.00 Q3'99 10400.00 10400.00 Q4'99 10850.00 10800.00 Q1'00 10900.00 10900.00 9% Q2'00 11322.00 11322.00 11% Q3'00 11752.00 11752.00 13% Q4'00 12694.50 12636.00 17% Q1'01 12535.00 12535.00 15% Q2'01 12454.20 12454.20 10% Q3'01 12457.12 12457.12 6% Q4'01 13202.28 13141.44 4% <colgroup><col><col span="2"><col></colgroup><tbody> </tbody>

<colgroup><col><col><col></colgroup><tbody>
</tbody>

Quartery Growth between Q3'01 and Q4'01 is:
Scenario 1	5.98%
Scenario 2	5.49%

<colgroup><col span="2"></colgroup><tbody>
</tbody>

Q3'01 is dependent upon Q3'00 and Q3'99, and is independent of any other quarter. Same goes for Q4'01 - dependent upon Q4'00 and Q4'99.

At least this is how it seems to me. I may be wrong as I usually don't do this sort of analysis.