LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 837
Default Another LINEST bug

Help for LINEST states that

The array known_x's can include one or more sets of variables. If only one
variable is used, known_y's and known_x's can be ranges of any shape, as long
as they have equal dimensions. If more than one variable is used, known_y's
must be a vector (that is, a range with a height of one row or a width of one
column).

In particular,
=LINEST({1,1.5;2.5,3},{1,2;2,3},,TRUE)
should be equivalent to either
=LINEST({1;1.5;2.5;3},{1;2;2;3},,TRUE)
or
=LINEST({1,1.5,2.5,3},{1,2,2,3},,TRUE)

Prior to 2003, they were equivalent (as documented), but in Excel 2003, not
even the degrees of freedom for =LINEST({1,1.5;2.5,3},{1,2;2,3},,TRUE) match
the documented behavior.

What happens in 2007?

Jerry
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Linest baron2ci Excel Worksheet Functions 0 April 8th 08 12:46 AM
LINEST bug Mark Schreiber Excel Worksheet Functions 2 April 27th 07 07:26 PM
LINEST() Bove Farm Excel Worksheet Functions 1 May 29th 06 05:54 AM
LINEST pjk@boro Excel Discussion (Misc queries) 2 February 20th 06 09:56 AM
Linest - Why did they do that? cseeton Excel Discussion (Misc queries) 2 March 11th 05 12:45 PM


All times are GMT +1. The time now is 04:44 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"