Regression - Standard Error X Variable 1

C

Claude S

I am using Tools > Data Analysis > Regression to generate a "Summary Output"
and am trying use a formula / function to generate some of the data in that
output. I have been able to recreate the R Squared, Slope and determined
that the t Stat is the slope of X Variable 1 divided by the Standard Error of
X Variable 1. I have not been able to recalculate the Standard Error of X
Variable 1. I used the help function to find the formula for the Standard
Error, but have not been able to figure out all the variables to recalculate
the formula.
 

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

Regression Leverage Formula (Jerry W. Lewis or Mike Middleton)already have DFITS formula 2
residual plots in multiple regression 1
Regression Analysis on Excel 2
LINEST and Dynamic Regression 0
Problem with SET & REF function 0
Regression with zero intercept 2
Regression gives slope of zero when x values smaller than 10^-7 4
Problem with array ref (I think!) 10

Top