Statistical Analysis Helps

Tools for Statistical Analysis

Excel Analysis Toolpak

• Microsoft Excel contains an additional Analysis ToolPak that has to be installed seperately from the program installation.

• The ToolPak includes tools for Anova, Correlation, Covariance, Descriptive Statistics, Exponential Smoothing, F-Test Two Sample for Variance, Regression, Sampling, and more.

• Load and Activate the Analysis ToolPak by following the "Use the Analysis ToolPak to perform complex data analysis" instructions from Microsoft's website.

Video Tutorial

• Analysis Toolpak Walkthrough

Google Sheets Extension: XL Miner Analysis Toolpak

• Install the Google Sheets extension: XLMiner Analysis ToolPak Add-on, to easily perform statistical analyses of the same types available in the Excel Analysis ToolPak add-in.

• The add-on provides all 19 interactive functions included in the Excel Analysis ToolPak, plus a 20th function often requested by users, logistic regression.

• Sidebar input fields and output on the spreadsheet will be very familiar to Excel Analysis ToolPak users

Stata Software

• Stata is a complete, integrated software package that provides all your data science needs—data manipulation, visualization, statistics, and reproducible reporting

• Buy a 6-month license to Stata/IC by visiting their student pricing page

• Try a 1-week short term license to Stata by requesting it on the Student short-term license request page

Bolt 7.0 Statistical Pack

• Download the Bolt 7.0 Statisical Analysis pack for free from LAPU professor and developer Dr. Damien Byas

• This free-to-use statistical analysis pack for windows users was designed to provide automatic calculations for parametric analyses methods.

• This statistical analysis pack was designed to provide automatic calculations for parametric analyses methods. This resource will assist in gaining a better understanding of how to analyze data and analyses results for parametric hypotheses tests often applied in health and medical research initiatives. 

Video Tutorials

• Descriptive Analysis

• One Sample T test

• Paired Samples T Test

• Independent Samples T Test

• One Way ANOVA Test

• Pearson r Test

• Linear Regression Test

• Chi Square for Association / Independence Test

• Logistic Regression: Binary Predictors

• Logistic Regression: Continuous Predictors

• Logistic Regression: Factor Variables

• Scatterplot Graph