| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
can vba look up a value in the f distribution tables?
|
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
can vba look up a value in the f distribution tables?
bloomer -
can vba look up a value in the f distribution tables? < Yes. For example, the VBA statement RightTailProbability = Application.WorksheetFunction.FDIST(15.20686486,6, 4) would assign 0.01 to variable RightTailProbability, and CriticalValue = Application.WorksheetFunction.FINV(0.01,6,4) would assign 15.20686486 to CriticalValue. - Mike Middleton http://www.DecisionToolworks.com Decision Analysis Add-ins for Excel |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Distribution | Excel Worksheet Functions | |||
| Distribution of a Value | Excel Worksheet Functions | |||
| Any way to programmatically make pivot tables behave more like data tables? | Excel Programming | |||
| Extracting/Exporting HTML Tables or PDF Tables into Excel | Excel Programming | |||
| PIA distribution | Excel Programming | |||
Linear Mode
