standard error of regression coefficient

I

iperlovsky

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,
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Standard Error of the Estimate 2
Regression Leverage Formula (Jerry W. Lewis or Mike Middleton)already have DFITS formula 2
Regression intercept to 0 2
Please help with Statistics Functions 4
Count...Sum...Faster...improvemens...; Have a good end of YEAR 2
VBA Code for Logit regression 1
VBA Coding for Logit Regression. 2
Regression Statistics are returned as Rounded to 1 vs. several dec 2

Top