Curve Fitting and Regression

Excel’s Solver add-in can be used to find the best-fit line for nonlinear data. Worksheet 07f contains the flow and pressure data that was used […]

The Excel Solver can be used to perform a least squares regression. For most situations, you can do regression using either trendlines in the chart

A Gaussian function has many different purposes in engineering although most people probably recognize it as a “bell curve”. Most commonly, it can be used

In engineering, you’ll encounter data than doesn’t follow a linear trend. In those cases, you’ll need to use nonlinear methods. Excel has a few different

You saw in the pressure drop example that LINEST can be used to find the best fit between a single array of y-values and multiple

Excel also can perform a regressions with a function. The function LINEST can find the equation of a best fit line through data. LINEST uses

Solver can also be used for a multiple linear regression analysis. For this section, we’ll be using the spreadsheet from the last section after working

You can use Excel to fit simple or even complex equations to data with just a few steps. Determine the Form of the Equation The