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

's Computer Specifications

's Computer Specifications

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

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Adding distribution lists to a master distribution list.	OldCoder	Microsoft Outlook Form Programming	1	8th Jan 2008 09:01 PM
Adding mutliple distribution lists into a distribution list?	=?Utf-8?B?QWJlbA==?=	Microsoft Outlook Contacts	2	30th Aug 2006 05:51 PM
Distribution list1 links to shows distribution list2	=?Utf-8?B?RnJ1c3RyYXRlZFVzZXI=?=	Microsoft Outlook Contacts	1	3rd Jul 2006 09:44 PM
Row height and distribution in Tables	=?Utf-8?B?Sm8=?=	Microsoft Word Document Management	3	30th Dec 2005 06:01 PM
Re: Pivot tables cell distribution	Debra Dalgleish	Microsoft Excel Misc	0	11th Sep 2003 11:22 PM