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.
The University of Sydney acknowledges that its campuses and facilities sit on the ancestral lands of Aboriginal and
Torres Strait Islander peoples, who have for thousands of generations exchanged knowledge for the benefit of all.
Learn more
