A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Multivariable regression (t-stat)



 
 
Thread Tools Display Modes
  #1  
Old July 5th, 2004, 07:13 AM
external usenet poster
 
Posts: n/a
Default Multivariable regression (t-stat)

Im trying to run a multivariable regression using excel,
and was wondering what the t-stat variable represents.

How do I use it to know if that certain variable's
coefficient is statistically significant?

I read on some website that i have to compare it with (n-
k), but Im not sure how to compare it.

Thanks for the help.


  #2  
Old July 5th, 2004, 01:10 PM
Jerry W. Lewis
external usenet poster
 
Posts: n/a
Default Multivariable regression (t-stat)

I assume that you are are using the Regression tool in the Analysis ToolPak.

For each coefficient, you get the estimate and the standard error of
that estimate (also given by LINEST with the stats argument set to
TRUE). The t statistic is the ratio of the estimate (est) divided by
the standard error (se). This provides a test of whether the model
coefficient is actually zero. To test whether the model coefficient is
equal to some other pre-specified hypothesized value (hv), use
t = (est-hv)/se
The p-value is calculated by
TDIST(ABS(t),df,2)
is the probability of getting a t-statistic at least as extreme as was
observed with your data, if the hypothesized value (zero by default)
were known to be true. If that p-value is too small (often considered
to be 0.05, but that value is not set in stone) then the corresponding
coefficient is considered "statistically significant". The logic, is
that you choose to believe that the hypothesized value is wrong, rather
than believing that you have seen something unusual.

The ATP Regression tool also gives confidence intervals for the
coefficients, which may be more informative than a simple significance
test. The confidence interval indicates how much uncertainty is
associated with the estimate. If the 95% confidence interval for a
coefficient includes zero, then that coefficient is statistically
significantly different from zero at the 0.05 level (p-value =0.05)

This is a once over lightly of some concepts that are easily abused.
You would be well served to take a class or at least read a text on
statistics before assuming that you know much.

Jerry

wrote:

Im trying to run a multivariable regression using excel,
and was wondering what the t-stat variable represents.

How do I use it to know if that certain variable's
coefficient is statistically significant?

I read on some website that i have to compare it with (n-
k), but Im not sure how to compare it.

Thanks for the help.




 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Exponential regression Bernard V Liengme Worksheet Functions 1 April 8th, 2004 07:27 PM
Difference between regression in VBA and a worksheet function Nick M Worksheet Functions 1 April 6th, 2004 06:08 PM
'non-numeric data' error in regression tsumanii Worksheet Functions 0 February 17th, 2004 12:33 PM
Pooled regression and dummy variables Kev Summersgill Worksheet Functions 1 September 17th, 2003 09:16 PM


All times are GMT +1. The time now is 06:09 AM.


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