# Stats tools

50 %
50 %

Published on March 1, 2014

Author: ccumby

Source: slideshare.net

## Description

An overview of SigmaXL's Statistical Tools

Established in 1998, SigmaXL Inc. is a leading provider of user friendly Excel Add-ins for Lean Six Sigma graphical and statistical tools and Monte Carlo simulation.

SigmaXL® customers include market leaders like Agilent, Diebold, FedEx, Microsoft, Motorola and Shell. SigmaXL® software is also used by numerous colleges, universities and government agencies.

Our flagship product, SigmaXL®, was designed from the ground up to be a cost-effective, powerful, but easy to use tool that enables users to measure, analyze, improve and control their service, transactional, and manufacturing processes. As an add-in to the already familiar Microsoft Excel, SigmaXL® is ideal for Lean Six Sigma training and application, or use in a college statistics course.

DiscoverSim™ enables you to quantify your risk through Monte Carlo simulation and minimize your risk with global optimization. Business decisions are often based on assumptions with a single point value estimate or an average, resulting in unexpected outcomes.

DiscoverSim™ allows you to model the uncertainty in your inputs so that you know what to expect in your outputs.

Statistical Tools - SigmaXL® Version 6.1 Stats Tools: Feature Overview Two-Sample Comparison Tests Multiple Regression with Residuals Plots Binary & Ordinal Logistic Regression One-Way Anova & Means Matrix Non-Parametric Tests Correlation Matrix Chi-Square Test Multiple Linear Regression Power & Sample Size Calculators Multiple Regression Predicted Response Calculator Power & Sample Size Charts

Statistical Tools      P-values turn red when results are significant (pvalue < alpha) Descriptive Statistics including Anderson-Darling Normality test, Skewness and Kurtosis with pvalues 1 Sample t-test and confidence intervals Paired t-test, 2 Sample t-test 2 Sample Comparison Tests   Normality, Mean, Variance, Median Yellow Highlight to aid Interpretation Back to Index

Statistical Tools   One-Way ANOVA and Means Matrix Two-Way ANOVA   Equal Variance Tests:     Balanced and Unbalanced Bartlett Levene Welch’s ANOVA Correlation Matrix   Pearson’s Correlation Coefficient Spearman’s Rank Back to Index

Statistical Tools       Multiple Linear Regression Binary and Ordinal Logistic Regression Chi-Square Test (Stacked Column data and Two-Way Table data) Nonparametric Tests Power and Sample Size Calculators Power and Sample Size Charts Back to Index

Statistical Tools: Two-Sample Comparison Tests P-values turn red when results are significant! Rules based yellow highlight to aid interpretation! Back to Index

Statistical Tools: One-Way ANOVA & Means Matrix 4.48 Mean/CI - Overall Satisfaction 4.28 4.08 3.88 3.68 3.48 3.28 3.08 1 2 3 Customer Type Back to Index

Statistical Tools: Correlation Matrix Back to Index

Statistical Tools: Multiple Linear Regression  Accepts continuous and/or categorical (discrete) predictors.   Categorical Predictors are coded with a 0,1 scheme making the interpretation easier than the -1,0,1 scheme used by competitive products. Interactive Predicted Response Calculator with 95% Confidence Interval and 95% Prediction Interval. Back to Index

Statistical Tools: Multiple Linear Regression         Residual plots: histogram, normal probability plot, residuals vs. time, residuals vs. predicted and residuals vs. X factors Residual types include Regular, Standardized, Studentized Cook's Distance (Influence), Leverage and DFITS Highlight of significant outliers in residuals Durbin-Watson Test for Autocorrelation in Residuals with p-value Pure Error and Lack-of-fit report Collinearity Variance Inflation Factor (VIF) and Tolerance report Back to Fit Intercept is optional Index

Statistical Tools: Multiple Regression Multiple Regression accepts Continuous and/or Categorical Predictors! Back to Index

Statistical Tools: Multiple Regression Durbin-Watson Test with p-values for positive and negative Back to Index autocorrelation!

Statistical Tools: Multiple Regression – Predicted Response Calculator with Confidence Intervals Easy-to-use Calculator with Confidence Intervals and Prediction Intervals! Back to Index

Statistical Tools: Multiple Regression with Residual Plots 2 40 1 NSCORE 3 50 30 0 1. 10 Residuals Regular Residuals 1.5 1.00 1 Regular Residuals 1.50 0.50 0.00 0.5 0 -0.5 Fitted Values 10 0. 00 80 .0 0 60 .0 0 40 .0 0 20 .0 0 12 0 10 0 80 40 20 60 Observation Order 0. 00 -1 -1.00 Back to Index 12 0. 00 -0.50 0 Regular Residuals 0. 60 0. 10 -0 .9 0 1. 19 1. 01 0. 84 0. 67 0. 50 0. 32 0. 15 -0 .0 2 -3 -0 .1 9 0 -0 .3 7 -2 -0 .5 4 10 -0 .7 1 -1 -0 .8 8 20 -0 .4 0 Frequency 60

Statistical Tools: Binary and Ordinal Logistic Regression     Powerful and user-friendly logistic regression. Report includes a calculator to predict the response event probability for a given set of input X values. Categorical (discrete) predictors can be included in the model in addition to continuous predictors. Model summary and goodness of fit tests including Likelihood Ratio Chi-Square, Pseudo R-Square, Pearson Residuals Chi-Square, Deviance Residuals Chi-Square, Observed and Predicted Outcomes – Percent Correctly Predicted. Back to Index

Statistical Tools: Nonparametric Tests        1 Sample Sign 1 Sample Wilcoxon 2 Sample Mann-Whitney Kruskal-Wallis Median Test Mood’s Median Test Kruskal-Wallis and Mood’s include a graph of Group Medians and 95% Median Confidence Intervals Runs Test Back to Index

Statistical Tools: Chi-Square Test Back to Index

Statistical Tools: Power & Sample Size Calculators       1 Sample t-Test 2 Sample t-Test One-Way ANOVA 1 Proportion Test 2 Proportions Test The Power and Sample Size Calculators allow you to solve for Power (1 – Beta), Sample Size, or Difference (specify two, solve for the third). Back to Index

Statistical Tools: Power & Sample Size Charts Power & Sample Size: 1 Sample t-Test 1.2 Power (1 - Beta) 1 Difference = 0.5 0.8 Difference = 1 Difference = 1.5 0.6 Difference = 2 Difference = 2.5 0.4 Difference = 3 0.2 0 0 10 20 30 40 50 60 Sample Size (N) Back to Index

 User name: Comment:

## Related presentations

#### Cheapest canvas prints shopcanvasprintcom

April 2, 2014

Canvas Prints at Affordable Prices make you smile.Visit http://www.shopcanvasprint...

#### Paseo en bici por la historia del comercio gijones

April 1, 2014

30 Días en Bici en Gijón organiza un recorrido por los comercios históricos de la ...

#### Meta anlysis of 5 spanish ropo studies minerva ove...

April 1, 2014

Con el fin de conocer mejor el rol que juega internet en el proceso de compra en E...

#### Informa Whitepaper - The Rise of Australia's LNG I...

April 1, 2014

With three established projects across the country and seven more in the pipeline,...

#### Decoding Retail StartUp : Comprehensive Roll-Out S...

April 1, 2014

Retailing is not a rocket science, neither it's walk-in-the-park. In this presenta...

#### What is research??

April 2, 2014

Explanatory definitions of research in depth...

## Related pages

### StatsTools – Statistics tools and information

This Statistics Tools website was designed to go with the Statistics Help Desk at Missouri State University. M aintained by Dr. Erin Buchanan and her team ...

### OGame Stats & Tools - War-Riders.de

OGame Stats & Tools - Spielersuche, Statistiken, Koordinaten und viele weitere Tools für OGame

### TW Stats

TW Stats - Eine Seite mit Statistiken und Tools für das bekannte Spiel „Die Stämme“

### Google Analytics Solutions - Web Analytics & Marketing ...

Google Analytics Solutions offer free and enterprise analytics tools to measure website, app, digital and offline data to gain customer insights.

### OGame Stats & Tools - GameStats.org

OGame Stats & Tools - Spielersuche, Statistiken, Koordinaten und viele weitere Tools für OGame

### Comunio Statistiken

Tools Punkte-Generator; Kaderliste; Spieler des Monats; Auswahl-Teams; Spielersuche; Info Kontaktformular; Links; Benutzername: nicht registriert? Passwort:

### Tw2-Tools.com

Tw2-Tools.com is a site offering statistics, tools and a data history of the game Tribal Wars 2. To use it, you first need to choose a world.