Physics Graphing Using Excel Physicspages home物理作图使用Excel的物理页的家.pptVIP

Physics Graphing Using Excel Advantages of Graphing with Spreadsheet Programs Can be fast. Handles lots of data and multiple calculations. Precise calculation of equations. Disadvantages of Graphing with Spreadsheet Programs Students still need to be able to graph by hand. Students often do not use the correct type of graph or leave the equation in the proper format. Computers can not assess the importance of irregular data points. To graph data, it must be inputted into a spreadsheet program.Here is an example of data collected by a student. To select the data to be graphed, left click on the first cell with the data you want on the x-axis and hold down the button while you move down over the data. To select the y-data, hold down the ctrl button then left click and drag down. Click on Insert then Chart once the data has been selected. Select x-y scatter plot with no lines. Include a descriptive title, and label each axis. For example, the title Dy vs t is not descriptive. Be sure to include units. Unclick show legend Once you have a graph, double click on a data point. Give a value for the x and y error bars(the uncertainty). Generally the uncertainty should be half the smallest unit measurable by your measuring device. You may have to calculate the value on the spreadsheet and input using the “custom” selection. Click on Chart and add trendline. Choose the correct type of treadline. For linear relationships like F=ma, choose “linear”. For exponential relationships like d = ? at2?+ Vit choose “exponential” (Vi = 0) or “polynomial” (Vi non zero). Under options select that the equation be shown on the graph. Adjust the treadline as is appropriate for the data. Once you have an equation, click on it. Change the variables from x and y to the quantities you are graphing, like force or position. For polynomial equations, change the significant figures to a reasonable number now. If the curve is very