Excel_tutorial

# Excel_tutorial - Physics Laboratory Tutorial Menu Excel...

This preview shows pages 1–3. Sign up to view the full content.

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

View Full Document
2 iv. Finding the launch angle of a ski ramp v. Verifying a trig identity 7. Graphing Data and Curve Fitting i. An experiment to determine π ii. How to plot a data set iii. Displaying units on the axes iv. Displaying symbols v. Add a trendline and equation to the graph vi. Altering the look of the displayed equation vii. Altering the attributes of the trendline viii. Calculating π from the slope (and finding % Error) 8. Advanced Graphing and Curve Fitting i. Creating plots of two data series on one graph ii. Altering the graph's legend iii. Fitting multiple curves on one set of data iv. Using error bars 9. Advanced Topics i. Creating user-defined constants ii. Adjusting the graph's scale 10. Using Excel's Statistics Commands i. Basic built-in functions (AVERAGE, MEAN, MODE, COUNT, MAX, MIN) ii. Linear regression equations (SLOPE, INTERCEPT, CORREL) iii. Error analysis tools (STDEV) iv. Miscellany (ABS) 11. Linear Regression and Excel i. Sample data ii. Linear regression equations iii. Applying regression to the sample data iv. Linear regression with built-in functions 12. Helpful Hints Concerning the Physics Lab Reports i. Work carefully ii. Neatly display your work iii. Display sample formulas iv. Check your work by hand v. Printing tips
This is the end of the preview. Sign up to access the rest of the document.

## This note was uploaded on 07/24/2009 for the course PHY 092342 taught by Professor Knott during the Spring '09 term at Cosumnes River College.

### Page1 / 49

Excel_tutorial - Physics Laboratory Tutorial Menu Excel...

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

View Full Document
Ask a homework question - tutors are online