# Statistics 101: Fundamentals of Statistics with Excel Examples

Training Rocket Scientists Since 1984

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

## Statistics 101: Fundamentals of Statistics with Excel Examples

### 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 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)