We recommend playing the videos in the order listed.
Regression on Chart: This shows how to have Excel add a trendline (linear or curved) to a scatterplot, and to have the regression equation displayed.
Linear Regression via Excel Functions: This continues the regression example, showing how to calculate the linear regression equation using the Excel functions SLOPE, INTERCEPT, CORREL, and TREND.
Regression via LINEST: This continues the regression example, showing how the LINEST Excel function can calculate a linear regression line.
Regression via Solver: This continues the regression example, showing how the Excel Add-in Solver can calculate a Best-Fitting-Least Squares regression line. Also, a Best-Fitting Least Absolute-Value line is calculated.
Quadratic Regression via LINEST: This continues the regression example, showing how the LINEST Excel function can calculate a quadratic regression line.
Quadratic Regression via Data Analysis: This continues the regression example, showing how the Excel Add-in Data Analysis can calculate a quadratic regression line. This will be the method used for Multiple Regression problems.
These lessons were designed for high speed access. They may work with a 56K modem; however, there will be delays as the videos buffer. If you need help viewing or listening to the videos, or downloading the free plug-ins, Click