Data Handling and Spreadsheets Skills Part 2

Introduction

In this tutorial: Introduction > Getting Started > Your skills rating > Save the File > Calculating Basic Statistics > Sort and Filter > Standard Deviation > Apparent Motion Scatter Graph > Skills list > Summary
All pages in this tutorial

Course Outline

In the previous session, you saw how Excel can be used to manipulate and present data, and create charts and two-axes graphs. In this session, we shall look at how you can use Excel to analyse data by calculating basic statistics, using Standard Deviation calculations as error bars, adding a line of best fit to a scatter graph, and sorting and filtering data.

Learning Outcomes

By the end of this session, you should be able to:

• Manipulate data on a spreadsheet, format it and analyse data using basic statistical functions;
• Create graphs from the data and manipulate and format the graph;
• Complete statistical comparisons or data manipulation functions in line with coursework requirements;
• Sort and filter data and amend it to make it more easily interpretable;
• Trouble-shoot your way through problems as they arise in Excel;
• Apply these tools effectively for your academic work.

Next page.