View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
iperlovsky iperlovsky is offline
external usenet poster
 
Posts: 50
Default standard error of regression coefficient

Does anyone know how to calculate this using excel formulas?

Sb = Se/sqrt((x-xbar)^2)

Where Se = sqrt(sum((y-yhat)^2/(n-k-1)))

I imagin it can be replicated with mmult and transpose comb, but am not sure
how?

Thanks,