p309-ExcelExamples

# p309-ExcelExamples - Basics This constant is used through...

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

Basics g = 982.000 cm/s^2 Theta Degrees Radians 15.00 0.26 15.00 0.26 15.00 0.26 15.00 0.26 15.00 0.26 15.00 0.26 15.00 0.26 15.00 0.26 15.00 0.26 15.00 0.26 30.00 0.52 30.00 0.52 30.00 0.52 30.00 0.52 30.00 0.52 30.00 0.52 30.00 0.52 30.00 0.52 30.00 0.52 30.00 0.52 This example shows how to do some basic calculations using EXCEL. Suppose some measurements are made of the position of a ball rolling down an incline plane. Then we expect x(t) = 1/2*sin(theta)*g*t^2, where x is the position, theta is the angle the plane makes to the horizontal, g=9.8 m/s^2, and t is the elapsed time. This constant is used through out the spread sheet. Referenced as \$C\$3, the \$'s are used to ensure that this is a fixed reference rather than a relative reference to the cell. The plot above is made using the >Insert>Chart menu. I selected X-Y scatter as the chart type and entered 4 data series using the times as the x values and the measured and expected positions as the y values. Once the data was shown on the chart, I right clicked on the data values in the plot area and selected Format Data Series to add error bars. I selected " Custom " and used the sigma_x and sigma_t values from the spread sheet as the + and - error bars. 0.00 0.20 0.40 0.60 0.80 1.00 1.20 1.40 1.60 1.80 2.00 0 100 200 300 400 500 600 700 800 900 Inclinded plane measurements Column G Column K Column G Column K time (seconds) position (cm)

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

View Full Document
Measured Expected x (cm) sigma_x t (s) sigma_t x (cm) 0.00 0.50 0.00 0.00 0.00 3.50 0.50 0.20 0.05 5.08 23.90 0.50 0.40 0.05 20.33 52.20 0.50 0.60 0.05 45.75 83.40
This is the end of the preview. Sign up to access the rest of the document.

## This note was uploaded on 01/20/2012 for the course P 309 taught by Professor Urheim during the Spring '11 term at Indiana.

### Page1 / 9

p309-ExcelExamples - Basics This constant is used through...

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

View Full Document
Ask a homework question - tutors are online