Topic 5: Excel Data Analysis Video Presentations
Completion requirements
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).
