Hi, I need some help to calculate zero crossing rate from an accelerometer signal, consists of x-axis, y-axis and z-axis. This is how the signal looks like in the excel column:
time x-axis y-axis z-axis
0.1 0.6752 -9.7479 -0.3893
0.2 0.7108 -9.7429 -0.4957
0.3 0.7303 -9.7720 -0.4763
....
.... until 200 rows
I want to find zero crossing rate for each row above. It means that everytime the signal changes value, it will be detected as 1. I'm not really sure how to do this in excel. Can anyone help me? Thank you.
time x-axis y-axis z-axis
0.1 0.6752 -9.7479 -0.3893
0.2 0.7108 -9.7429 -0.4957
0.3 0.7303 -9.7720 -0.4763
....
.... until 200 rows
I want to find zero crossing rate for each row above. It means that everytime the signal changes value, it will be detected as 1. I'm not really sure how to do this in excel. Can anyone help me? Thank you.
