top header
top gradation HOME top vertical line top vertical line top vertical line top vertical line top vertical line top vertical line top vertical line menu gray
black line 2
menu gray tab More About ATI
menu blue ATI — Who We Are
white line
menu blue Contact ATI Courses
white line
menu blue List Of ATI Courses
white line
menu blue Attendees Testimonials
white line
menu blue The ATI FAQ Sheet
white line
menu blue Suggestions/Wait List
white line
menu blue New Courses
white line
menu blue Become an ATI Instructor
menu gray tab site resources
menu blue Acoustics & Sonar
white line
menu blue Rockets & Space
white line
menu blue GPS Technology
white line
menu blue ATI Blog
white line
menu blue ATI Space News
white line
menu blue ATI Site Map
white line
menu blue ATI Staff Tutorials
white line
menu blue ATI Sampler Page
white line
menu gray tab bar
menu gray tab courses
white line
menu blue Current Schedule
white line
menu blue Onsite Courses
white line
menu blue Register Online
white line
menu blue Request Brochure
white line
menu blue Free On-Site Price Quote
white line
menu blue Download Catalog
white line
menu blue Distance Learning
black line  

ATI's Fundamentals of Statistics with Excel Examples course

Share |


    Technical Training Short On Site Course Quote

      This two-day course, Fundamentals of Statistics with Excel Examples, covers the basics of statistics and statistical analysis, using Excel. Participants will be furnished the textbook Statistical Analysis with Excel for Dummies, by Joseph Schmuller Ph.D.


      Dr. Alan D. Stuart, Associate Professor Emeritus of Acoustics, Penn State, has over forty years experience in the field of sound and vibration. He has degrees in mechanical engineering, electrical engineering, and engineering acoustics. For over thirty years he has taught courses on the Fundamentals of Acoustics, Structural Acoustics, Applied Acoustics, Noise Control Engineering, and Sonar Engineering on both the graduate and undergraduate levels as well as at government and industrial organizations throughout the country.

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

    Course Outline:

      Day 1:

    1. Introduction to Statistics. Definition of terms and concepts with simple illustrations. Measures of central tendency: Mean, mode, medium. Measures of dispersion: Variance, standard deviation, range. Organizing random data. Introduction to Excel statistics tools.

    2. Basic Probability. Probability based on: equally likely events, frequency, axioms. Permutations and combinations of distinct objects. Total, joint, conditional probabilities. Examples related to systems engineering.

    3. Discrete Random Variables. Bernoulli trial. Binomial distributions. Poisson distribution. Discrete probability density functions and cumulative distribution functions. Excel examples.

    4. Continuous random variables. Normal distribution. Uniform distribution. Triangular distribution. Log-normal distributions. Discrete probability density functions and cumulative distribution functions. Excel examples.

    5. Sampling Distributions. Sample size considerations. Central limit theorem. Student-t distribution.

      Day 2:

    6. Functions of Random Variables. (Propagation of errors) Sums and products of random variables. Tolerance of mechanical components. Electrical system gains.

    7. System Reliability. Failure and reliability statistics. Mean time to failure. Exponential distribution. Gamma distribution. Weibull distribution.

    8. Confidence Level. Confidence intervals. Significance of data. Margin of error. Sample size considerations. P-values.

    9. Hypotheses Testing. Error analysis. Decision and detection theory. Operating characteristic curves. Inferences of two-samples testing, e.g. assessment of before and after treatments.

    10. Probability Plots and Parameter Estimation. Percentiles of data. Box whisker plots. Probability plot characteristics. Excel examples of Normal, Exponential and Weibull plots.

    11. Regression Analysis. Introduction to linear regression, Error variance, Pearson linear correlation coefficient. Residuals pattern. Excel examples.

    12. Other Topics of Interest to Class.


      Tuition for this two-day course is $1290 per person at one of our scheduled public courses. Onsite pricing is available. Please call us at 410-956-8805 or send an email to

    Register Now Without Obligation