The most interesting thing is a new diagram: https://www.av8n.com/physics/img48/spindown-omega-z1.png
which is zoomed-in enough to show the stair-steps associated
with the excessive roundoff error. The actual noise in the
sensor is /at least/ one order of magnitude smaller than the
roundoff error. This is the hallmark of a badly-designed
In addition to the 20-per-second data analyzed previously, I
carried out the same sort of analysis for the 100-per-second
data. The diagrams for the latter are in the spreadsheet file
only; I didn't save them as separate .png files.
More finely-spaced t values are a step in the right direction,
but 100 per second does not solve the fundamental problem. Not
even close. The important concept is, we don't necessarily need
more points; what we urgently need is two or three more orders
of magnitude more resolution on the timestamps on the points
we already have.
More resolution is synonymous with less roundoff error.