USING THE EXCEL CHART WIZARD TO CREATE （使用EXCEL图表向导创建）.pdf

USING THE EXCEL CHART WIZARD TO CREATE CURVE FITS (DATA ANALYSIS). Note to physics students: Even if this tutorial is not given as an assignment, you are responsible for knowing the material contained here on how to use EXCEL. The examples contained here demonstrate how this feature works in EXCEL, and they demonstrate the general scientific technique of using curve fits to extract information from experimental data. Several types of curve fits are demonstrated in the examples. The simplest and most common type, a straight line fit, is not included as a specific example, but its features are discussed. The author has done this to emphasize that the technique is more general, especially for students who have done only straight line fits before. You should read and complete the EXCEL SPREADSHEET TUTORIAL before attempting this exercise. TABLE OF CONTENTS: I. INTRODUCTION: - Motivation and Our First Example. II. OUR FIRST FIT: - Position vs. Time; A 2nd Order Polynomial Fit. A. Getting Started B. Adding the Best Fit Curve II. OUR SECOND FIT: - A Simple Power Law Fit. A. Basic Form B. Keplers Third Law Example C. A Word of Caution III. THIRD EXAMPLE: - An Exponential Function. A. Basic Form B. Radioactive Decay Example C. A Word of Caution IV. OTHER TYPES OF FITS. V. SUMMARY OF DATA RESTRICTIONS. VI. BAD FITS. A. The Wrong Function B. Bad Data VII. CONCLUDING REMARKS. I. INTRODUCTION: - Motivation and Our First Example. In the EXCEL SPREADSHEET TUTORIAL we created a plot from numbers that were calculated from a set of formulas. We plotted the position vs. time and velocity vs. time of a falling body using the kinematics equations for constant acceleration (position = y, velocity = v): 1 2 y y0 v0y t a y t ;