Forum Discussion

Anand272's avatar
Anand272
Copper Contributor
Mar 18, 2023

Average and Standard Deviation of a Time series

I have a dataset that measures the concentration of Particulates matter every min. I want to compute average and standard deviation of the concentration for each hour. 

 

  • JoeUser2004's avatar
    JoeUser2004
    Bronze Contributor

    Anand272 

     

    If there is some reason why AVERAGE and STDEV (STDEVP) does not work for you, please provide an explanation of why not, complete with numerical details.  Also, provide a numerical example that demonstrates the calculation that you require, perhaps using less data (but at least 3).

Resources