On 29 Jan 2000, Ailc1 wrote:
> I am using Excel to perform a linear regression analysis. Excel does
> not compute significance level.
Of course not. Significance level cannot be computed: it is an
arbitrary choice of the investigator (or the analyst). Commonly set at
0.05, aka 5%, but other values are also be used. Presumably what you
want to compute is the observed probability of the results given the null
hypothesis; if this probability <= the significance level chosen, the
results are said to differ significantly from the null-hypothetical value
at that significance level.
> At best, I have to use computations it makes of F, etc. and then go to
> hard copies of F and Student's t distribution tables.
Which, presumably, is better than having to carry out the
computations with a calculator (or with pencil & paper & one's personal
interauricular computer !=). Although it has been suggested on this list
that Excel's standard computations often leave something to be desired.
> Anyone know of shareware that computes [the probability value] given
> degrees of freedom v1 and v2?
Sorry, I don't; I use a statistical package (Minitab, mostly)
for statistical computations, and the distribution functions are built
in, available for use even when the desired p-value is not part of the
standard output. There are Excel users on the list, however, and some of
them may be able to offer useful advice.
-- DFB.
------------------------------------------------------------------------
Donald F. Burrill [EMAIL PROTECTED]
348 Hyde Hall, Plymouth State College, [EMAIL PROTECTED]
MSC #29, Plymouth, NH 03264 603-535-2597
184 Nashua Road, Bedford, NH 03110 603-471-7128
===========================================================================
This list is open to everyone. Occasionally, people lacking respect
for other members of the list send messages that are inappropriate
or unrelated to the list's discussion topics. Please just delete the
offensive email.
For information concerning the list, please see the following web page:
http://jse.stat.ncsu.edu/
===========================================================================
