Technical note: Apache 4.0.1 uses semi-colons instead of commas in formulas. With a few exceptions, Microsoft Excel can also generate the results in this text book. Given an 'out-of-the-box' installation of a spreadsheet, course alumni, or for that matter any reader of this text, should be able to generate and use the statistics introduced by this text.

Course alumni should not feel that they cannot 'do' statistics because they lack a special add-in or dedicated package function that may require administrative privileges to install. Course alumni and readers of this text are most likely to encounter default installations of spreadsheet software without such additional software. The text does not use any add-ins, add-ons, statistical extensions, or separate dedicated proprietary statistical packages. Both Calc and Gnumeric are open source, cross-platform software and can be downloaded from their respective web sites. This statistics text utilizes /Apache Calc and Gnome Gnumeric to make statistical calculations and box plots.

Hypothesis testing against a known population mean.

Introduction to the normal distribution.

Keeping worktimes, often in combination with the application of changing hourly rates is a ticklish thing, and not at all easily done with spreadsheet as soon as primages or work-times spanning more than one calendaric day occur. In fact you would need to also define what’s 'Morning’ or ‘Afternoon’ exactly, and to check for compliance of the input with the definition … (See the clumsy attempt to do so exemplified by the 13/24 in my formula.) He (f/m) would inevitably use helper variables and control structures. No general purpose programmer would use that kind of bloated expressions.

Nonetheless we should pursue clearer formulae and a structure of the sheets allowing for helper columns making everything easy. In addition you should consider to read my answer in this thread.Įdit 1 giving the amendment announced in my comment on the “I-don’t-know-answer”: In addition you should return a clear error message for the ‘Total’ column if there was an error with one of the parts. Concerning the afternoon part the situation is the same. You returned the empty string instead of a numeric resut then.

You took precautions concerning the morning part to avoid gravely misleading results.

Openoffice calculate hours from time