Stats tools

50 %
50 %
Information about Stats tools
Business & Mgmt

Published on March 1, 2014

Author: ccumby



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

Add a comment

Related presentations

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

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

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

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

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

What is research??

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 ...
Read more

OGame Stats & Tools -

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

TW Stats

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

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.
Read more

OGame Stats & Tools -

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

Comunio Statistiken

Tools Punkte-Generator; Kaderliste; Spieler des Monats; Auswahl-Teams; Spielersuche; Info Kontaktformular; Links; Benutzername: nicht registriert? Passwort:
Read more 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.
Read more

Google Analytics

Use Google Analytics to learn which online marketing initiatives are cost effective and see how visitors actually interact with your site. Make informed ...
Read more bietet Statistiken, Werkzeuge und Datensammlungen über das Spiel Tribal Wars 2. Um diese Funktionen nutzen zu können, ...
Read more

STATS LLC - Sports Technology, Data Feeds, Content

STATS is the world's leading sports data and technology company. From data feeds to content and athlete monitoring, STATS has solutions for pro teams and ...
Read more