To create a linear graph in Excel (2007 version, although previous versions work in a similar manner): 1. Open a new document. 2. Enter the data to be graphed horizontally as shown below. The values appear above the y-axis values. x-axis 3. Highlight the cells with the data and click on and Choose the scatter plot “Insert” “Chart”. graph. 4. By right clicking on the axis, you can change the increments, gridlines shown and labels. You can also double-click the title to edit it if you wish. 5. To calculate slope: In the equation editor bar at the top of the screen, type in =SLOPE( , then in the brackets place the range of cells (highlighting the cells you want works also) in the y-value format FIRST CELL:LAST CELL. Notice in the example used here, the first was in B1 y-value and the last was in K1. Therefore, the range was B1:K1. y-value Using a comma to separate the range, enter in the range in the same way. y-value x-value 6. Press [ENTER] and the slope of the data will appear in the cell you originally clicked.
To create a linear graph in Excel (2007 version, although previous versions work in a similar manner): 1. Open a new document. 2. Enter the data to be graphed horizontally as shown below. The y-axis values appear above the x-axis values. 3. Highlight the cells with the data and click on “Insert” and “Chart”. Choose the scatter plot graph. 4. By right clicking on the axis, you can change the increments, gridlines shown and labels. You can also double-click the title to edit it if you wish. 5. To calculate slope: In the equation editor bar at the top of the screen, type in =SLOPE( , then in the brackets place the range of y-value cells (highlighting the cells you want works also) in the format FIRST CELL:LAST CELL. Notice in the example used here, the first y-value was in B1 and the last was in K1. Therefore, the y-value range was B1:K1. Using a comma to separate the y-value range, enter in the x-value range in the same way. 6. Press [ENTER] and the slope of the data will appear in the cell you originally clicked.
Physics_30_Lab_Manual.docx