Physics II workshop_Part_33

# Physics II workshop_Part_33 - 1 Open Excel and transfer the...

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

68 Week #6

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

View Full Document
69 Planetary Orbits You will need to use a laptop in this activity, so form two groups of 2 or 3 at each table. The planets follow slightly elliptical orbits around the Sun. The orbits can be described in terms of the semi-major axis ( a ) and eccentricity ( e ), as shown in the diagram (note that the orbit shown is much more elliptical than that of a real planet). The Table below lists the semi-major axis (in units 10 6 km) and the orbital period (in years) for each of the solar system planets. Planet Semi-major axis ( a ) (10 6 km) Orbital Period ( T ) (yr) Mercury 57.9 0.241 Venus 108.2 0.615 Earth 149.6 1.000 Mars 227.9 1.88 Jupiter 778.3 11.86 Saturn 1429 29.46 Uranus 2871 84.1 Neptune 4498 164.86 Pluto* 5915 248.6 * Pluto is no longer officially a “planet”, but we will include it anyway. Your job is to use the information in the table to analyze the relationship between the semi-major axis ( a ) and the period ( T ) of the orbits of the planets.
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 1. Open Excel and transfer the data above to two columns in the spreadsheet. 2. Use the spreadsheet to create two new columns containing the values of a and T in meters and seconds, respectively (1 year = 3.156 × 10 7 s). 3. Now, use the LOG10 function to compute the log of both variables in two more columns. 4. Create a graph of log( T ) versus log( a ), with log( T ) on the y-axis. The chart type should be “XY scatter”; do not choose the options that draw lines between the points. (Select the cells containing the data, click on the “Chart Wizard” button and follow the instructions.) 5. Perform a linear fit to the data, using the option to display the fit equation on the graph. (With the chart selected, choose “Add trendline…” from the Chart menu, select “Linear” and click on the “Options” button to display the equation.)...
View Full Document

{[ snackBarMessage ]}

### Page1 / 2

Physics II workshop_Part_33 - 1 Open Excel and transfer the...

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

View Full Document
Ask a homework question - tutors are online