Excel 4.0, linest -> origin

Article View: comp.apps.spreadsheets

Article #305

Back to comp.apps.spreadsheets Previous Next

#305

From: ATG2G
Date: Mon, 25 Jan 1993 20:06

6 lines
528 bytes

Has anyone experienced difficulty with nonsense output generated
by, e.g., =LINEST(YRANGE,XRANGE,FALSE,TRUE) ?  Using effect coding
in the x-range, I find that linest is returning negative SSs, etc.

Conrad Carlberg

Technical Details

Message-ID: <93025.130631ATG2G@ASUACAD.BITNET>

Path: arc1-ca.pugleaf.net!sparky!uunet!destroyer!gatech!asuvax!asuacad!atg2g

Show Full Headers

Complete Article Headers

Path: arc1-ca.pugleaf.net!sparky!uunet!destroyer!gatech!asuvax!asuacad!atg2g
Organization: Arizona State University
Date: Monday, 25 Jan 1993 13:06:31 MST
From: <ATG2G@ASUACAD.BITNET>
Message-ID: <93025.130631ATG2G@ASUACAD.BITNET>
Newsgroups: comp.apps.spreadsheets
Subject:    Excel 4.0, linest -> origin
Lines: 7