Evidence comes in the form of qualitative or quantitative data about the world around you. It is not always obvious, however, how to structure, aggregate, analyse or interpret the data to help you make decisions. In this free course, you will look at how to use data to make decisions in a systematic way using Microsoft Excel.Microsoft Excel is a spreadsheet software that you will most likely encounter numerous times either in a professional context or outside the workplace. In this course you will explore its functions, which will enable you to analyse data and explore relationships between variables. You will learn to summarise, describe and visualise both univariate and bivariate data in tabular and graphical form. This OpenLearn course is an adapted extract from the Open University course B126 Business data analytics and decision making.
Overview
Syllabus
- 1 Excel spreadsheets
- 1.1 Using Excel
- 1.2 Opening an Excel file
- 1.3 Adding the Data Analysis ToolPak in Excel
- 1.4 Decimal points and dates
- 1.5 Using shortcut keys in Excel
- 1.6 Use of Excel spreadsheets
- 2 Univariate data visualisation
- 2.1 Frequency tables
- 2.2 Types of frequency distribution
- 2.2.1 Concepts involved in frequency tables
- 2.2.2 Ungrouped frequency distribution tables
- 2.2.3 Grouped frequency distribution tables
- 2.2.4 Relative frequency distribution tables
- 2.2.5 Cumulative frequency distribution tables
- 2.3 Histograms: a graphical visualisation of frequency tables
- 2.4 Frequency density
- 3 Bivariate data
- 3.1 Contingency tables
- 3.2 Scatter diagrams
Tags
Related Courses
Related articles
Reviews
1.0 rating, based on 1 Class Central review
4.3 rating at OpenLearn based on 17 ratings
-
Table used to download for practice already had the answers. No practical application applied: "This is how you find class intervals" ... why do I need this? How is this useful in the real world? This course teaches you how to manipulate the data but doesn't explain the real world application of this data manipulation rendering any context you could apply to your real job worthless. You could've watched a youtube video for 15 minutes on the shortcuts and gotten all the useful data this course provides in a fraction of the time.
