Thread: can vba look up a value in the f distribution tables?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Mike Middleton Mike Middleton is offline
external usenet poster
  
Posts: 762
Default 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 With QuoteReply With Quote