I almost forgot about that. Yes, I went to get the worksheets that you
posted. Thanks so much! This is really helpful.
> Stephanie -
>
[quoted text clipped - 15 lines]
> >
> > Stephanie
Mike,
I am having trouble with the ^{1,2} part of the Trend equation. I get an
error when I put that in. I know I must be doing something wrong.
Can you help?
Thanks,
Stephanie
> Stephanie -
>
[quoted text clipped - 15 lines]
> >
> > Stephanie
Mike Middleton - 21 Jul 2006 18:09 GMT
Stephanie -
You should use your judgment to decide whether the linear trend or the
quadratic trend is appropriate.
The quadratic trend uses ^{1,2} to obtain both x and x^2 values as
explanatory variables so that the fitted values have some curvature, i.e.,
polynomial of order 2, also called a quadratic.
The TREND function must be array-entered (and a formula that uses ^{1,2}must
be array-entered). To array-enter the function, select the range of cells
that will contain the function results, type the =TREND(...) function with
appropriate arguments but do not press Enter, instead after typing the
closing parentheses hold down Control and Shift keys while you press Enter,
thus "array-entering" the function.
- Mike
> Mike,
>
[quoted text clipped - 29 lines]
>> >
>> > Stephanie
Jerry W. Lewis - 22 Jul 2006 04:01 GMT
^{1,2} assumes that the data are in columns. Use ^{1;2} if the data are in
rows.
Jerry
> Mike,
>
[quoted text clipped - 26 lines]
> > >
> > > Stephanie