Hello all! I am using my phone to do some physics experiments and have 2 columns "Time" and "Gyroscope z (rad/s)". When graphed - the data looks like this:
Screenshot.jpg
The periods are the time distance between each peak and each valley which I noted by drawing red squiggles (removing the first and last peak and valley will probably make the data more accurate as well).
I am trying to figure out a way to make excel show me the time intervals, the average of the top intervals, the average of the bottom intervals, the average of all intervals and the standard deviation. Is there a way to do this - I have to imagine there is... here is some sample data and I also attached the excel if anyone has an ideas.

Gyroscope rotation rate Z Axis.xls
Sample data:
Time (s) Gyroscope z (rad/s)
0.361541 -1.483920693
0.371584 -1.38446629
0.381626 -1.284553528
0.391669 -1.182614446
0.401712 -1.077048182
0.411755 -0.970735788
0.421798 -0.858052373
0.43184 -0.749362528
0.441883 -0.642088234
0.451926 -0.522797287
0.461969 -0.411610276
0.472012 -0.295833409
0.482055 -0.179829851
0.492097 -0.067679964
0.50214 0.054766327
0.512183 0.168873295
0.522226 0.281375617
0.532269 0.39608708
0.542311 0.50696671
0.552354 0.618393958
0.562397 0.730107188
0.57244 0.834602177
0.582483 0.943759263
0.592525 1.043138385
0.602568 1.144519687
0.612611 1.251484513
0.622654 1.343745828
0.632697 1.43744421
0.642739 1.528301954