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

G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I get LINEST to show all stats? 2
Accessing individual elements of an array returned by a function 1
How do I return the value of an adjacent cell? 2
how to use linest to get the result as ARRAY? 1
Function to extract data from a list 2
Lookup within a 2 dimensional array 5
Looking a value up for a 1
Alternative to Application.Caller in array functions to avoid wrong results? 10

Top