Article View: comp.sys.mac
Article #5292multiple regression analysis in excel 2.2
From: Dave Kearney
Date: Tue, 26 Sep 1989 16:02
Date: Tue, 26 Sep 1989 16:02
31 lines
1733 bytes
1733 bytes
Greetings,
On page 250 of the Excel 2.2 reference manual Microsoft mentions that
they support multiple regression analysis. Unfortunately, I cannot
seem to locate any other references to functions, macros, or even
examples that suggest this capability. I have seen single variable
regression functions but no multiple regression functions. When I
called Microsoft customer support they 1) had no idea what I was
talking about and 2) told me they would call me back. I have not heard
from them (2 weeks now) so I thought I would ask the net.
Has anyone done multiple regression analysis using Excel? I remember
an article in Byte about 8 or 9 months ago about using Excel 1.5 for
this. Has anyone typed this in that can send a stuffit/binhex'ed
version to me?
I guess the real question is: has Microsoft added functionality to excel
2.2 that makes multiple regression analysis easy or have they just expanded
their documentation to reference a spreadsheet that someone wrote once?
Thanx for your help.
Dave
--
David A. Kearney MIPS Computer Systems, Inc.
{ames,decwrl,pyramid}!mips!dak 928 Arques Ave. Sunnyvale, CA 94086
dak@abbott.mips.COM (dak%mips.COM@ames.arc.nasa.gov) +1 408 991-0481
====== I'm not a fatalist... But even if I was, what could I do about it? ======
Technical Details
Message-ID:
<28261@abbott.mips.COM>Path:
arc1-ca.pugleaf.net!utzoo!attcan!utgpu!jarvis.csri.toronto.edu!mailrus!uwm.edu!uakari.primate.wisc.edu!ginosko!brutus.cs.uiuc.edu!apple!mips!dakShow Full Headers
Complete Article Headers
Path: arc1-ca.pugleaf.net!utzoo!attcan!utgpu!jarvis.csri.toronto.edu!mailrus!uwm.edu!uakari.primate.wisc.edu!ginosko!brutus.cs.uiuc.edu!apple!mips!dak From: dak@mips.COM (Dave Kearney) Newsgroups: comp.sys.mac Subject: multiple regression analysis in excel 2.2 Keywords: regression excel Message-ID: <28261@abbott.mips.COM> Date: 26 Sep 89 16:02:24 GMT Lines: 31