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

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