Welcome to the Shroomery Message Board! You are experiencing a small sample of what the site has to offer. Please login or register to post messages and view our exclusive membersonly content. You'll gain access to additional forums, file attachments, board customizations, encrypted private messages, and much more!

teslaAC
hooligan
Registered: 03/24/08
Posts: 89
Last seen: 4 years, 11 months

Excel gurus, help!
#8198120  03/26/08 08:50 PM (12 years, 11 months 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 09:14 PM (12 years, 11 months 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 09:17 PM (12 years, 11 months 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: 28 days, 29 minutes

Re: Excel gurus, help! [Re: teslaAC]
#8200374  03/27/08 10:30 AM (12 years, 11 months 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/18/99
Posts: 24,141
Loc: my room
Last seen: 5 days, 1 hour

Re: Excel gurus, help! [Re: teslaAC]
#8200400  03/27/08 10:39 AM (12 years, 11 months 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.
 


You cannot start new topics / You cannot reply to topics HTML is disabled / BBCode is enabled
Moderator: trendal, automan 632 topic views. 0 members, 0 guests and 1 web crawlers are browsing this forum.
[ Print Topic ]   


