3 Replies Latest reply on May 18, 2016 2:02 AM by Jessica Fan

    Standard deviation of a year on year calculation

    ben.ellis

      I would like to know how to calculate the standard deviation of a year on year increase in client revenues.

       

      Each client is broker down by type. Corporate etc.

       

      I would like to take the peer average which is the average increase in Revenues between last year YTD compared with current YTD by type.

       

      so steps would be:

       

      Calculate the peer average increase YoY % for Corporates: 15% for e.g.

       

      I would then like to be able to calculate the Standard deviation for all corporate clients so that I could see all clients that are within 1 standard deviation etc and what are the outliers and plot them in a graph, showing average, standard deviation above and below bands and plot the clients.

       

      Whenever I try to do this I always get the aggregation error that other posts have mentioned previously.

       

      Could anyone help with an approach to do this? Much appreciated.