Favorite functions: Simple statistics

There’s a lot of pretty amazing things that a trained statistician can tell about a set of numbers, given the right statistical tools. I, however, am not a trained statistician, and neither are most people.

For most people, there’s really only three things that they want to know about most things: how many, how much, and the average. Fortunately, in addition to a dizzying array of tools to perform higher level statistics, every spreadsheet will provide basic tools to answer these three questions. Continue reading Favorite functions: Simple statistics

Making geometric figures (a nifty trick with text orientation and cell merging)

Last week I promised that I’d discuss how to use text orientation in spreadsheets to make regular geometric figures.

To start off with, a regular geometric figure (also known as a regular polygon) is any figure where all the sides are the same length, and all the angles are the same size. A square is a regular polygon, but a rectangle isn’t because the sides aren’t all the same. Continue reading Making geometric figures (a nifty trick with text orientation and cell merging)