p309-ExcelExamples

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

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

View Full Document Right Arrow Icon
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)
Background image of page 1

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

View Full DocumentRight Arrow Icon
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
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

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 Right Arrow Icon
Ask a homework question - tutors are online