Statistical graphing in spreadsheets

Abstract

Spreadsheet program such as Microsoft Excel™ is one of the most useful software packages for doing simple statistical analysis. However some commonly used statistical techniques are not implemented in it. In particular some useful visualisation methods are not included in the chart wizard. In this article, the procedures to create box and whisker plot, q-q plot and the graphs of step functions using spreadsheets is described.