Results 1 to 2 of 2

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

  1. #1

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



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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

  2. #2
    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

    Quote Originally Posted by josiperez View Post
    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

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •