Regression - Standard Error X Variable 1

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.
--
Claude S

Claude S -

Google search for "standard error of regression coefficient" (without the
quotes).

- Mike
www.mikemiddleton.com

"Claude S" <[email protected]> wrote in message
news:[email protected]...
>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.
> --
> Claude S

You might find
http://groups.google.com/group/micro...a03470e7a1c650
to be helpful.

Jerry

Claude S wrote:

> 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.