Statistics 101: Fundamentals of Statistics with Excel Examples

ATI Courses Logo

Broaden Your Knowledge & Increase Productivity

Training Rocket Scientists Since 1984

(410) 956-8805
(888) 501-2100

Statistics 101:
Fundamentals of Statistics with Excel Examples

2-Day Course

$1595 per person

Summary

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.

  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

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 ati@aticourses.com. 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. For on-site pricing, you can use the request an on-site quote form, call us at (410) 956-8805, or email us at ati@aticourses.com.

Instructor

Dr. Alan Stuart

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)