Microsoft Excel provides graphing capabilites on many levels. We will look at several ways to use these tools.
Illustration 1 :
Graph a line given two points on the line ---> (4, 2) and (6, -8)
Steps:
1. Enter x-coordinates in one row and y-coordinates in another row.
2. Click on the graphing icon.
3. Highlight the data range (cells containing the x and y-coordinates).
4. Choose Series and highlight the two x-coordinates for the X-Values and the two y-coordinates for the Y-Values.
5. Add titles for the chart, x-axis, and y-axis.
6. Place the chart as an object in Sheet 1.
Click here to see what the graph should look like.
Illustration 2 :
Graph a scatter plot based on a set of data.
1. Enter the data into an Excel worksheet.
3. Choose the XY (scatter) chart type.
4. Choose only cells containing values for the data range.
5. Add appropriate titles for the chart, x-axis, and y-axis.
6. Place the chart as object in Sheet 1.
Click here to see what the graph will look like.
Illustration 3 :
Based on the scatter plot in Illustration 2, we can write an equation for the graph. Even though the graph is not a perfect line, it does "approximate" a line. We can draw a line (called a "line of best fit") following the path of the data making sure to cross through at least two data points. Based on these two points, we can find a slope and writewhat we call a "prediction equation".
Using the data above, let's write an equation.
The "line of best fit" goes through the data points (102, 98) and (67, 33). Based on this information, we know the slope is . Using this slope and one of the points we arrive at an equation y = .94x - 30.115.
We can now use this equation to make "predictions". For example:
Assignment 1:
1. Create an Excel worksheet containing a table with to coordinates (6, 2) and (-2, -9).
2. Graph these points using Excel. Place the graph below the worksheet. Be sure to include appropriate titles.
3. Place your name on the worksheet and print a copy.
Assignment 2:
1. Using the data below, set up an Excel worksheet with this data.
2. Create an XY scatter plot based on this data. Include appropriate titles.
3. Place your name on the graph and print a copy. Draw a line of best fit and find the following information:
slope (m)
relationship between the data positive negative
prediction equation
Return to Instructional Unit