1 TUTORIAL SELECTED APPLICATIONS OF MS EXCEL (January 12, 2004)

Short Description
calculations that can be done using a MicroSoft Excel spread-sheet. Features … Table 1 summarizes data to be used and calculated in this tutorial. …

Website: www.chem.purdue.edu | Filesize: 72kb

Content
1
TUTORIAL
SELECTED APPLICATIONS OF MS EXCEL
(January 12, 2004)
Some elementary statistical calculations are used to illustrate selected types of
calculations that can be done using a MicroSoft Excel spread-sheet. Features
illustrated include:
?Use of the toolbar paste function, fx.
?Use of array calculations.
?Use of the $ symbol to control cell references.
Table 1 summarizes data to be used and calculated in this tutorial. Numbers not
included in parentheses are the data to be used in the calculations. Numbers
included in parentheses are the numbers that should be obtained when the
tutorial is completed successfully.
Table 2 summarizes equations and processes used in the various cells to
complete the tutorial. As you proceed through this tutorial pay particular attention
to ways that the Copy/Paste operations are used to minimize the effort required
for similar operations on different data sets.
All uses of the word “Click” in this discussion refer to the left mouse button.
I. Entering data
Open an Excel spread sheet and Enter data in Cells C8 - E13 and Cell H16. The
data in Cells C8 - C13 are masses used to calibrate a constant flow system and
the…