Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1,231
Default LINEST using only some of the values in an array

Incoherent wrote...
I want to perform a 4th order curve fit on some values in an array.
I have a list of X values and a list of Y values, the X values are
not in any particular order and there are in some cases multiple
instances of a given X value. I want to make a curve fit on the Y
data only when the corresponding X values are between some set
limits, set in seperate cells.


Mathematically incoherent. If you had multiple X values between bounds
A and B, you're going to pull all the X values if you use criteria A
<= X <= B. And if you have duplicate X values, you can't use LINEST.

If you mean you have some other variable (like row number) you could
use to isolate subsets of your X values that would all be distinct,
then you could use something like

=LINEST(N(OFFSET(Y,LARGE((A<=ROW(X))*(ROW(X)<=B)*( ROW(X)-MIN(ROW(X))
+1),
ROW(INDEX(1:65536,1,1):INDEX(1:65536,B-A+1,1)))-1,0,1,1)),
N(OFFSET(X,LARGE((A<=ROW(X))*(ROW(X)<=B)*(ROW(X)-MIN(ROW(X))+1),
ROW(INDEX(1:65536,1,1):INDEX(1:65536,B-A+1,1)))-1,0,1,1))^{0,1,2,3,4})

Reply
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 using only some of the values in an array Incoherent Excel Worksheet Functions 2 May 23rd 07 02:22 PM
LINEST using only some of the values in an array Lori Excel Worksheet Functions 0 May 23rd 07 01:30 PM
LINEST using only some of the values in an array Lori Excel Worksheet Functions 0 May 23rd 07 01:30 PM
LINEST using only some of the values in an array Lori Excel Worksheet Functions 0 May 23rd 07 01:29 PM
how to use linest to get the result as ARRAY? frank Excel Worksheet Functions 1 May 7th 07 06:49 AM


All times are GMT +1. The time now is 07:43 AM.

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"