21 Part 4: Analysis
1. Transfer and
to Table 3 of the Results section for Part 4.
2. Calculate the remaining values in Table 3. You can use the excel sheet to do this. Note that the Part 4 worksheet has already pulled your values for and
from the Part 3 worksheet.
3. Plot a graph of versus
on Lab 3’s Excel workbook under Part 4 worksheet. To make your plot:
a. Highlight the values under the versus
column.
b. Then select the Insert tab and choose the Insert Scatter option under ‘Charts’. This will generate a graph from the two columns highlighted where the first column is the x-axis and the second column is the y-axis.
c. You can label the axes by clicking on your chart, selecting the “Chart Design” tab and then selecting the “Add Chart Element” option. This will allow you to customize many features of your plot.
d. **Important ** Make sure this graph is properly titled as it is a part of your grade. Also, properly scale your axes so that your data fits nicely within the chart area. To do this, right click on each axis, select ‘Format Axis’ and then play with the Minimum and Maximum bounds.
With your plot of vs.
, insert a trend line in a similar manner to what was done in Lab 2. As a refresher, you can do this by:
1. Clicking on a data point on your graph. This should highlight all of your data points.
2. Right click, which will open a window, and select ‘Add Trendline.’
3. From the pop-up window, select ‘Linear’ as well as ‘Display Equation on Chart’ and ‘Display R-squared value’.
Copy your graph with the trend line and equation into the Part 4 Results section of your report.
Record the slope and y-intercept of the best-fit line drawn through the data points (you will need these values in your future analysis).
In this experiment you are not required to calculate uncertainties for the values or show uncertainty ranges on the graph.
Question 5.



Next, plot a graph of versus
and determine the slope and intercept of the best-fit trendline through the data points. This is done in a similar manner to how the previous
versus
plot was made. Again, do not report uncertainties for these values on your graph or on your table. Make sure you report the trendline and the
value on your graph.
Question 6.


Question 7.



(Notice if all the masses are located at
for all i, then I=0. However, there is a finite size to the masses
and
in your experiment…)
Question 8.


Question 9.