3 ms·
I think Zed Shaw should get off of his high horse. He knows a little about statistics, and think he knows plenty. A distribution that cannot go negative (a rea
by thethirdone 10y ago
I think Zed Shaw should get off of his high horse. He knows a little about statistics, and think he knows plenty.
A distribution that cannot go negative (a real world system), cannot be a normal distribution because normal distributions must extend infinitely in both directions. If your standard deviation is small enough though, a normal distribution can be a fitting model.
> Almost all of the queries performed great, except one query that had sub-second response on average, but a 60 second standard deviation!
If the average response is < 1 sec than a 60 second standard deviation means that many responses are being made before the query is sent.
Moving from just using averages and thinking about properly measuring is a good start, but assuming that all distributions are normal is nearly as bad.
- timmaxw 10y ago> If the average response is < 1 sec than a 60 second standard deviation means that many responses are being made before the query is sent. Imagine if 99.99% of queries take 1 millisecond, and the remaining 0.01% of queries take 6000 seconds. Then the mean is 0.6010 seconds and the standard deviation is 59.997 seconds. (Muphry's law strikes again...)