Using Excel for Handling, Graphing, and Analyzing Scientific Data:

Start Excel and a screen similar to the one below will appear. ….. For information on interactive Excel spreadsheets or Excelets, see Developer’s …

More PDF Content

Using Excel for Handling, Graphing, and Analyzing Scientific Data:
Page 1
Using Excel for Handling, Graphing, and Analyzing Scientific Data: A Resource for Science and Mathematics Students Scott A. Sinex Barbara A. Gage Department of Physical Sciences and Engineering Prince George’s Community College Largo, MD 20774-2199 Spring 2006 version http://academic.pgcc.edu/psc
Page 2
Acknowledgments The authors would like to thank Bridget Bartlebaugh of the Computer Information and Office Systems Department
Page 3
iii TABLE OF CONTENTS Some Excel Basics 1 Handing and Manipulating Data 3 Displaying an X-Y Data Set as a Scatter Plot 6 Plotting a Regression Equation 8 Interpolation and Extrapolation 10 Printing or Exporting Graphs 11 Downloading Data from the Internet 11 For the More Advanced Statistical Users 12 Using Interactive Excel Spreadsheets or Excelets 14 More Resources 15 An Example of a Printed Chart 16
Page 4
iv One of the authors on a bad day. Just hit any key!!! Where is my graphing calculator?
Page 5
Using Excel for… Scientific Data 1 Using Excel for Handling, Graphing, and Analyzing Scientific Data Excel is a Microsoft computer application called a “spreadsheet.” It is designed to manage, manipulate, and display data. It has functions appropriate for business and scientific data sets. Excel is comparable to other spreadsheet applications such as Quattro Pro by Corel. If you are familiar with the basic layout and terminology of spreadsheets you can skip this “basics” section or use it for review. Some Excel Basics Start Excel and a screen similar to the one below will appear. The main body of the screen will contain columns labeled with letters (A, B, C…) and rows labeled with numbers (1, 2, 3…). A cell is a space where numbers, formulas or text can be entered. Each cell has a designation that gives its location such as F22 (column F, row 22) or CC115 (column CC, row 115). Above the main body are two white regions. The left region, the Name box, indicated which cell

Download Using Excel for Handling, Graphing, and Analyzing Scientific Data: pdf from academic.pgcc.edu, 20 pages, 280.41KB.
Related Books

Leave a Reply