Statistics with Excel Data Analysis Toolpak
CI
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/
good course
Clear way of explaining things
very helpful and informative
I am not a math enthusiast; honestly, I am not really good in this field, especially in dealing with massive data and interpretation, which for me is believably complex. Hence, being introduced to this course is a great opportunity for me to learn how to lessen the burden of solving problems and become efficient at work related to them.
Christian Ibanez introduces the Excel Data Analysis Toolpack, emphasizing practical application and recommending Excel 2013+. Real data sets are utilized, and step-by-step installation instructions are provided for beginners. This help me to improve my skills
CI
JP
CB