Interesting you are trying to solve this problem at this time. I am trying to
find the STDERR function between two points of my choseing in the past.
The only thing I have thought of, outside of rolling my own, is to create an
array for each possible period # I might use to fit my conditions of start and
stop points. Then code would have to be written to chose the appropriate array
and its value to build the final solution array. I'm still thinking about it
and am interested in the topic. Hope you find a solution.
Robert
"Charles J. Dudek" <[EMAIL PROTECTED]> wrote:
And how do I fix it. I'm getting a type mismatch error, but I can't
see where I'm trying to put an entire array into one cell.
aL[i] = LinRegIntercept( C [i] , Longcount[i] );
Does LinRegIntercept create an array? If so, how do I get around
that? I'm trying to create trendlines at various points throughout
the history that start and end based on other calculations. This is
driving me CRAZY!!!
Are there any examples of this kind of thing I could refer to? I know
I could use LineArray, but I also need to calculate standard
deviations based on the same periods, so I don't think that will help
me, will it?
Chuck
---------------------------------
Sponsored Link
Mortgage rates as low as 4.625% - $150,000 loan for $579 a month.
Intro-*Terms
