2 Replies Latest reply on Mar 9, 2016 9:17 AM by Yan Wu

    Calculating Mean, Standard Deviation in time series, key value pair data

    Yan Wu

      Hello,

       

      I have time series data in name value pair format. 

       

      The data has 3 sites - A, B, C.  The data is daily for December 2015.

       

      For each site, A, B, C, I would like to calculate,:

      1) Average

      2) Standard Deviation

      3) Flag that says it's +/- 1 standard deviation away from the mean

       

      I cannot figure out how to add those columns into the table.

       

      I've attached what I'd like to do in a sample in Excel.

       

      Anyone have any ideas?  Thank you so much!