In Excel 2003 there used to be a way of getting the program to take 2 arrays and have excel return a regression which included intercepts, T-stats, standard deviations, etc. (i.e. standard format). You could access it through the "data" toolbar.
Anyways, I've recently switch to the 2010 version of excel, and while I'm sure it has something that returns a regression table in standard format i'm having a difficult time finding it. Does anyone know where I can find it?
Anyways, I've recently switch to the 2010 version of excel, and while I'm sure it has something that returns a regression table in standard format i'm having a difficult time finding it. Does anyone know where I can find it?