![excel trendline equation excel trendline equation](https://www.childs.be/data/uploads/trendline.jpg)
The default trendline uses a linear equation, but there are several other options. The Format Trendline task pane will open: Right-click the data series and select Add Trendline. You’ll see that the data is non-linear:Įxcel is able to add trendlines to non-linear curves. Select the data and create an XY scatter chart. The worksheet contains pressure and flow data for a valve in a piping system. Excel has a few different options for fitting these curves. In those cases, you’ll need to use nonlinear methods.
![excel trendline equation excel trendline equation](https://www.online-tech-tips.com/wp-content/uploads/2020/11/linear-regression-trendline-8.png)
In engineering, you’ll encounter data than doesn’t follow a linear trend.