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.