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



      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!