Episode 622 - LINEST Regression

Rather than using FORECAST to choose the next number, you can use LINEST to generate the slope and y-intercept of a line. Today’s podcast graphs the results of LINEST so you can see how Excel is forecasting the next number in a series. Episode 622 shows you how.

This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!