28 Analysis II

Now we are going to try and see if we can quantify any of the work that was done by non-conservative forces. Before we move forward with this analysis, please remember to answer questions 4 and 5 to the best of your abilities.

1.  By empirically examining each of your three graphs, determine which graph and data you think best encapsulates the phenomena of air resistance in this experiment. We will be using this graph and data for the remainder of the lab. Note: the data you choose for this analysis should be consistent with your answer for question 5.

2.  Within Capstone, select two points on the graph of total Energy: one is the point at which the ball begins to fall and the other is the point when it collides.

3.  Record the time at which the ball begins to fall () and the total energy over mass () at that time into the report.

4.  Just below those recorded values, copy and paste the graph of energy with the two points presented on the graph into the report keeping it in a proper scale.

5.  Take this data, and export it from Capstone and import it into Excel. To do this:

a.  Select the “Export Data” option under the “File” tab.

b.  On the left hand side, deselect the “Position, Velocity, Acceleration, PE, and KE” values.

c.  Deselect from the “Time” category and “E/m” category any runs that are not your chosen run.

d.  Select the “Export to file…” in the bottom right corner.

e.  Name the file based on the type of ball used and one of the lab partners’ last name. Save it as a “csv” file and save it to your group’s lab folder.

f.  Import the file into Excel (this is where naming the file properly is valuable) by right clicking from File Explorer and opening with Excel. You can also import the data by starting Excel, selecting the open option, and then selecting the desired text file.

At this point, your Excel file should have two clear columns associated with it. One of them is for time and the other is for total energy. Using this data, generate a scatter plot which shows the difference between the initial energy and the energy for time after . To do this:

1.  Create a new column which calculates this difference before you create your plot.

2.  Insert a scatter plot into Excel which has the difference in energy on the y-axis, and time after on the x-axis.

3.  Copy this plot into the report and make sure it is properly titled and labeled. Your plot should only show the data from the start to the end of the fall. It should also be properly scaled so that your data fits nicely within the plot area (remember you can do this by clicking on your graph’s axis and selecting ‘Format Axis’). You will not be graded on the quality of your data for this part of the analysis. You will be graded on how presentable your graph is and how well your articulate arguments from it (so make sure you have proper titles and labels).