How to make 4 variable polynomial equatio

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

This discussion focuses on creating a polynomial equation with four variables (x, y, z, w) using Excel and other software like MATLAB. The specific polynomial form discussed is w = ax + by + cz + dx^2 + ey^2 + fz^2 + gxy + hyz + iyz, where a, b, c, d, e, f, g, h, and i are constants. The use of Excel's "Solver" function is highlighted for determining these constants, although alternatives may provide better results. The discussion also touches on the need for literature to understand polynomial regression techniques.

PREREQUISITES
  • Understanding of polynomial equations and their structure
  • Familiarity with Excel functions, particularly the "Solver" function
  • Basic knowledge of regression analysis techniques
  • Experience with MATLAB for advanced polynomial modeling
NEXT STEPS
  • Explore polynomial regression techniques in depth
  • Learn how to use Excel's "Solver" for optimization problems
  • Investigate MATLAB's capabilities for polynomial fitting
  • Study literature on multivariable polynomial equations and their applications
USEFUL FOR

Data analysts, mathematicians, engineers, and anyone interested in modeling complex relationships using polynomial equations.

afzal
Messages
1
Reaction score
0
Can I use excel to make an equation for 4 variables (x,y,z,w)
e.g
a,b,c,d,3,f,g,h,i, would be constants

w = ax + by + cz + dx^2 + ey^2 + fz^2 + gxy + hyz + iyz

What are these equations called ?
What literature can I study to better understand the procedure of making these tye of equations.

I tried regression but the equation looks like

w = ax + by + cz + c

Is it possible on ay other software e.g MATLAB
 
Mathematics news on Phys.org
What do you plan to do with the equation?
You can type this equation into excel (with cell references instead of variables). And now?

If you want to determine your constants in a fit, you can use the "solver" funktion, and use a cell which somehow determines the quality of your current constants to maximize/minimize/whatever this value.
Other programs might be better here.
 

Similar threads

Undergrad Can Polynomials in Two Variables Be Expressed in Different Forms?
  • · Replies 4 ·
Replies
4
Views
2K
Undergrad Quadratic equation of two variables
  • · Replies 11 ·
Replies
11
Views
2K
Undergrad Quadratic, cubic, quartic, quintic equations
  • · Replies 16 ·
Replies
16
Views
5K
High School Constants and variables (the very basics)
  • · Replies 5 ·
Replies
5
Views
2K
Undergrad Quintic Polynomial Tschirnhaus Transform: Possible complex Bring Radicals
  • · Replies 0 ·
Replies
0
Views
3K
Undergrad Want to understand how to express the derivative as a matrix
  • · Replies 8 ·
Replies
8
Views
3K
Undergrad Determine if polynomial system has finite number of solutions
  • · Replies 6 ·
Replies
6
Views
2K
Undergrad Solving polynomial equations,hlep
  • · Replies 12 ·
Replies
12
Views
4K
Undergrad Canonical Form for quadratic equations *with* linear terms
  • · Replies 4 ·
Replies
4
Views
3K
Undergrad General formulae for the roots of a cubic equation
  • · Replies 4 ·
Replies
4
Views
2K