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
Bookmarks