| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I extract a single value from the linest array result?
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I extract a single value from the linest array result?
=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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I extract a single value from the linest array result?
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. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I extract a single value from the linest array result?
You're welcome, glad it helped.
Jerry "hil" wrote: Thanks! Hil |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Number format | Excel Discussion (Misc queries) | |||
| convert numbers to text | Excel Discussion (Misc queries) | |||
| How can i change this VBA project According to Indian Numeric | Excel Discussion (Misc queries) | |||
| Is there a formula to spell out a number in excel? | Excel Worksheet Functions | |||
| Convert Numeric into Text | Excel Worksheet Functions | |||
Linear Mode
