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

H

hil

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

Linear Regression 8
how to use linest to get the result as ARRAY? 1
How do I get LINEST to show all stats? 2
LINEST using only some of the values in an array 2
Extracting data from Multiple columns to a Single row 3
LINEST function - data range 2
VBA to Find Key Words in Word doc then Extract Content to Excel.xlsm file 3
Accessing individual elements of an array returned by a function 1

Top