regression results without using the wizard

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: dreamz <dreamz.227h90_1138218304.3748@xxxxxxxxxxxxxxxxxxxxx>
Date: Wed, 25 Jan 2006 13:40:31 -0600

i have several independent variables and i want to run a multiple
regression on them. for now, i'm only interested in the r-sqared and
the p-values. is it possible to calculate the r-squared and p-values
for the independent variables with a worksheet function?

thanks.

--
dreamz
------------------------------------------------------------------------
dreamz's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=26462
View this thread: http://www.excelforum.com/showthread.php?threadid=505061

.

Follow-Ups:
- Re: regression results without using the wizard
  - From: Bernard Liengme

Prev by Date: Re: how can i use concatenate to create a linking formula?
Next by Date: Re: Allowing for a range using COUNTIF
Previous by thread: Allowing for a range using COUNTIF
Next by thread: Re: regression results without using the wizard
Index(es):
- Date
- Thread

Relevant Pages

Re: multiple regression question
... contribute significant to the regression results. ... Since x1,x2 and x4 are significantly correlated, the multiple ... the corresponding P-values will be different. ... Remember that the math will take advantage of spurious correlations ...
(sci.math.num-analysis)
Relationship investigation with large dataset
... I want to investigate the relationship between 6 independent variables ... The p-values of 30 multivariate ANOVA tests are used in a T-test to ...
(sci.stat.math)
Re: Relationship investigation with large dataset
... Richard Ulrich wrote: ... >> I want to investigate the relationship between 6 independent variables ... A multivariate ANOVA for example, where I want to test if the p-values ...
(sci.stat.math)
relationship investigation with large dataset
... I want to investigate the relationship between 6 independent variables ... variables because I cant argue that they are of interval scale.). ... The p-values of 30 multivariate ANOVA tests are used in a T-test to ... investigate wether the p-values of ANOVA's are less than 0.05 or not. ...
(sci.math)
Re: The latest bike lane research
... Stepwise regression indication (Pg. ... "Separate regression models used these independent variables to explain ... Earlier they state that their paid cyclists " ... recreationalist is 70% of trips are for recreation. ...
(rec.bicycles.misc)