Thanks,
femr2, for the Excel trick - I'll figure out whether LibreOffice can do the same ^^
WDC: I seem to remember those words from waaaaaaaaaay back when - I was a straight-A+ student in math from first grade to university (business school), but all that was over 20 years ago, never practiced most of that math since
DaveThomas, I don't want to do a curve fit, I want to do an exact fit of three parameters for 3 data points. So yes, the Excel method seems to be the one to try. (I can imagine that there are Excel functions that do the kind of matrix operations that WDC talks about)
The idea is about the following: David Chandler (NIST and femr2, too) has a set of measured data points t
(1-n)|s
(1-n), with s being the drop distance in ft or m. One could pick any three of these points, assume constant acceleration, and compute s
0, v
0 and a
avg for that triplet. For example, if I picked the following data points:
t (s)|s (m)
1,2|-28,2384
1,8|-44,1225
2,4|-63,5364
then the algorithm should give me
s
0 = -7,0596 m
v
0 = -11,766 m/s
a
avg = -9,805 m/s
2That would mean an acceleration of almost exactly g (NYC).
(I know this because I computed the s-values with these parameters

)
Now the question I would ask of C7 is: How uncertain are the s-values? Expressed as a +/- deviation; this could be derived from pixel resolution and other considerations. Or perhaps a guess. C7 should have a rough idea of what this uncertainty is, at a minimum (I am sure the pixel resolution error can be determined from the data itself, as there distances seem to be spaced at whole multiples of some fraction of a meter). If, for example, C7 thinks that the distances are measured with a margin of error of +/- 0.2 m, then each of the 3 data points could deviate by as much, and that would change the computed average acceleration. In the case of monotonously negative velocity, I would get the maximum (negative) acceleration a
max from
t (s)|s (m)
1,2|-28,2384
-
0.2
1,8|-44,1225
+
0.2
2,4|-63,5364
-
0.2
and the minimum (negative) acceleration a
min from
t (s)|s (m)
1,2|-28,2384
+
0.2
1,8|-44,1225
-
0.2
2,4|-63,5364
+
0.2
If I can find any three data points within Chandler's data set where the interval [a
max,a
min] does not include -g, and both exceed g, then that would mean that, even according to C7's assumptions of what Chandler's margin of error may be, his data proves a period where the average acceleration was >g.
Several disclaimers in order:
- Sorry if I am confusing people with mins and maxs of negative values, I am imprecise in my wording, but I hope you get my drift
- I am assuming that the t-values are super precise - at a frame rate of 29.97 Hz (or what is it), t-values such as "1.2 s" are of course imprecise, too; but evidently Chandler didn't care
- The whole excercise will be rated a success if C7 admits that he doesn't have Chandler's data and/or admits he has not slightest clue what margin of error Chandler's data has; both would render any claims about what is within or outside the margin of error invalid.
- I could do the same excercise with femr2's data. I am sure that it has been debated elsewhere what margin of error is inherent in his method, and that such estimates have been derived by someone somewhere. But that would be going too far at this moment. My goal really is to have C7 commit to certain quantitative claims about the quality of Chandler's data.