4 Replies Latest reply on Apr 17, 2013 11:13 PM by Daniel Huedig

    How can I create a CAGR with data set up with the time period set up as a column?

    Catherine Deutsch

      I'm hoping someone might be able to help me write a formula to calculate CAGR.   The data is set up in the format below, and the goal is to create a calculated field where the output = CAGR % for 2007 - 2010.   It might be important to note that the data set contains more years of data than just 2007 to 2010, but i'm interested in creating CAGRs for fixed windows of time.  We would sometimes display this CAGR figure at the school level, and sometimes in aggregate.   Any ideas about how to write this formula are very much appreciated!

       

      School

      Year

      % students

      A

      2007

      40

      A

      2008

      45

      A

      2009

      46

      A

      2010

      49

      B

      2007

      50

      B

      2008

      51

      B

      2009

      52

      B

      2010

      52

      C

      2007

      60

      C

      2008

      64

      C

      2009

      65

      C

      2010

      67