View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
MH MH is offline
external usenet poster
 
Posts: 28
Default Regression and the confidence intervals

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?