F-Test function for database

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 10: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 13: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 14: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 16: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]