Statistics with Numbers: This is how it works with Apple's spreadsheet

Numbers offers integrated functions for many calculations, so that they do not have to remember the underlying mathematical formulas. In this article we roughly mention the mathematical derivation, but you do not need to be more deeply known to mathematical knowledge to understand what is shown in the article. However, it does not work without the theory, because you need to know what information Numbers needs for the respective calculations. So that you can understand everything well, we offer about the here All examples for download to.

Formula or function?

Numbers seems to use the terms “formula” and “function” synonymously and inconsistently in some places. In the insertion menu there is talk of formulas, while the sidebar speaks of functions.

That was the reading sample of our Heise Plus article “Statistics with Numbers: This is how it works with Apple's spreadsheet”. With a Heise Plus subscription you can read and listen to the whole article.