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.
Get A Guide to Microsoft Excel 2007 for Scientists and Engineers now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
