VBA Excel 2013: how to use ATPVBAEN to calculate ANOVA one-way

[josiperez]

Hi,

I'm trying to help a guy to calculate ANOVA one-way to many (MANY) data ranges.
Manually it is ok: installed analysis toolpack and follow the questions suggested for ANOVA one-way.
I tried to keep each data range in a convenient row distance to create space to receive the ANOVA result, and, using formulas, catch only the parameters the guy is interested.
But I don't realize how to generate a formula to automatically calculate each range.
Example:
range 1 ANOVA one-way result
range 2 ANOVA one-way result
...
range N ANOVA one-way result

What I already did:
- installed the Analysis Toolpack for VBA in Excel 2013 and Solver (not sure if it is necessary)
- in Excel VBA, Tools-->References-->atpvbaen.xls

I can see on Project:
atpvbaen.xls (ATPVBAEN.XLAM)
solver.xls (SOLVER.XLAM)
vba projet 1 -> reference to atpvbaen.xlam

But, I don't find how to call ANOVA one-way: how are the parameters, the parameter order, and so on.
If I try to open atpvbaen.xls, excel asks for password.

Can anyone help me?

Thank in advance,
Josi Perez

[josiperez]

Sorry for the inconvenience, but can anyone give me an idea about how to call ANOVA using VBA?
Or pointers/tutorials about this subject?

Thanks in advance,
Josi Perez

Hi,

I'm trying to help a guy to calculate ANOVA one-way to many (MANY) data ranges.
Manually it is ok: installed analysis toolpack and follow the questions suggested for ANOVA one-way.
I tried to keep each data range in a convenient row distance to create space to receive the ANOVA result, and, using formulas, catch only the parameters the guy is interested.
But I don't realize how to generate a formula to automatically calculate each range.
Example:
range 1 ANOVA one-way result
range 2 ANOVA one-way result
...
range N ANOVA one-way result

What I already did:
- installed the Analysis Toolpack for VBA in Excel 2013 and Solver (not sure if it is necessary)
- in Excel VBA, Tools-->References-->atpvbaen.xls

I can see on Project:
atpvbaen.xls (ATPVBAEN.XLAM)
solver.xls (SOLVER.XLAM)
vba projet 1 -> reference to atpvbaen.xlam

But, I don't find how to call ANOVA one-way: how are the parameters, the parameter order, and so on.
If I try to open atpvbaen.xls, excel asks for password.

Can anyone help me?

Thank in advance,
Josi Perez