How to make 4 variable polynomial equatio

Click For Summary
Excel can be used to create polynomial equations with four variables, such as w = ax + by + cz + dx^2 + ey^2 + fz^2 + gxy + hyz + iyz, by utilizing cell references for variables. These types of equations are generally referred to as multivariable polynomial equations. For a deeper understanding of creating such equations, literature on polynomial regression and multivariable calculus is recommended. While Excel's "Solver" function can help determine constants for fitting, software like MATLAB may offer more advanced capabilities for complex polynomial modeling. Ultimately, the choice of software depends on the specific needs and goals for the equation.
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.
 
Here is a little puzzle from the book 100 Geometric Games by Pierre Berloquin. The side of a small square is one meter long and the side of a larger square one and a half meters long. One vertex of the large square is at the center of the small square. The side of the large square cuts two sides of the small square into one- third parts and two-thirds parts. What is the area where the squares overlap?

Similar threads

  • · Replies 6 ·
Replies
6
Views
2K
Replies
4
Views
2K
Replies
9
Views
3K
  • · Replies 16 ·
Replies
16
Views
5K
  • · Replies 11 ·
Replies
11
Views
2K
  • · Replies 4 ·
Replies
4
Views
1K
  • · Replies 1 ·
Replies
1
Views
2K
  • · Replies 5 ·
Replies
5
Views
2K
  • · Replies 18 ·
Replies
18
Views
5K
  • · Replies 14 ·
Replies
14
Views
3K