Hypothesis Tests
Download Excel 2007 Workbook with Instructions
Download Excel 2003 Workbook with Instructions
Read article about paired t-Test
You can let Quantum XL run the most appropriate test for your data (AutoTest), ask Quantum XL to help you decide which test to run (Advisor Wizard), or run one of the supported hypothesis.
The Hypothesis tests report usually includes Box plot and Dot plot charts next to the results of the hypothesis test being performed.
AutoTest
Analyze the data and automatically run the test for variance and mean/median. This greatly reduces the time required to find and run the correct Hypothesis Test.
Advisor Wizard
The Advisor Wizard will ask you questions about your data and advise you on the correct test to perform.
Tests for variance
Analyze dataset variance using F-test, Bartlett's test or Levene's test. Quantum XL will display test statistics, p Value, 95% Bonferroni CI for StDevs, and dataset statistics.
Tests for mean
Analyze the dataset mean using One-sample t-test, Two-sample t-test, Paired t-test, One-way ANOVA, or Two-way ANOVA nested or crossed.
Tests for median (analyze dataset median)
Analyze dataset median using 1-sample Wilcoxon test, 1-sample sign test, Mann-Whitney test, Friedman test, Kruskal-Wallis test or Mood's Median test.
Quantum XL will display test statistics, confidence interval for the median, dataset statistics, and p Value.
Attribute tests
Analyze qualitative data using the One proportion test, Two proportion test, or Chi-Squared test.
Test for normality
Test your dataset for normality.
Choose between Anderson–Darling, Shapiro–Wilk, or Kolmogorov–Smirnov test methods. Quantum XL will display the test statistic, p Value, and probability plot.
Power and sample size analysis
Compute the statistical power of the test for a given sample size or calculate the required sample size.
Power and sample size analysis are calculated differently for different hypothesis tests.
Quantum XL supports power and sample size analysis for One sample t-test, Two sample t-test, Paired t-test, One-way ANOVA, One proportion test, Two proportions test, and Two variances test.






