A PowerPoint that goes through linear regression using the method of least squares. There are three examples to go through, each with editable Excel spreadsheets within the slides. The lesson leads through exactly what the least squares method is trying to achieve and explains where the formulas come from. There are many different formats of the formulas available for linear regression. This PowerPoint uses the sum formulas (that must be solved simultaneously).
The second presentation is exactly the same as the first but with the tables filled in.
Note: these have been updated to make them a little more user friendly. To open the Excel spreadsheets you now need to click on the spreadsheet within the presentation. They will no longer open automatically on click (in case you don't want them to keep popping up).
The second presentation is exactly the same as the first but with the tables filled in.
Note: these have been updated to make them a little more user friendly. To open the Excel spreadsheets you now need to click on the spreadsheet within the presentation. They will no longer open automatically on click (in case you don't want them to keep popping up).
Something went wrong, please try again later.
Excellent resource! Thank you!
Excellent resource! Very good power points as they are well thought out and include good examples; easy to follow. Area for improvement? An accompanying worksheet perhaps?
Report this resourceto let us know if it violates our terms and conditions.
Our customer service team will review your report and will be in touch.
£0.00