This preview shows pages 1–2. Sign up to view the full content.
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