|
Shroomery - Magic Mushrooms Demystified
|
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 members-only 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 ] | | |
|
|
|
|
|
Threaded
Previous
Index
Next
Edit 
Reply 
