How to Find the Y-Intercept and Slope in an OpenOffice Graph

Save

OpenOffice is an office-software suite that can be downloaded for free. OpenOffice includes a word processor, spreadsheets and presentation software. The spreadsheet feature can be used to input data and plot the data on a graph. OpenOffice will calculate the slope between two points on a graphed line and the y-intercept of a graph when the user inputs an equation.

  • Locate the portion of the line graph for which you want to calculate the slope. Locate the point at the top of the line segment and the point at the bottom of the line segment. The slope of one line can be different if the line is not completely straight. You have to choose a segment of the line for calculating slope accurately. To calculate the y-intercept, you only need two points on a line.

  • Open OpenOffice Calc and enter the following formula into any cell on the spreadsheet:

    =SLOPE(y-values,x-values).

    In the place of "y-values" and "x-values," enter the y-coordinates of your two points separated by a semicolon. For example, =SLOPE(B4:B10, A5:A8).

    Enter the following formula in a cell above or below the row you used to calculate slope:

    =INTERCEPT(y-values,x-values).

    You can enter the same two x- and y-coordinates you used to calculate slope.

  • Press "Enter" to calculate the slope and y-intercept. The answer will be displayed in a box to the left of the formula you entered.

References

  • Photo Credit Thinkstock/Comstock/Getty Images
Promoted By Zergnet

Comments

Related Searches

M
Is DIY in your DNA? Become part of our maker community.
Submit Your Work!