Topic 5: Excel Data Analysis Video Presentations
| Site: | QMplus - The Online Learning Environment of Queen Mary University of London |
| Module: | SEF PGT Welcome Week and Pre-Sessional - January 2025 |
| Book: | Topic 5: Excel Data Analysis Video Presentations |
| Printed by: | Guest user |
| Date: | Sunday, 1 June 2025, 10:16 AM |
Description
Now you have been introduced to the topic of Data Analysis with Excel, watch these video presentations which demonstrate the application of Statistical Functions, the installation and use of Analysis Toolpak, how to perform and interpret a Regression Analysis, and an example applying the Data Analysis skills used in this section.
1. Excel 5.1 Statistical Functions
Transcript: Slides
In this video Claudio Vallar explains some of the most commonly used statistical functions (average, median, mode, minimum, maximum, percentile, quartile, variance, covariance and correlation).
2. Excel 5.2 Analysis ToolPak
Transcript: Slides
In this video Claudio Vallar demonstrates how to install and use Analysis ToolPak.