ExcelBanter - standard error of regression coefficient

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - standard error of regression coefficient (https://www.excelbanter.com/excel-worksheet-functions/247294-standard-error-regression-coefficient.html)

iperlovsky

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,

All times are GMT +1. The time now is 11:08 AM.