What’s the Point?
In the real world, data doesn’t all line up, but it’s still very useful to use equations to work with that data.
TL;DW

Even though real world data isn’t smooth. Spreadsheets can fit a trendline to scattered data and come up with an equation that can be used to better understand the data.

For a line, the equation looks something like:
This is a straight line with a slope of .7 and a Y Intercept (vertical offset) of 1.5
Prev: Y Intercept  Next: Calculate Curve Slope  The example worksheet 
Khan Academy 