Thread
:
Linear Regression
View Single Post
#
5
Posted to microsoft.public.excel.worksheet.functions
Mike Middleton
external usenet poster
Posts: 762
Linear Regression
Al Boccia -
If you have a single X variable, you could use worksheet functions
INTERCEPT, SLOPE, RSQ, and STEYX. But if you need other diagnostics or if
you have multiple X variables, you'll have to figure out how to use LINEST
or use statistical software.
- Mike Middleton
http://www.DecisionToolworks.com
Decision Analysis Add-ins for Excel
"al boccia" <al
wrote in message
...
I have been struggling to get the LINEST function to work for me. I have
checked out the instructions for the function, and have followed them
carefully, but I can't get LINEST to return either the basic results
(slope
and intercept) or the full array of output (with the STATS option set to
TRUE
(or 1). I am entering the formula as an array formala, as instructed. No
matter what I do, all I get is the slope result as a single number.
Any suggestions would be greatly appreciated.
Al Boccia
Reply With Quote
Mike Middleton
View Public Profile
Find all posts by Mike Middleton