1 / 2

Excel Regression Model: Derivation and Analysis for OLS Estimators

Learn how to derive OLS estimators, interpret larger models, and analyze residuals using Excel. Detailed steps, plots, and calculus are covered to ensure you can diagnose problems and conduct thorough regression analysis. Exam procedures outlined clearly for submission.

mayten
Download Presentation

Excel Regression Model: Derivation and Analysis for OLS Estimators

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Review • Regression Model Assumptions • Calculus • Derivation, critical points (Excel, plots, etc.) • Deriving OLS estimators (b0, b1) • Excel calculation of OLS results • Steps, plots, analysis • Larger models • Model interpretation • Residual Analysis • Diagnosing problems

  2. Exam Procedures • Exam will be posted at noon today • Posted on the class schedule page • Honor code • Open book • Exam Product • Turn it in hard-copy form • Word, Excel and SPSS files • Drawing graphs as well as tables • Due Tuesday, March 7, 9am • Electronic (MS Word) files submitted via e-mail • Better late than dead, but not by much!

More Related