2

Free

## Course dates

Interested in attending? Have a suggestion about running this course near you?

## Description

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

## Instructor(s):

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)

## Scheduling:

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 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. To express your interest in an open enrollment course not on our current schedule, please email us at ati@aticourses.com.

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.