O'Reilly logo

A Guide to Microsoft Excel 2007 for Scientists and Engineers by Bernard Liengme

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 16

Statistics for Experimenters

Publisher Summary

Microsoft Excel can be a powerful tool for statistical analysis. This chapter discusses a very small subset of these tools. The main focus is on the treatment of variability associated with data measurements. Some of the functions introduced are: AVERAGE, DEVSQ, FREQUENCY, STDEV, TDIST, TINV, and TTEST. This chapter discusses descriptive statistics, frequency distribution, and confidence limits. It compares the mean from two sets of measurements made on a set of samples. Set A is the measurement using one technique, while set B was obtained from another.

In the past there have been some criticisms of the algorithms used by Excel for its statistical functions. Significant improvements were ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required