F-Test function for database

This is an archived low-energy page for bots and other anonmyous visitors. Please sign up if you are a human and want to interact.

Win has asked for the wisdom of the Perl Monks concerning the following question:

Dear Monks,

I am presently building a database system using a Perl DBI connection to MS SQL Server (97). Is there any possibility that I can access Excel functions? I am particularly need to use the F test function. Maybe there is a suitable Perl module for this purpose?

Comment on F-Test function for database

Replies are listed 'Best First'.
Re: F-Test function for database by gjb (Vicar) on Jan 21, 2004 at 05:36 UTC
You'd best have a look at the CPAN modules dealing with Statistics. There are a few that implement T-tests, but I'd have to browse them to see whether there's one defining an F-test directly, although Statistics::Distributions may be helpful. Hope this helps, -gjb-	[reply]
Re: F-Test function for database by DrHyde (Prior) on Jan 21, 2004 at 08:28 UTC
I expect that Win32::OLE is what you need.	[reply]
Re: Re: F-Test function for database by Anonymous Monk on Jan 21, 2004 at 09:35 UTC
Can anybody share their experiences of using Excel functions with the Win32::OLE module?	[reply]
Re (3): F-Test function for database by VSarkiss (Monsignor) on Jan 21, 2004 at 11:43 UTC
There are many nodes on this topic, foremost of which is the excellent tutorial Using Win32::OLE and Excel - Tips and Tricks by cacharbe. Use Super Search and you can find many others.	[reply]

• hippo

‥ epoptai's answer Re: how do I set a cookie and redirect was blessed by hippo!

• erzuuli

‥ Anonymous Monks are no longer allowed to use Super Search, due to an excessive use of this resource by robots.


Syntactic Confectionery Delight
	PerlMonks