Mastering Outliers in Data Analysis: A Practical Guide Using Excel and R

by Duncan Williamson

This book has been written for Excel users who are accountants, managers, sales people, HR managers, bookkeepers … who has an interest in and uses statistics or data analytics as part of their daily work. That is, not deep and detailed statisticians but people, like me, who know they need to learn how to use statistics and are prepared to learn how to do so.

- Motivation and goals for writing the book
Identifying outliers and anomalies is something we need at least from time to time. After all, not all data sets contain a King Kong sized outlier, do something so outrageously large that it’s obviously an outlier.

There are many times in our statistical life that we are working on data and while they appear to be reasonably consistent data, there is the feeling or some evidence that some of the values are much larger than or much smaller than the others. These are possible outliers. Identifying outliers is something we should be comfortable with and this short book has the aim of helping you with that.

- Target audience
As I mentioned in the previous section, I was thinking of financial and non financial mangers when I wrote this that is mangers who are numerate and who are used to dealing with data from a variety of courses. Moreover, they are users of statistics who need some help in working at a level of detail that is just above the basic.

This structure provides a comprehensive guide, starting with basic concepts and gradually moving to more advanced topics, along with practical examples and real-world applications. It ensures that the book is accessible to beginners while still being valuable to more experienced readers.

156 pages, Kindle Edition

Published July 24, 2024

About the author

Duncan James Williamson was a Scottish storyteller and singer, and a member of the Scottish Traveller community. The Scottish poet and scholar Hamish Henderson once referred to him as "possibly the most extraordinary tradition-bearer of the whole Traveller tribe."

Williamson is reputed to have been born in a bow-tent on the banks of Loch Fyne, near the village of Furnace in Argyll, to Jock Williamson and Betsy Townsley, and was one of 16 children. He learned his repertoire of stories and songs from family, and other members of the Traveller community. His illiterate father was a basketmaker & tinsmith, and insisted that his children get an education, sending Williamson to school in Furnace. Like other Scottish travellers, the Williamson family lived in a fairly large tent during the winter months and took to the roads for the summer, walking from camping place to camping place and picking up seasonal work as they went. At age fourteen, he was apprenticed to a stonemason and dry stane-dyker. A year later, he left home with an older brother, travelling all over Argyll and Perthshire. He worked as a farm labourer, and later as a horse dealer. He was married to his first wife, Jeannie Townley (a distant cousin) in 1949 and had seven children together. Jeannie died in 1971.

On 22 February 1977, Williamson married the American-born musicologist/folklorist Linda Headlee, with whom he had two children. For the first four years of their marriage they lived in a tent, following which they lived in a cottage in Fife. It was largely through her that Duncan came into demand as a storyteller in Scottish schools, as well a featured performer at storytelling festivals both in the UK and abroad.

Williamson's life on the road in his teens and as a young married man is recounted in his oral autobiography, The Horsieman: Memories of a Traveller 1928-1958. From early on he developed a zest for storytelling as well as a love for the conviviality that attends "having a crack" (trading talk with friends or companions). His repertory of songs and stories continued to expand throughout his life, particularly after he gained entry to the world inhabited by folklorists by taking part in Scotland's folksong and storytelling revivals during the 1960s, 1970s, and 1980s.

In 1967 Williamson met the travellers' rights activist Helen Fullerton, a collector of traditional folktales, who had previously recorded his mother and siblings in 1958. Fullerton told another collector, Geordie MacIntyre, about Williamson, with MacIntryre making further recordings, also in 1967. In 1968, Williamson performed at the Blairgowrie Folk Festival.

Thanks chiefly to Linda's skill in editing his tape-recorded performances, a number of Duncan's stories came into print during his lifetime. A few audio recordings of his songs and stories have been issued commercially as well. Many more recordings remain in storage in personal or public archives, including the Sound Archive of the Department of Celtic and Scottish Studies at the University of Edinburgh and the Archive of Folk Culture at the Library of Congress, Washington DC.

Williamson's talents as a storyteller are celebrated in several books written by specialists in Scottish tradition and the art of oral narrative.