Perform Calculations on Data in A Table and Create a New Table

I have Time (from 0-20 secodns in increments of 0.05sec) and Accerometer Data recorded at each 0.05 second interval in a Table and I need to calculate the average standard deviation of the accelrometer data in one second and put it in a new table. Im not sure of the most effiecient way to do this. Any help would be greatly appreciated!

Ex of Data in Table -T

[Isabelle Museck]

I meant the std deviation per second not average std deviation

Answer 1

[Steven Lord]

I'd likely turn your Time column into a duration array (using the seconds function) then convert your table into a timetable using table2timetable. Once you've done that you can use retime on the timetable to change it to a secondly basis (using the newTimeStep input argument value 'secondly') with @std as the aggregation method (that is in fact the example given for the function handle syntax.)

You could use the "Aggregate Timetable Data and Calculate Mean Values" example on the retime documentation page as an example, just using 'secondly' and @std instead of 'hourly' and 'mean'.

[Isabelle Museck]

Thank you so so much!