View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Jerry W. Lewis
 
Posts: n/a
Default how to get covariance of the estimated coefficients using exce

LINEST does multiple regression, as does the Regression tool in the Analysis
ToolPak. Neither gives the covariance of estimates.

Jerry

"robert111" wrote:


If you know the statistical formulas for these, write appropriate
formulas. I know Excel does linear regression and has slope and
intercept functions but not sure about multiple regression, check tools
add-ins.


--
robert111
------------------------------------------------------------------------
robert111's Profile: http://www.excelforum.com/member.php...o&userid=31996
View this thread: http://www.excelforum.com/showthread...hreadid=529497