I am trying to find a program or even a spreadsheet that will turn data that I have into an equation that equals an answer that I already have. I basically have the data and the answer but I need to know the equation. Thanks!
2006-11-08 07:01:18 · 3 answers · asked by Jeff C 1 in Science & Mathematics ➔ Mathematics
In Excel you can graph the data and then add a trendline. You can even have it display the equation for the trendline. Some possible choices for fit are linear (line), exponential, polynomial of degree 2, 3, 4, 5, 6, etc.
If you give some sample data, I might be able to help further...
2006-11-08 07:04:27 · answer #1 · answered by Puzzling 7 · 0⤊ 0⤋
take the first set of data such as values in A1 the do whatever math equation that you need by the second set of data eg B1
insert this into the sum bar that is = bar or in another cell using
=(a1 MATH EQUATION b1) THE PRESS ENTER
2006-11-08 15:15:32 · answer #2 · answered by party69_27 3 · 0⤊ 0⤋
Solver, an add-in included with Microsoft Excel, can do this for you.
It's too complicated to explain in this fomrat, but use the help feature on Solver within Excel and you'll get it.
2006-11-08 15:04:33 · answer #3 · answered by crapweasel 1 · 0⤊ 0⤋