How do I extract a single value from the linest array result?

's Computer Specifications

The linest function has an array output and I want to extract only one of the
available statistics -- okay maybe two. The one I really want is the
F-statistic. I could either calculate with a another formula or maybe do the
mutliple selection approach, but it would be great if I could actually pull
that statistic only.

's Computer Specifications

=INDEX(LINEST(ydata,xdata,,TRUE),4,1)

Jerry

"hil" wrote:

> The linest function has an array output and I want to extract only one of the
> available statistics -- okay maybe two. The one I really want is the
> F-statistic. I could either calculate with a another formula or maybe do the
> mutliple selection approach, but it would be great if I could actually pull
> that statistic only.

's Computer Specifications

Thanks!

Hil

"Jerry W. Lewis" wrote:

> =INDEX(LINEST(ydata,xdata,,TRUE),4,1)
>
> Jerry
>
> "hil" wrote:
>
> > The linest function has an array output and I want to extract only one of the
> > available statistics -- okay maybe two. The one I really want is the
> > F-statistic. I could either calculate with a another formula or maybe do the
> > mutliple selection approach, but it would be great if I could actually pull
> > that statistic only.

's Computer Specifications

You're welcome, glad it helped.

Jerry

"hil" wrote:

> Thanks!
>
> Hil

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to print LinEst result to a spreadsheet using VBA	Fei	Microsoft Excel Programming	3	4th Mar 2009 05:26 AM
Re: LINEST using only some of the values in an array	Harlan Grove	Microsoft Excel Worksheet Functions	0	23rd May 2007 07:19 PM
Re: LINEST using only some of the values in an array	Lori	Microsoft Excel Worksheet Functions	0	23rd May 2007 01:30 PM
Re: LINEST using only some of the values in an array	Lori	Microsoft Excel Worksheet Functions	0	23rd May 2007 01:29 PM
how to use linest to get the result as ARRAY?	=?Utf-8?B?ZnJhbms=?=	Microsoft Excel Worksheet Functions	1	7th May 2007 06:49 AM