Sample Question #49 (general computing – Excel)
There are at least two ways in Excel to perform an OLS regression. What are they? What are some of the limitations of doing OLS in Excel (as opposed to using a real statistical package like EViews, Stata, R, S-Plus, or SAS)?
(Comment: Excel is extremely important on Wall Street, for both quants and non-quants. If you don’t have Office on your personal computer yet, the Microsoft Office Home and Student 2007 edition is only $121.99. BTW, unlike with versions past, anyone can buy the Home and Student edition, not just students or educators.)