I have the following data points (for example)
x, y, z, a, b
Lets say those are each a column in a database (or Excel) and I have 1000 rows of data (so 5000 total values). I need to create an equation that solves for "b". How do I go about doing this? Excel will do it based on a collection of just x and y values, but I don t know if Excel goes higher than two variables? Does it? If so, how do I do that? DO NOT ASSUME THAT THIS IS A LINEAR EQUATION.
x, y, z, a, b
Lets say those are each a column in a database (or Excel) and I have 1000 rows of data (so 5000 total values). I need to create an equation that solves for "b". How do I go about doing this? Excel will do it based on a collection of just x and y values, but I don t know if Excel goes higher than two variables? Does it? If so, how do I do that? DO NOT ASSUME THAT THIS IS A LINEAR EQUATION.