Add up pounds, shillings and pence, allow multiple items and conversion to post 1971 currency.

Until 1971 the UK used pounds (£), shillings (s) and pence (d). There were 12 pence in shilling. 20 shillings in a pound 240 pence in a pound. More about decimalisation can be found here http://en.wikipedia.org/wiki/Decimal_Day If basic arithmetic wasn’t enough of a problem, statistics must have been a nightmare. This excel spreadsheet enables the input of up to 300 prices in pounds, shillings and pence and calculates: The Total sum Mean average Standard Deviation Maximum Minimum Upper quartile Lower Quartile Median It also converts all the pounds, shillings and pence data into (today’s) decimal currency. This makes pre-1971 and post-1971 comparisons possible. (Full details of the mathematics behind this are in the Wikipedia article cited above). The excel side of things is a complicated and probably far more complex than it needs to be. Any improvements welcome.

Editable worksheets in basic quantitative methods aimed at undergraduate students of German or English Language.

Statistics for the Humanities is now available as an open access e-book (PDF format only at present). The book is aimed primarily at undergraduate humanities students, especially those who have not studied mathematics since the age of 16.