|
teslaAC
hooligan


Registered: 03/24/08
Posts: 89
Last seen: 8 years, 2 months
|
Excel gurus, help!
#8198120 - 03/26/08 06:50 PM (16 years, 1 month ago) |
|
|
Hey, I need a little help. I have a chart with 14 columns, each representing an age. There are 20 rows representing weight. At the intersection of the two values you insert the cell contains your average calorie use. I would like to do this with a polynomial equation. I know you can add a trend line to a graph and it will give you an equation but I'm not sure how to set the graph up or how to make a trend line for a polynomial. Sorry if this doesn't make a lot of sense, I'm trying to replace a chart with an equation that has 2 variables, age and weight, plugging those in will give you your calorie use a day. This is an example I don't actually need a calorie calculator just need to learn how to get excel data into an equation. Thanks guys.
-------------------- "My ultimate goal is the complete mastery of the mind over the material world" Nikola Tesla
|
DieCommie


Registered: 12/11/03
Posts: 29,258
|
Re: Excel gurus, help! [Re: teslaAC]
#8198216 - 03/26/08 07:14 PM (16 years, 1 month ago) |
|
|
Highlight your two columns of data. Make a graph, be sure to make a 'scatter' graph with the points not connected.
After that you should be able to right click on your graph and 'add trendline'. You then choose polynomial (or whatever you want). Right click on the trendline and you can choose to see the equation, the std deviation and all that shit.
|
johnm214



Registered: 05/31/07
Posts: 17,582
Loc: Americas
|
Re: Excel gurus, help! [Re: teslaAC]
#8198226 - 03/26/08 07:17 PM (16 years, 1 month ago) |
|
|
why not just enter your equation in a cell, then have the two or howmany variables in two rows. Have the equation grab the independant variable from the row to calculate the dependant variable below it. Then select these cells as the source of your graph's data.
So if your two independant variables are age and sex, you have to rows for these and a sepperate ro for calorie calculation
Then have the equation use the age/sex cells to calculate the calorie calculation in a third row below the appropriate cells. Then use these as your graph's values
make sense? Is this what you want?
|
Annom
※※※※※※




Registered: 12/22/02
Posts: 6,367
Loc: Europe
Last seen: 1 year, 3 days
|
Re: Excel gurus, help! [Re: teslaAC]
#8200374 - 03/27/08 08:30 AM (16 years, 1 month ago) |
|
|
> just need to learn how to get excel data into an equation
Type =A1+B1 in a cell and it will add cell A1 and B1. Is that what you want to know?
|
Anno
Experimenter




Registered: 06/17/99
Posts: 24,166
Loc: my room
Last seen: 7 days, 2 hours
|
Re: Excel gurus, help! [Re: teslaAC]
#8200400 - 03/27/08 08:39 AM (16 years, 1 month ago) |
|
|
I am not completely sure if I understand what you want to do, but my guess would be it could be solvable by the excel solver: http://puccini.che.pitt.edu/~karlj/Classes/CHE2101/solver.html
You might want to post the sheet here so we can see exactly what is it about.
|
|