Statistical graphing in spreadsheets

Zhong Guan

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.

Full Text:

PDF