Course Overview
English, Filipino ∙ Self-paced ∙ 1 hour and 30 minutes
About the Course
Why would you want to take this course?
Because in any kind of knowledge work, you need to work with Data. And one of the fundamental steps to answer questions using data is with Statistics. Using Data Analysis Toolpak makes it easier.
Prerequisite Knowledge, Tools and Resources
Recommended Prerequisite Knowledge:
- Basic Statistics
- Hands on knowledge with Excel Formulas and Functions
Tools Needed:
- Excel 2013 and up
- Data Analysis Tool Pak Add In (Already included in the Excel)
- Exercise File so that you can follow along with the hands on
Course Objective and Outline
To give an introduction to the most useful Statistical Tools in Data Analysis Toolpak:
- Correlation
- Covariance
- Descriptive Statistics
- Histogram
- Moving Average
- Random Number Generator
- Rank and Percentile
- Sampling
To give a hands-on example on how to implement them in different scenarios and interpret the results
Target Participants
It is for all the interested individuals that want to know more about the overview of Statistics with Excel Data Analysis Toolpak and its relevance.
Certificate Requirements
- Completion of recorded webinar + quiz
- Pass the 10 item multiple choice with 80% mark
- Comment your feedback to the main page of the course
https://asklexph.com/courses/statistics-with-excel-data-analysis-toolpak/
Materials
PDF resource:
Statistics using Excel Data Analysis Toolpak-FINAL
Workbook:
Statistics using Excel Data Analysis Toolpak-Exercise Files-FINAL
Instructors
Thank You Ask Lex Ph Academy
Thanks Ariel for taking the Excel Data Analysis Course.