QCL Excel Analysis ToolPak(Level 2 - Data) Workshop
Summary
Ever have the experience that when you need data analysis done but you don’t have statistical software accessibility? The Excel Analysis ToolPak add-in, which is an added feature for Microsoft Excel, can help you get your work done without having to spend time to download a hefty software like SPSS or STATA. The Excel Analysis ToolPak add-in allows users to perform statistical analyses by providing the data and parameters for each analysis. The result is displayed in an output table while some analyses generate charts in addition to output tables.
Purpose
In this Excel Level 2 workshop, we’ll cover the common statistical methods available under the Analysis ToolPak Add-in.
Prerequisite
-
Local installation of the Microsoft Excel on own computer.
-
Refer to Microsoft Analysis ToolPak for the add-in installation.
-
Have some basic working knowledge of Microsoft Excel.
-
Introductory level knowledge in search, log-in, nagivation websites, etc.
The workshop covers
- Histogram
- Descriptive Statistics
- F-test
- t-test
- ANOVA