TUTORIAL_EXCEL_S09

TUTORIAL_EXCEL_S09 - TUTORIAL SELECTED APPLICATIONS OF MS...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
1 TUTORIAL SELECTED APPLICATIONS OF MS EXCEL ( January 12 , 200 9 ) 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, f x . 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 number in Cell H16 is a dummy constant used to illustrate use of the $ symbol to control reference positions. II. Paste function The paste function, f x , can be used to implement a variety of calculations.
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 4

TUTORIAL_EXCEL_S09 - TUTORIAL SELECTED APPLICATIONS OF MS...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online