Statistical Analysis Helps
Statistical Analysis Helps
Tools for Statistical Analysis
Tools for Statistical Analysis
Excel Analysis Toolpak
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
Google Sheets Extension: XL Miner Analysis Toolpak
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 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