Basic business statistics using excel
Course Summary
Do you need to interpret and produce reports that provide basic summary statistics and charts? In this self-directed, online course, you will learn about which charts and statistics are most appropriate to display in relation to your particular data.
The course will use example data for the purposes of both demonstrations and exercises, offering you an opportunity to learn by doing as well as developing an understanding of the underpinning theory. The course will also provide an introduction to advanced statistical methods to give you an understanding of other analytical tools that are available.
NOTE: This is a self-directed course delivered online. Please use the token code to register.
This course is funded by the 2014-2020 European Structural and Investment Fund as part of the Advancing Manufacturing Challenge Fund.
The course is divided into the following parts.
- Data and variables
- Graphs and charts
- Summary statistics
- Summary tables
- Summary of Parts A-D
- Awareness of further concepts
By taking part in this course, participants will:
- Understand essential concepts in summary statistics and common options for graphically displaying data and relationships between variables
- Gain confidence, through practice, in interpreting and presenting summary statistics and graphical displays that are typically found in business reports and publications
- Practice using Excel to produce summary statistics, tables, and graphs, including using pivot tables where needed
This course is aimed at all levels of professional and administrative staff who need to interpret and produce basic summary statistics and charts in business reports and documents. The course assumes no prior knowledge of statistics, however, some experience of using Excel is assumed.
This course is being delivered in partnership with the University of Strathclyde and will feature Ian Dwyer from the Department of Mathematics and Statistics.
Dates & Venues
| Date | Available now |
|---|---|
| Location | Self-directed online learning |
| Duration | 1 hour approximately |
| Cost | Free |
| Course token | Please use code: AMCFSTATS22 |
In collaboration with
Funded by
