# Curve Fitting and Regression

## Using Excel Solver for Nonlinear 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 […]

## Using Excel Solver for Linear Regression

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

## Gaussian Fit in Excel

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

## Nonlinear Curve Fitting in Excel Using Charts

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

## Multiple Linear Regression in Excel

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

## Dynamic Linear Regression in Excel with LINEST

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

## How to Use Excel Solver for Multiple Linear Regression

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

## How to Fit an Equation to Data in Excel

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

Scroll to Top
Complete... 50%