Physical Pendulum Analysis
You should clear the information in the top rows and keep the column headings. Select all cells (by clicking on the top left diamond icon) and use Data->Sort->(click the My List has Header row option) and select Sort by Gate State. This procedure will create a list without gaps of your times and speeds. Delete the extra data.
Use R1C1 type display. Delete the entire third column (Select the column and use Control-k). The measured v values are now in Column 3. In the second column create a set of times starting from 0 to replace the Gate State values, which you no longer need. Do this procedure by entering an equation in which you subtract from each time in Column 1 the first time value in Column 1. You will need to use both a relative cell reference and an absolute cell reference.
Set the values in Column 4 equal to v2 . The header for this column should be "v^2-meas".
Into the first two cells of Col 1 enter "Ampl" and "tau". Into the first two cells of Col 2 enter the initial value of v2 and a good guess for tau.
The header for Col 5 should be "v^2-expon". In Col 5 select cells from below the header down to the end of the data. Use absolute and relative addresses to insert into those cells the equation =A*exp(-t/tau). Enter into each of the cells in Column 6 the square of the difference between the corresponding cells in Col 4 and 5 {i.e., (v^2-meas - v^2-expon)2 }. Skip one row at the end of Column 6 and enter into the next cell down the sum of the cells in Column 6. This value is the sum of the squares of the differences between the measured and model values.
Create a graph of "v^2-meas" and "v^2-expon" vs time. Do this procedure as follows: Select the values of Columns 2, 4 and 5 from the headings to the end of the data. Because the columns are discontinuous, select 4 and 5, hold down the command key, and then select column 2. Go to Insert Chart and create an x-y scatter graph. Make sure that the model values are plotted as lines only (no markers), and the v^2-meas data are markers only (no connecting lines).
Go back to the spreadsheet and choose Solver. Solver is found under the Tools Menu in Excel 5 . For "Set Cell" enter the absolute address of the sum of squares in Column 6. Do this by typing the address or clicking on the cell. For "Equal To" select Min. For "By Changing Cell" enter R2C2,R1C2. After you hit Return, Excel will calculate the best values for tau and A to minimize the difference between the exponential model and experimental curves. Excel will provide the "best fit" to the data and plot the corresponding curve.
NOTE. You do NOT have to re-enter this procedure for each of the other three physical pendulum data sets. Having saved the original Excel analysis worksheet and graph, copy the data from Logger Pro into the spreadsheet starting at the Row 11 Col 1. The values in all Columns will automatically change their values according to the new data. Use either Clear or Fill Down to adjust to the number of rows on the new sheet. Enter a new cell for the sum of squares and then use Solver on the sheet. Save the new worksheet and new graph.