How can I run an F-Test Application?

**jdubyac** · 10-06-2008, 12:23 PM

I am trying to write a macro which will automatically run an F-Test from the Excell Add-Ins. I tried recording the macro using the data analysis and only got a code of:

Application.Run "ATPVBAEN.XLAM!Ftestv", , , "", False, 0.05

If I actually try to run that, I get a

Run Time Error 1004
Method 'Run' of object '_Application' failed.

I am not sure why this is happening and cannot locate help anywhere else.

Any help would be appreciated

**shg** · 10-06-2008, 12:37 PM

FTEST is available to VBA as a worksheet function:

Function F(r1 As Range, r2 As Range) As Double
    F = WorksheetFunction.FTest(r1, r2)
End Function

**jdubyac** · 10-06-2008, 12:55 PM

That's useful! But how do I set the Alpha value, or is it just a standard?

**shg** · 10-06-2008, 02:33 PM

Sorry, I don't know the answer.

**Unique01JOE** · 01-13-2011, 04:20 AM

I tried the following and it works

Application.Run "ATPVBAEN.XLA!Ftestv", Range("C214:F214"), Range("C215:F215"), Range("A220"), False, 0.05

where:

C214:F214 was my input value 1 range
c215:f215 was my input value 2 range
and A220 was my output range.

Hope this helps