can vba look up a value in the f distribution tables?
 

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