View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
al boccia[_2_] al boccia[_2_] is offline
external usenet poster
 
Posts: 2
Default Linear Regression

Thanks Chip and Dana. I have been selecting a range of cells large enough to
hold the results array before specifying the formula. No luck. I have pretty
much given up on using EXCEL for this task. Going to put my data in SPSS,
which is going to be painful but its all I can think of at this point.

Any other thoughts most welcome.

Al Boccia

"Chip Pearson" wrote:


Not only do you need to enter the function as an array formula, you
must enter it in a range of cells, not a single cell. Since the
function returns an array of values, it must be entered into a range
big enough to display all the return values. E.g., select range A1:C5,
type the formula and press CTRL SHIFT ENTER.

Cordially,
Chip Pearson
Microsoft MVP
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)

On Thu, 11 Dec 2008 14:11:02 -0800, al boccia <al
wrote:

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