Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Claude S
 
Posts: n/a
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike Middleton
 
Posts: n/a
Default Regression - Standard Error X Variable 1

Claude S -

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

- Mike
www.mikemiddleton.com

"Claude S" wrote in message
...
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



  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jerry W. Lewis
 
Posts: n/a
Default Regression - Standard Error X Variable 1

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.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
regression swissforestry Excel Worksheet Functions 1 November 11th 05 12:59 AM
formula for linear regression DBane Excel Worksheet Functions 14 September 1st 05 09:54 PM
mutiple regression help happycow Excel Discussion (Misc queries) 1 July 30th 05 04:47 AM
why is it saying sheetcnt is "variable not defined" how to do a global variable to share over multiple functions in vba for excel? Daniel Excel Worksheet Functions 1 July 9th 05 03:05 AM
I Need VBA Assistance for global variable question Brent E Excel Discussion (Misc queries) 1 March 1st 05 09:46 PM


All times are GMT +1. The time now is 07:01 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"