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
×
  1. Home
  2. Search

Refine search

Refine search

Access:
Content type:
Publication date:
Apply   From and To filters
Subject: Show more
Journals Show more
Publishers: Show more
Societies Show more
Series: Show more
Collections: Show more

Actions for selected content:

Select all | Deselect all
  • View selected items
  • Export citations
  • Download PDF (zip)
  • Save to Kindle
  • Save to Dropbox
  • Save to Google Drive

Save Search

You can save your searches here and later view and run them again in "My saved searches".

Please provide a title, maximum of 40 characters.
Cancel
×

1 results

  • 8 - Using Excel to Present and Analyse Data

  • Les Kirkup, University of Technology, Sydney
  • Book:
    Experimental Methods for Science and Engineering Students
    Published online:
    24 August 2019
    Print publication:
    05 September 2019, pp 168-184

  • 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.