Learn Programming

Excel Data Regression

A frequent activity for scientists and engineers is to develop correlations from data. By importing the data into Excel, data analysis such as statistics, trending, or calculations can be made to synthesize the information into relevant and actionable information. This tutorial demonstrates how to create a linear or polynomial functions that best approximate the data trend, plot the results, and perform a basic statistical analysis.

Linear and Polynomial Regression

Nonlinear Regression

• Excel Nonlinear Regression Example Spreadsheet

Both regression tutorials can also be completed with Python and Matlab. Click on the appropriate link for additional information.

There is additional information on regression in the Data Science online course.