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.
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|