Skip to main content Accessibility help

We use cookies to distinguish you from other users and to provide you with a better experience on our websites. Close this message to accept cookies or find out how to manage your cookie settings.

Close cookie message
×
Hostname: page-component-78c5997874-8bhkd Total loading time: 0 Render date: 2024-11-03T02:43:10.273Z Has data issue: false hasContentIssue false

8 - Using Excel to Present and Analyse Data

Published online by Cambridge University Press:  24 August 2019

Les Kirkup
Les Kirkup
Affiliation:
University of Technology, Sydney
Get access

Summary

Pencil, paper and a scientific calculator are often adequate when analysing small amounts of data. However, spreadsheets are favoured especially when large amounts of data are involved. This chapter explores some of the basic features of spreadsheets and show how they may be applied to the analysis and presentation of experimental data. The Excel spreadsheet program by Microsoft is highlighted due to its availability, power, and longevity. Specific features of Excel are discussed such as the LINEST function for fitting equations, and the Analysis ToolPak which contains a number of useful analysis tools.

Keywords

Excelspreadsheetsspreadsheet basicsstatistical functionsLINEST functionhistogramx-y graphAnalysis ToolPak
Type
Chapter
Information
Experimental Methods for Science and Engineering Students
An Introduction to the Analysis and Presentation of Data
 , pp. 168 - 184
Publisher: Cambridge University Press
Print publication year: 2019

Access options

Get access to the full version of this content by using one of the access options below. (Log in options will check for institutional or personal access. Content may require purchase if you do not have access.)

Save book to Kindle

To save this book to your Kindle, first ensure [email protected] is added to your Approved Personal Document E-mail List under your Personal Document Settings on the Manage Your Content and Devices page of your Amazon account. Then enter the ‘name’ part of your Kindle email address below. Find out more about saving to your Kindle.

Note you can select to save to either the @free.kindle.com or @kindle.com variations. ‘@free.kindle.com’ emails are free but can only be saved to your device when it is connected to wi-fi. ‘@kindle.com’ emails can be delivered even when you are not connected to wi-fi, but note that service fees apply.

Find out more about the Kindle Personal Document Service.

Available formats
×

Save book to Dropbox

To save content items to your account, please confirm that you agree to abide by our usage policies. If this is the first time you use this feature, you will be asked to authorise Cambridge Core to connect with your account. Find out more about saving content to Dropbox.

Available formats
×

Save book to Google Drive

To save content items to your account, please confirm that you agree to abide by our usage policies. If this is the first time you use this feature, you will be asked to authorise Cambridge Core to connect with your account. Find out more about saving content to Google Drive.

Available formats
×