Using Microsoft Excel©97Purpose:To learn how to fit data using a spreadsheet.Equipment:Data set from Lab 1 and Microsoft Excel©97.Discussion:In this lab your instructor will demonstrate the use of a Microsoft Excel spreadsheetto enter data, graph the data and fit a straight line to the data. You will find throughout the coursethat we will be creating such plots and determining important physical information from best fitlines to data sets. In the figure is anexample of what you should obtain.The data will be markers with noconnecting lines. (We never connectthe dots.) The line is the best fit line.This line will help you to determine arelationship between your variableson the horizontal and vertical axes,known respectively as the abscissaand ordinate. In the figure theabscissa is time and the ordinate isposition. We say that this is a graph ofthe position versus the time (verticalvs. horizontal variable).
You've reached the end of your free preview.
Want to read the whole page?
- Spring '18
- Dr. Moez
- Regression Analysis