When preforming a regression analysis, it gives us two cinfidence interval.
The first one if for Beta1, what is the second for?

If the fit is to the function y = ax +b then there will be a confidence
interval for both coefficients (a and b)
See also
http://people.stfx.ca/bliengme/Excel...onfidence2.htm
best wishes

--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Denis" wrote in message
...
When preforming a regression analysis, it gives us two cinfidence
interval.
The first one if for Beta1, what is the second for?

Denis -

The top row of the Coefficients section is for the Intercept. Each other row
is for an explanatory variable. In the Regression tool dialog box, if you do
not check the box for Confidence Level, each row contains Lower and Upper
bounds for a 95% interval, followed by duplicate values. If you do check the
box for Confidence Level, and if you enter a specific value like 99%, each
row contains Lower and Upper bounds for a 95% interval and Lower and Upper
bounds for a 99% interval.

- Mike Middleton
http://www.DecisionToolworks.com
Decision Analysis Add-ins for Excel


"Denis" wrote in message
...
When preforming a regression analysis, it gives us two cinfidence
interval.
The first one if for Beta1, what is the second for?

Hi Mike,
I couldn't post a new message, sorry, so I tagged a related question as a
response to this string..

Question: Now that I used the analysis toolpak to perform regression
analysis with the box for confidence level checked and a value entered, is
there a way to have a line of confidence drawn to predict the point at which
it intersects the x axis in the future? I need to graphically represent this
for predicting an endpoint.

Thanks for your help.
MH

"Mike Middleton" wrote:

Denis -

The top row of the Coefficients section is for the Intercept. Each other row
is for an explanatory variable. In the Regression tool dialog box, if you do
not check the box for Confidence Level, each row contains Lower and Upper
bounds for a 95% interval, followed by duplicate values. If you do check the
box for Confidence Level, and if you enter a specific value like 99%, each
row contains Lower and Upper bounds for a 95% interval and Lower and Upper
bounds for a 99% interval.

- Mike Middleton
http://www.DecisionToolworks.com
Decision Analysis Add-ins for Excel


"Denis" wrote in message
...
When preforming a regression analysis, it gives us two cinfidence
interval.
The first one if for Beta1, what is the second for?