IBPhysics-UncertaintiesandDataGraphing：IB物理不确定性和数据图表.docVIP

IB Physics - Uncertainties and Data Graphing：IB物理不确定性和数据图表 IB Physics - Uncertainties and Data Graphing Excel Instructions Objective: the complete the Uncertainties and Data Graphing assignment in Microsoft Excel Procedure: 1) Enter the table from the class work handout into excel like so Note: I have flipped time and distance; this is done for graphing ease Note: you can add the lines around the table by using this tool at the top of the page 2) To graph the data we highlight the data required 3) Now go to insert at the top of the page and hit scatter with only markers This will produce a graph like so What you notice is that distance is graphed on the y axis and time is graphed on the x axis When highlighting data in excel for graphing, the column on the left will be graphed on the y axis, this is the reason I flipped time and distance in my table from what was given to you. 4) To add titles and labels to the graph we click on the graph, this should bring up chart tools at the top of the screen , in chart tools click layout 5) Add to your graph by clicking the appropriate buttons - Chart title - Axis titles 6) We can now add a trend line (line of best fit), notice this can be done in the same window (chart tools – layout) Add a linear trend line to your data 7) We can now add error bars to our data, remember we only need to add error bars to the measurement with the highest percentage uncertainty, thus a calculation is needed. I want you to do this in excel as well. Create the following table To perform calculations in excel we need to enter the = sign first; from here we can enter our specific operation. In this case to find the percentage uncertainly for time we divide the absolute uncertainty by a measurement and multiply by 100. Notice I did not have to enter in the measurement I simple entered the cell of which the measurement was in (cell b2 = 0.802s), now hit enter Do the same for distance So in the cell below enter =0.1/c2 * 100