Optimising 2 variable s to maximise a third

  • Context: Undergrad 
  • Thread starter Thread starter taylrl3
  • Start date Start date
  • Tags Tags
    Variable
Click For Summary
SUMMARY

This discussion focuses on optimizing two variables, Columns B and C, to maximize a third variable, Column A, which is directly proportional to Column B and inversely proportional to Column C. The user seeks methods or tools to determine the optimal values for Columns B and C to achieve the maximum value of Column A. Key considerations include whether the entries of B and C are fixed or variable, which impacts the optimization process.

PREREQUISITES
  • Understanding of optimization techniques in mathematics
  • Familiarity with proportional relationships and their implications
  • Knowledge of data analysis tools, such as Excel or Python libraries (e.g., SciPy)
  • Basic concepts of dependent and independent variables
NEXT STEPS
  • Research optimization algorithms, such as the Simplex method or gradient descent
  • Learn how to implement optimization in Python using the SciPy library
  • Explore data visualization techniques to analyze the relationship between Columns A, B, and C
  • Investigate the use of Excel Solver for maximizing functions with constraints
USEFUL FOR

Data analysts, mathematicians, and anyone involved in optimization problems seeking to maximize outcomes based on variable relationships.

taylrl3
Messages
60
Reaction score
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 dependent 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
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:

Similar threads

Operations Research: Simplex table, unbound optimal solution
  • · Replies 7 ·
Replies
7
Views
4K
My Website For Creating Interactive Visuals Linked To Equations
  • · Replies 4 ·
Replies
4
Views
4K
Zeroth Law of Thermodynamics
  • · Replies 5 ·
Replies
5
Views
2K
Understanding DRAM Refresh Operations
  • · Replies 14 ·
Replies
14
Views
6K
Graduate How to find which variables w, x, y.... 'most' influence z?
  • · Replies 7 ·
Replies
7
Views
2K
Undergrad Looking For Help Understanding Bell's Theorem, Hidden Variables & QM
  • · Replies 80 ·
3
Replies
80
Views
8K
Excel Macros & VBA | Learn Programming Basics
  • · Replies 18 ·
Replies
18
Views
6K
Testing Physics gre question: checking relationships with graphs
  • · Replies 1 ·
Replies
1
Views
2K
Undergrad Relevance of the Rydberg Constant?
  • · Replies 25 ·
Replies
25
Views
8K
Undergrad Empirical temperature scales using different thermometers
  • · Replies 7 ·
Replies
7
Views
3K