Experiment Design Made Easy

Courses Background

Learn how to extract information from data by attending the new computer-intensive Statistics for Technical Professionals workshop. Gear up your stats knowledge to achieve Six Sigma objectives or other quality improvement initiatives. For example, suppose your company is asked to guarantee with 99% confidence that 90% of its product will meet their key specification. Do you need a confidence interval or a tolerance interval? (Answer: a tolerance interval!)

Using MS Excel, you will learn how to calculate and interpret:
- basic statistics
- confidence intervals
- tolerance intervals
- process capability indices
- testing equality between two variances
- testing equality between two means
- sample size determination
- one-way ANOVA (an introduction)

Statistics for Technical Professionals is aimed at engineers and other technical professionals who would like to brush up on their statistical skills. Yes, we know you slept through that stats class many years ago. You won’t sleep through ours! Using Excel, practical case studies are interwoven with statistical theory to help you rediscover your long-lost skills. Entertaining videos expand on the concepts presented in class.

Courses Outline
Section 1: Descriptive Statistics
  • Population versus sample
  • Descriptive statistics
      ● Mean, median and mode
      ● Variance and standard deviation
  • Normal distribution
  • Video: "Statistics at a Glance"
  • Normal distribution and Z scores

  • Section 2: Confidence Intervals
  • Central limit theorem
  • Confidence interval for mean
      ● Sigma known (normal distribution)
      ● Sigma unknown (t distribution)
  • Confidence interval for standard deviation
      ● Chi squared distribution
  • Confidence interval for binomial proportion
      ● Video: "Inferential Statistics: Part 1"

  • Section 3: Population Parameters
  • Tolerance intervals for normal populations
      ● Two-sided and one-sided
  • Tolerance intervals for non-normal populations
      ● Two-sided and one-sided
  • Statistical versus engineering tolerances
  • Process capability
      ●Process capability indices
      ●Six sigma processes

  • Section 4: Hypotheses Testing
  • Testing equality of two variances
      ● F-test (reject H0: s1=s2 with a risk)
  • Video: "Hypothesis Testing: Part I"
  • Testing equality of two means(reject H0: μ1=μ2 with a risk)
      ● Assuming equal variances; Assuming unequal variances
      ● Paired t-test; One-sided t-test
  • Testing equality of two binomial proportions

  • Section 5: Sample Size Determination
  • Confidence interval for mean
  • Confidence interval for binomial proportion
  • Hypothesis test for equality of two means
  • Hypothesis test for equality of two binomial proportions

  • Section 6: One-Way ANOVA (Introduction)
  • One-way ANOVA
      ● F-test for means
      ● Video: "Hypothesis Testing: Part II"
      ● Exercise: "Resin Pot Life"

  • Section 7: Statistical Tables and Symbol Glossary (Reference)

    Section 8: Exercise Answers (Reference)

    MQIP Quality Management Intelligence Tank
    Rm.1314, No.27 Shui Yin 2 nd Heng Rd. GuangZhou , China
    p: 020-33689262,37597781, f: 020-37597782

     
    Tex:020-33689262 37597781 Fax:020-37597782
    Copyright © 2005 Copyright by MQIP Quality Management Intelligence Tank
    if you have any comments, please let us know E-mail:support@mqip.com.cn

    TCP/IP Registration No. 05130536

    by Ministry Of Information Industry in China