These are some of the SigmaXL features: Data Manipulation: Subset by Category, Number, Date or Random Stack Subgroups Across Rows Random Number Generator Templates & Calculators: DMAIC & DFSS Templates Lean Templates Probability Distribution Calculators MSA Templates Process Sigma Level - Discrete and Continuous Process Capability & Confidence Intervals Graphical Tools: Basic and Advance (Multiple) Pareto Charts EZ-Pivot/Pivot Charts Basic Histogram Multiple Histograms and Descriptive Statistics Multiple Histograms and Process Capability Multiple Boxplots, Dotplots Measurement Systems Analysis: Create Gage R&R (Crossed) Worksheet Analyze Gage R&R (Crossed) Attribute MSA (Binary) Process Capability: Multiple Histograms and Process Capability Capability Combination Report for Individuals/Subgroups Capability Combination Report for Nonnormal Data (individuals) Distribution Fitting Report Statistical Tools: P-values turn red when results are significant Descriptive Statistics including Anderson-Darling Normality test, Skewness and Kurtosis with p-values 1 Sample t-test and confidence intervals Paired t-test, 2 Sample t-test 2 Sample comparison tests One-Way ANOVA and Means Matrix Two-Way ANOVA (Balanced and Unbalanced) Equal Variance Tests (Barlett, Levene and Welch's ANOVA) Correlation Matrix (Pearson and Spearman's Rank Correlation) Multiple Linear Regression Binary and Ordinal Logistic Regression Chi-Square Test (Stacked Column data and Two-Way Table data) Nonparametric Tests Design of Experiments: Generalte 2-Level Factorial and Plackett-Burman Screening Designs Basic DOE Templates Main Effects & Interaction Plots Analyze 2-Level Factorial and Plackett-Burman Screening Designs Control Charts: Control Chart Selection Tool Individuals, Individuals & Moving Range X-Bar & R, X-Bar & S I-MR-R, I-MR-S (Between/Within).
What is new in this release:
4 New Statistical Templates:
- Minimum Sample Size for Robust t-Tests and ANOVA
- 1 Poisson Rate Test and Confidence Interval
- 2 Poisson Rates Test and Confidence Interval
- One-Way Chi-Square Goodness-of-Fit Test
- 1 Sample t-Test and Confidence Interval for Mean
- 2 Sample t-Test and Confidence Interval (Compare 2 Means) with option for equal and unequal variance
- 1 Sample Chi-Square Test and CI for Standard Deviation
- 2 Sample F-Test and CI (Compare 2 Standard Deviations)
- 1 Proportion Test and Confidence Interval
- 2 Proportions Test and Confidence Interval
Requirements:
Microsoft Excel 2010/2013 64-bit
Limitations:
30-day trial
Comments not found