Excel statistics?

[hillstepheng]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

Am I able to calculate a Durbin-Watson statistic in Excel 2008 in order to measure the autocorrelation of the independent variables in a multi-variate time series analysis? If so, how?

 

[JE McGimpsey]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

Am I able to calculate a Durbin-Watson statistic in Excel 2008 in order to
measure the autocorrelation of the independent variables in a multi-variate
time series analysis? If so, how?

Sure. A quick Google found this:

http://paws.wcu.edu/jarrell/mehodwstat.htm

and an example worbook at

http://www.wwnorton.com/college/econ/mec5/spreadsheets/19Ch5RC5aDW.xls

OTOH, you must of course recognize the limitations (primarily in
precision) of any version of XL in calculating advanced statistics. In
general, serious statisticians use dedicated statistics packages.