Re: Using Excel for statistical analysis - a question for problem-solvers

Tech-Archive recommends: Fix windows errors by optimizing your registry

Well if Var1,Var2,Var3, and Var4 never change then this brute force
solution of listing all combinations will work for you.

If these variables vary - then you should post on a Operations
Research news group
(dynamic programming is a topic of Operations Research) news group and
ask an algorithic solution. You can work backwards from 29 and then
get a solution list. Probably in milliseconds using VBA.

Dynamic programming is not to be confused with computer programming.
Tee hee.

This enumeration is the classic beginners introduction to dynamic
programming. It's what you read on the first week of class.

Don't be suprised if it takes a few days for you to "get" it. Dynamic
programs are hard to graps if you haven't been introduced to them.

OTHO - if you don't know VBA well enough to program the solution on
your own (once you have it) - then you have no choice - brute force
enumeration is the only thing you can do.

Note that enumeration is very slow! But good enough for personal use
for 29!

On Feb 14, 12:05 pm, mrsethbull...@xxxxxxxxx wrote:
I have a business analytics problem and am looking for some advice.

I have 20 variables, each of which has a value assigned to it (Var1 =
5, Var2 = 8, Var3 = 6, Var4 = 10, Var5 = 2 and so on).

All of these 20 variables can exist in isolation or they can exist
with any combination of the other 19 variables.

What I would like to do is to be able to see all the possible
combinations of these variables in order to see the total values of
different combinations.  For example, if one combination is
(Var1+Var2+Var3+Var4 then the value would be 29).

Can anyone suggest how I would go about doing this? By hand, I figure
I would have to make thousands upon thousands of equations (if not
more).  So obviously, I'm trying to find a way to automate the
process.

I am well versed in MS Excel and Access.  I know a bit of VB, but not
much.

Any help would be appreciated.

SB

.

Relevant Pages

  • Re: Prediction of local code modifications
    ... cost functions) from the slow main memory to a small but fast memory ... If I understand your question right, the answer is 'dynamic programming'. ... Dynamic programming, which is neither dynamic nor programming, allows ...
    (comp.compilers)
  • Re: enum
    ... "The C Programming Language". ... No. a, b, and c are enumeration constants, not data types. ... The data type is "enum tag". ...
    (comp.lang.c)
  • Re: Great SWT Program
    ... to the computer variety. ... "Dynamic programming" is a technical term in algorithm ...
    (comp.lang.java.programmer)
  • Re: Recursion Usage and Concepts - Newbie Question
    ... I did all kinds of dynamic programming back in the days of Fortran ... you could handle tracking the history with recursion. ... private Mapsubresults ... ...
    (comp.lang.java.programmer)
  • Re: variable in sql query
    ... please do not use enumeration as "*". ... It's bad practice. ... only ovious values when you programming. ... thanks i tried, maybe it works or not, because when i use command String ...
    (comp.lang.java.databases)