Optimising 2 variable s to maximise a third

  • Thread starter taylrl3
  • Start date
  • Tags
    Variable
In summary, the person is asking for help finding the optimum values for three columns of data, where one column is dependent on the other two in a direct and inverse proportion. They are looking for guidance on how to find the maximum value for the dependent column.
  • #1
taylrl3
61
0
Hi,

I am sure there must be something already on here about this kind of thing so if you could point me in that direction that is fine, or to a site anywhere.

Basically I have three columns of data, let's say Column A, Column B and Column C. Column A is dependant upon both Columns B & C (directly proportional to Column B and inversely proportional to Column C). What I would like to be able to do is to find the optimum values for Columns B & C such that Column A is maximised.

Thanks in advance!
 
Physics news on Phys.org
  • #2
Your question is too vague.

Do you want to find the max. entry of A? If not, what is it that is maximized?
Are the entries of B and C fixed? If not, what are these entries dependent on?
 
Last edited:

1. How do you determine which variables to optimize in order to maximize a third variable?

In order to determine which variables to optimize, you must first identify the relationship between the three variables. This can be done through data analysis or by using mathematical models. Once the relationship is understood, you can then select the two variables that have the strongest impact on the third variable.

2. What methods can be used to optimize two variables to maximize a third?

There are various methods that can be used to optimize two variables in order to maximize a third. These include linear programming, gradient descent, and simulation methods. The choice of method will depend on the specific problem and the type of data available.

3. How do you know when you have achieved the optimal values for the two variables?

The optimal values for the two variables can be determined by setting up an objective function and using optimization techniques to find the maximum value. Alternatively, the optimal values can also be found by conducting sensitivity analysis on the variables to see how changing their values affects the third variable.

4. Can optimizing two variables to maximize a third always lead to the best outcome?

Not necessarily. In some cases, there may be other factors or variables that need to be taken into consideration in order to achieve the best outcome. It is important to carefully analyze the problem and consider all relevant variables before deciding which two variables to optimize.

5. How can you handle trade-offs between the two variables when optimizing for a third?

When there are trade-offs between the two variables, it is important to find a balance between them in order to maximize the third variable. This can be done by assigning weights to each variable based on their importance and then using optimization techniques to find the optimal combination of values that maximize the third variable.

Similar threads

Operations Research: Simplex table, unbound optimal solution
    • Calculus and Beyond Homework Help
Replies
7
Views
2K
I Looking For Help Understanding Bell's Theorem, Hidden Variables & QM
    • Quantum Physics
3
Replies
80
Views
4K
Understanding DRAM Refresh Operations
    • Computing and Technology
Replies
14
Views
3K
How can I calculate weighted average for maximizing Spearman Rho in Excel?
    • Set Theory, Logic, Probability, Statistics
Replies
1
Views
4K
How to find which variables w, x, y.... 'most' influence z?
    • Set Theory, Logic, Probability, Statistics
Replies
7
Views
2K
Plot function of 3 space variables plus time
    • MATLAB, Maple, Mathematica, LaTeX
Replies
5
Views
1K
I Empirical temperature scales using different thermometers
    • Classical Physics
Replies
7
Views
847
Excel Macros & VBA | Learn Programming Basics
    • Programming and Computer Science
Replies
18
Views
5K
I Relevance of the Rydberg Constant?
    • Atomic and Condensed Matter
Replies
25
Views
5K
JS Variable Hygiene: Preventing Global Var Access
    • Programming and Computer Science
Replies
13
Views
1K

Hot Threads

Recent Insights

Back
Top