This preview has intentionally blurred sections. Sign up to view the full version.View Full 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
- Fall '09
- Solar System, Planet, Neptune, Semi-major axis