Fill Handle Regression - Episode 1187
A lot of behind-the-scenes math goes into dragging the fill handle...
Howie asks why the fill handle does what it does when you select four numbers and drag. Episode 1187 discusses trend lines, LINEST, and straight line regression.
...This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!