Was wondering about the problem of finding multiple solutions to one equation, but for large number of input variables/coefficients. (This is your basic spreadsheet math; same equation might be applied to each row of a spreadsheet, to yield different results for each row.)
In other words, say I have a number of inputs in a matrix, call them V11..V1n through Vm1..Vmn, and applying the (same) equation to each row gives solutions S1..Sm. The equation to apply to the values in the columns can be any mathematical formula, it doesn't matter.
Col1 Col2 .. Coln Solution
---- ---- ---- -----------
Row1: V11 V12 .. V1n S1
Row2: V21 V22 .. V2n S2
.. ..
Rowm: Vm1 Vm2 .. Vmn Sm
-----------
Total: Sum(S1..Sm)
Is there a field of study for this kind of thing? Is brute force the only way?
2006-09-12 04:56:20 · 4 answers · asked by crsssl 1 in Science & Mathematics ➔ Mathematics
In Excel you can:
1. Write the formula and copy as someone before me explained
2. Use "what if" tables
3. Use solve equation
About any field of study or science to solve multi variable equations, where your Sm is a equation and each cell in row m is a variable there are some.
Economists have simple way so solve multi variable equations
Vectoring Algebra is very useful to solve multi variables evacuations
Calculus and matrix calculations is probably what you are looking for.
For any of the later you have special math package of software that helps you solve complicated multi variable equations in a couple of clicks.
2006-09-12 06:08:27 · answer #1 · answered by runlolarun 4 · 0⤊ 0⤋
You can quickly enter the same formula into a range of cells. Select the range you want to calculate, type the formula, and then press CTRL+ENTER. For example, if you type =SUM(A1:B1) in range C1:C5, and then press CTRL+ENTER, Excel enters the formula in each cell of the range, using A1 as a relative reference (relative reference: In a formula, the address of a cell based on the relative position of the cell that contains the formula and the cell referred to. If you copy the formula, the reference automatically adjusts. A relative reference takes the form A1.).
If you don't want to use a relative reference, place the character "$" in front of the value. I.E. $A$1 will use the value of cell A1 in every formula, rather than changing it relative to the other cells in the worksheet.
2006-09-12 05:10:49 · answer #2 · answered by Twinkle 2 · 0⤊ 0⤋
Spreadsheet
2006-09-12 04:58:36 · answer #3 · answered by god knows and sees else Yahoo 6 · 0⤊ 0⤋
I have either my brother or a friend take care of the puddy tats and bring in the mail when I'm away. If I'm only going to be gone over the weekend, I fill up a couple of bowls of cat food and water, and the cats are just fine.
2016-03-26 21:57:30 · answer #4 · answered by ? 4 · 0⤊ 0⤋