----- Original Message -----
From: Zina Taran <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>;
Ailc1 <[EMAIL PROTECTED]>
Sent: Saturday, January 29, 2000 6:38 PM
Subject: Re: Shareware for Computing Significance Level?
> just click on the field "confidence level" to have that field
checked in
the
> regression analysis menu (from "data analysis") in Excel. That
one is the
> 95% one though. if you want a different one, there are built-in functions
> which I don't remember off the top of my head.
> cheers,
> ZT
---------------------------------------------------------------------
The EXCEL regression dialog box requests the following information: You have
to install the analysis ToolPak add-in macro to get this
About the Regression dialog box
Input Y Range
Enter the reference for the range of dependent data. The range must consist
of a single column of data.
Input X Range
Enter the reference for the range of independent data. Microsoft Excel
orders independent variables from this range in ascending order from left to
right. The maximum number of independent variables is 16.
Labels
Select if the first row or column of your input range or ranges contains
labels. Clear if your input has no labels; Microsoft Excel generates
appropriate data labels for the output table.
Confidence Level
Select to include an additional level in the summary output table. In the
box, enter the confidence level you want applied in addition to the default
95 percent level.
Constant is Zero
Select to force the regression line to pass through the origin.
Output Range
Enter the reference for the upper-left cell of the output table. Allow at
least seven columns for the summary output table, which includes an anova
table, coefficients, standard error of y estimate, r2 values, number of
observations, and standard error of coefficients.
New Worksheet Ply
Click to insert a new worksheet in the current workbook and paste the
results starting at cell A1 of the new worksheet. To name the new worksheet,
type a name in the box.
New Workbook
Click to create a new workbook and paste the results on a new worksheet in
the new workbook.
Residuals
Select to include residuals in the residuals output table.
Standardized Residuals
Select to include standardized residuals in the residuals output table.
Residual Plots
Select to generate a chart for each independent variable versus the
residual.
Line Fit Plots
Select to generate a chart for predicted values versus the observed values.
Normal Probability Plots
Select to generate a chart that plots normal probability.
---------------
>From above, the 95% is automatic, you have to enter another value, and you
will get results corresponing to the new value IN ADDITION.
For tests on the coefficients, apply the
TDIST function to the cells containing the standard error values of the
coefficients. TDIST has as inputs the cell containing the X value, the degrees
of freedom, and then whether you want one tail (1) or two tail(2) tests. The
function returns the p value
DAH
