Launched: Standard Deviation Formulas

Every so often, while reviewing our code as part of a bigger project, we’ll see something that jumps out to us and says, “Hey, with a few tweaks, you could open up a bunch of new possibilities for Coda Makers.” That’s more or less how we uncovered the capabilities to release our new StandardDeviation() and StandardDeviationPopulation() formulas for you today!

While we recognize everyone who uses Coda wasn’t clamoring for statistics functions in their docs, we wanted to release this update once we made some quick changes to enable it for those Makers who have been interested in using Standard Deviations in their docs.

A quick note on the difference between the two formulas:

  • StandardDeviation() assumes you are working with a sample from a larger population, and want to use the sample to estimate the standard deviation of the population. It divides by n - 1 in its calculation.
  • StandardDeviationPopulation() assumes you are working with the exhaustive population, and so divides by n in its calculation.

For a longer note on the difference between the two formulas, we’d have to invite you to some rigorous discussion on one of our internal Slack threads! If you’d like to learn more about the difference in functions without the color commentary from our CEO and data scientists, our friends at Stack Overflow have a nice write-up that is probably a quicker, smoother read.

Curious how the formulas look in action? Here they are used side-by-side on the same data set:

If you’d like to learn more about Coda Formulas, check out coda.io/formulas, join us for “Formula Fitness” webinars on our CrowdCast, or review past episodes on our YouTube Channel.

And stay tuned to this space ー we’ve got some big updates coming your way soon!

15 Likes

Nice! But… after 6 months of very extensive use of Coda, I spend still everyday 10 minutes working arround from European notation and formats into the US-Coda-tables. And back!!!

Last week we started to build important files and docs back into excel, lots of frustration!!!

Really think coda is great, but in this stage too dangerous for European users, since the date and euro value formats keep change into other meanings and summaries… We can not rely on the correctness of our docs. Certainly when I copy the data back into Google Sheets or Excel.

So please work urgently on these issues and an immense bunch of users will be kept for coda and made happy!

Greetz

TY

5 Likes

This is a super super nice feature :heart_eyes:
Thanks for keeping the Monday Update tradition :heart:

1 Like

Love the statistics formulas! You keep making it better thank you for the continual improvement :smile:

1 Like

Hi @Lucas_Branchesi,

Can you try refreshing your tab and let me know if you are still seeing that.

Jason

1 Like

It worked refreshing, thanks Jason!

1 Like

Then, if you copy the table to an email (for example) it return to this format: m/d/yyyy even if I have set it to ISO format (like it because you know, international), very headache.