Statistics with Excel Data Analysis Toolpak

[askph_course_price course_id="41275"]
Current Status
Not Enrolled
Price
Free
Get Started

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/