# Prioritize Properly with Pareto Charts and EZ-Pivot

Whats New in SigmaXL V6.2 Presenter: John Noguera, P. Eng., MBB, Co-founder and CTO, SigmaXL, Inc. AGENDA New features in SigmaXL Version 6.2 include: Compatible with Excel 2013, 32 and 64-bit versions and Mac Excel 2011 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 Updated Statistical Templates: 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

AGENDA New features in SigmaXL Version 6.2 include: The template Minimum Sample Size for Robust t-Tests and ANOVA answers the question, How large does the sample size have to be for the central limit theorem to work? This template is unique to SigmaXL and was developed using extensive Monte Carlo simulations. It provides a minimum sample size required for the 1 Sample t-Test, 2 Sample t-Test and OneWay ANOVA to be robust to non-normality. The user simply enters the sample Skewness and Kurtosis and obtains a minimum sample size required for the specified test. Easy to interpret, color coded Reject or Fail to Reject the Null Hypothesis.

AGENDA New features in SigmaXL Version 6.2 include: Confidence intervals for 1 Proportion and 1 Poisson Rate templates include the traditional exact methods which are strictly conservative and guarantee the specified confidence level, but result in wide intervals. Alternatively, Wilson Score and Jeffreys intervals can be selected to provide narrow intervals that match the specified confidence interval on average. Normal approximation methods are also available for students to validate hand calculations. Comparison of Coverage Probability for Exact (Clopper-Pearson) versus Wilson Score 1 Proportion Binomial, n = 50 Brown, L. D., Cai, T. T. and DasGupta, A. (2001), Interval estimation for a binomial proportion. Statistical Science, 16, 101-133

AGENDA New features in SigmaXL Version 6.2 include: Confidence intervals for 2 Proportions and 2 Poisson Rates include modern methods that result in narrow intervals that maintain the specified confidence level on average: Newcombe-Wilson and Jeffreys Hybrid. Presentation: 50 Minutes; Q&A: 10 minutes

## Recently Viewed Presentations

• The Stack ADT. A stack is a list of objects in which insertions and deletions can only be performed at the top of the list. Also known as LIFO (Last In, First Out)
• Easy to build powerful BCS solutions without writing code. SPD provides simple wizard-based UI to connect to external data sources. External Lists enable you to richly integrate external data into SharePoint. InfoPath offers rich customization and symmetric client-server story. Outlook...
• Happy Halloween To understand: The purpose of having SOP's and how they affect the daily workings of laboratories. To discuss: What is an SOP Purpose of SOP Components of SOP Identification process of SOP SOP's are written instructions that document...
• It improves the development and implementation of equality and HR policy, boosts accountability; wards against neo-corporatism/ agenda domination by the "usual suspects" - and is in furtherance of PSED . regs./ BDPfA. etc.
• Your Friend and Mine The Windows Registry What is the Registry? Think of as a giant 411 switchboard Simple idea of centralized one-stop shopping for all of Windows' needs Everything else is a GUI for it: Windows Control Panel File...
• Recent results of KLOE at DA NE [nb] V.Patera Rome I University & Laboratori Nazionali di Frascati (INFN) s [MeV] Outline Physics at the -factory (II) Physics at the -factory (III) Outline Outline The KLOE Calorimeter: The KLOE Drift Chamber:...
• Use inventories & backorders to absorb demand peaks & valleys Chase plans: Minimize finished good inventories by trying to keep pace with demand fluctuations Hybrid Strategies Use a combination of options: Build-up inventory ahead of rising demand & use backorders...
• Course book Goldstein, Sensation and Perception exams two mid-terms 1½ hours multiple choice + short notes end-of-term 2-3 hours 30%, 30% and 40% (best counted as 40%)