Management Research: Applying the Principles © 2015 Susan Rose, Nigel Spinks & Ana Isabel CanhotoĢ Why use Excel? With so many specialist software packages available, why use Excel for statistical analysis? Convenience and cost are two important reasons: many of us have access to Excel on our own computers and do not need to source and invest in other software. There are also various websites, including Microsoft’s Office Support area () that offer advice to get you started. Alternatively, you may find that Excel training or support material is available in your institution. If you have never used Excel, there are many reasonably-priced textbooks to get you started.

how to create worksheets, enter data, use formulae and functions, create charts (graphs), print and work, etc.). The guide assumes that you are already familiar with the basics of using Excel (e.g. Most of the functionality referred to in the guide is also available in earlier and later versions, although the user interface has changed somewhat. The guide is not written for a specific version of Excel although it includes screenshots for Excel 2010. Further guides give information on the use of Excel to apply various analysis techniques discussed in Chapter 13. It covers some of the key features of Excel that are particularly useful when doing a research project. 12ġ Introduction The aim of this short guide is to provide an introduction to using Microsoft Excel (hereafter: Excel) for quantitative data analysis within the context of a business and management research project.

8Īppendix B: Loading and using the Data Analysis ToolPak. 7Īppendix A: Using Excel statistical functions. Quantitative data analysis tools in Excel. An introduction to using Microsoft Excel for quantitative data analysis Contents 1

Data analysis excel template