Statistics for Business and Economics: Excel/Minitab Enhanced Heinz Kohler

HKStat Programs

 Sheet 3 Five-Number Summary Sheet 4 Confidence Interval for One Population Mean (using normal distribution) Sheet 5 Confidence Interval for One Population Mean (using t distribution) Sheet 6 Optimal Sample Size for Estimating Population Mean or Proportion Sheet 7 Confidence Interval for the Difference Between Two Population Means, Large Independent Samples (using normal distribution) Sheet 8 Confidence Interval for the Difference Between Two Population Means, Large Matched-Pairs Sample (using normal distribution) Sheet 9 Confidence Interval for the Difference Between Two Population Means, Small Independent Samples (using t distribution) Sheet 10 Confidence Interval for the Difference Between Two Population Means, Small Matched-Pairs Sample (using t distribution) Sheet 11 Confidence Interval for One Population Proportion, Large Sample Sheet 12 Confidence Interval for the Difference Between Two Population Proportions, Large Samples Sheet 13 Two-Tailed Hypothesis Test for One Population Mean (using normal distribution) Sheet 14 Lower-Tailed Hypothesis Test for One Population Mean (using normal distribution) Sheet 15 Upper-Tailed Hypothesis Test for One Population Mean (using normal distribution) Sheet 16 Two-Tailed Hypothesis Test for One Population Mean (using t distribution) Sheet 17 Lower-Tailed Hypothesis Test for One Population Mean (using t distribution) Sheet 18 Upper-Tailed Hypothesis Test for One Population Mean (using t distribution) Sheet 19 Two-Tailed Hypothesis Test for One Population Proportion (using normal distribution) Sheet 20 Lower-Tailed Hypothesis Test for One Population Proportion (using normal distribution) Sheet 21 Upper-Tailed Hypothesis Test for One Population Proportion (using normal distribution) Sheet 22 Two-Tailed Hypothesis Test for the Difference Between Two Population Means, Large Independent Samples (using normal distribution) Sheet 23 Lower-Tailed Hypothesis Test for the Difference Between Two Population Means, Large Independent Samples (using normal distribution) Sheet 24 Upper-Tailed Hypothesis Test for the Difference Between Two Population Means, Large Independent Samples (using normal distribution) Sheet 25 Two-Tailed Hypothesis Test for the Difference Between Two Population Means, Large Matched-Pairs Sample (using normal distribution) Sheet 26 Lower-Tailed Hypothesis Test for the Difference Between Two Population Means, Large Matched-Pairs Sample (using normal distribution) Sheet 27 Upper-Tailed Hypothesis Test for the Difference Between Two Population Means, Large Matched-Pairs Sample (using normal distribution) Sheet 28 Two-Tailed Hypothesis Test for the Difference Between Two Population Means, Small Independent Samples (using t distribution) Sheet 29 Lower-Tailed Hypothesis Test for the Difference Between Two Population Means, Small Independent Samples (using t distribution) Sheet 30 Upper-Tailed Hypothesis Test for the Difference Between Two Population Means, Small Independent Samples (using t distribution) Sheet 31 Two-Tailed Hypothesis Test for the Difference Between Two Population Proportions, Large Independent Samples (using normal distribution) Sheet 32 Lower-Tailed Hypothesis Test for the Difference Between Two Population Proportions, Large Independent Samples (using normal distribution) Sheet 33 Upper-Tailed Hypothesis Test for the Difference Between Two Population Proportions, Large Independent Samples (using normal distribution) Sheet 34 Chi-Square Test of Independence Sheet 35 Chi-Square Goodness-of-Fit Test to Binomial Distribution Sheet 36 Chi-Square Goodness-of-Fit Test to Poisson Distribution Sheet 37 Chi-Square Goodness-of-Fit Test to Normal Distribution Sheet 38 Chi-Square Goodness-of-Fit Test to Uniform Distribution Sheet 39 Chi-Square Goodness-of-Fit Test to Any Specified Distribution Sheet 40 Simple Regression Analysis: Confidence Interval for the Average Y, Given X Prediction Interval for an Individual Y, Given X (small sample, n < 30, using t distribution) Sheet 41 Simple Regression Analysis: Confidence Interval for the Average Y, Given X Prediction Interval for an Individual Y, Given X (large sample, n < 30, using normal distribution) Sheet 42 Multiple Regression Analysis: Approximate Confidence Intervals for the Average Y, Given X1 and X2 Approximate Prediction Intervals for an Individual Y, Given X1 and X2 (small sample, n < 30, using t distribution) Sheet 43 Multiple Regression Analysis: Approximate Confidence Intervals for the Average Y, Given X1 and X2 Approximate Prediction Intervals for an Individual Y, Given X1 and X2 (large sample, n < 30, using normal distribution) Sheet 44 Matrix Algebra Illustration Only Multiple Regression Analysis: Exact Confidence Interval for the Average Y, Given X1 and X2 Exact Prediction Interval for an Individual Y, Given X1 and X2 (small sample, n < 7 , using t distribution) Sheet 45 Two-Parameter Exponential Smoothing Sheet 46 Index Numbers Sheet 47 Two-Tailed Wilcoxon Rank-Sum Test Sheet 48 Two-Tailed Mann-Whitney Test Sheet 49 Lower-Tailed Wilcoxon Rank-Sum Test Sheet 50 Lower-Tailed Mann-Whitney Test Sheet 51 Upper-Tailed Wilcoxon Rank-Sum Test Sheet 52 Upper-Tailed Mann-Whitney Test Sheet 53 Sign Test Sheet 54 Wilcoxon Signed-Rank Test Sheet 55 Number-of-Runs Test Sheet 56 Kruskal-Wallis Test