Statistics 101

Course Length:



This two-day course provides an introductory overview of basic statistics and statistical analysis with examples presented in Excel. Participants will be furnished with the textbook Statistical Analysis with Excel for Dummies, by Joseph Schmuller.

Course Outline:

  1. Introduction to Excel Statistical Tools
  2. Measures of Central Tendency and of Dispersion
  3. Probability Concepts
  4. Discrete Random Variables & Monte Carlo Method
  5. Binomial Distributions (Pass-Fail Statistics)
  6. Continuous RV’s; Uniform & Triangular Distribution
  7. Basics of Normal Distribution
  8. Central Limit Theorem & Student t- Distribution
  9. Confidence Level and Interval
  10. Sample Size for Mean Estimation
  11. Chi-Square Distribution and Goodness-of-Fit
  12. Functions of Random Variables (Propagation of Errors)
  13. Uncertainty of Measurements
  14. robability and System Reliability
    • Exponential Distribution and Reliability
    • Gamma Distribution and Reliability
    • Poisson Distribution and Process
    • Weibull Distribution and Time to Failure
  15. Percentiles and Probability Plots of Data
  16. Hypotheses Testing and OC Curves
  17. Topics of interest to the class


REGISTRATION:  There is no obligation or payment required to enter the Registration for an actively scheduled course.   We understand that you may need approvals but please register as early as possible or contact us so we know of your interest in this course offering.

SCHEDULING:  If this course is not on the current schedule of open enrollment courses and you are interested in attending this or another course as an open enrollment, please contact us at (410)956-8805 or Please indicate the course name, number of students who wish to participate. and a preferred time frame. ATI typically schedules open enrollment courses with a 3-5 month lead-time.   To express your interest in an open enrollment course not on our current schedule, please email us at

For on-site pricing, you can use the request an on-site quote form, call us at (410)956-8805, or email us at


  • Dr. Alan D. Stuartan emeritus professor of acoustics at Penn State, has over forty years’ experience in the field of sound and vibration. For over thirty years, he has taught both academic and onsite technical training courses on the Fundamentals of Acoustics, Structural Acoustics, Noise Control Engineering, Underwater Acoustics and Sonar Engineering, as well as Math Refreshers (including Statistics) at government and industrial organizations throughout the country, as well as in Canada and Mexico.

    Contact this instructor (please mention course name in the subject line)

Request On-Site Quote