Home | Community | Message Board


This site includes paid links. Please support our sponsors.


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!

Myyco.com Shop: Golden Teacher Liquid Culture For Sale

Jump to first unread post Pages: 1
OfflineteslaAC
hooligan
 User Gallery

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

Extras: Filter Print Post Top
InvisibleDieCommie


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.

Extras: Filter Print Post Top
Invisiblejohnm214
Male User Gallery

Folding@home Statistics
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?

Extras: Filter Print Post Top
OfflineAnnom
※※※※※※
 User Gallery


Folding@home Statistics
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?

Extras: Filter Print Post Top
OfflineAnnoA
Experimenter
 User Gallery


Folding@home Statistics
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.

Extras: Filter Print Post Top
Jump to top Pages: 1

Myyco.com Shop: Golden Teacher Liquid Culture For Sale


Similar ThreadsPosterViewsRepliesLast post
* Graphing sin, cos functions through excel *DELETED* PJDIDDLE 4,792 9 10/18/06 10:10 AM
by skydog
* Graphing Calculators Fictional 846 6 03/15/06 01:24 AM
by ChuangTzu
* Variable vs. 320kbps ivi 3,182 16 12/30/04 08:18 AM
by Fliquid
* What kind of graphing calculator do you have? KrazieH8er 1,325 15 07/10/04 07:16 PM
by metamind
* editing a graph phi1618 621 3 09/17/05 09:19 AM
by ChuangTzu
* Robo-scientist makes independent findings Green_T 478 1 04/03/09 03:39 PM
by Nephlyte
* Any Excel experts around? I just need to merge two spreadsheets Lana 835 6 10/26/06 01:22 PM
by Lana
* MS Excell - Unprotect pw. Oatman2000 414 3 06/22/06 06:27 AM
by Seuss

Extra information
You cannot start new topics / You cannot reply to topics
HTML is disabled / BBCode is enabled
Moderator: trendal, automan, Northerner
664 topic views. 0 members, 0 guests and 1 web crawlers are browsing this forum.
[ Show Images Only | Sort by Score | Print Topic ]
Search this thread:

Copyright 1997-2024 Mind Media. Some rights reserved.

Generated in 0.017 seconds spending 0.007 seconds on 14 queries.