Home | Community | Message Board


DoubleBlind - Learn to Grow Mushrooms
Please support our sponsors.

General Interest >> Science and Technology

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!

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

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


Post Extras: Filter  Print Post  Remind Me! Notify Moderator
InvisibleDieCommie


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.


Post Extras: Filter  Print Post  Remind Me! Notify Moderator
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 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?


Post Extras: Filter  Print Post  Remind Me! Notify Moderator
OfflineAnnomM
※※※※※※
 User Gallery


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


Post Extras: Filter  Print Post  Remind Me! Notify Moderator
OfflineAnnoA
Experimenter
 User Gallery


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


Post Extras: Filter  Print Post  Remind Me! Notify Moderator
Jump to top. Pages: 1

General Interest >> Science and Technology

Similar ThreadsPosterViewsRepliesLast post
* Graphing sin, cos functions through excel *DELETED* PJDIDDLE 4,743 9 10/18/06 12:10 PM
by skydog
* Graphing Calculators Fictional 809 6 03/15/06 03:24 AM
by ChuangTzu
* Variable vs. 320kbps ivi 3,097 16 12/30/04 10:18 AM
by Fliquid
* What kind of graphing calculator do you have? KrazieH8er 1,235 15 07/10/04 09:16 PM
by metamind
* editing a graph phi1618 584 3 09/17/05 11:19 AM
by ChuangTzu
* Robo-scientist makes independent findings Green_T 465 1 04/03/09 05:39 PM
by Nephlyte
* Any Excel experts around? I just need to merge two spreadsheets Lana 793 6 10/26/06 03:22 PM
by Lana
* MS Excell - Unprotect pw. Oatman2000 397 3 06/22/06 08: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
632 topic views. 0 members, 0 guests and 1 web crawlers are browsing this forum.
[ Print Topic ]
Search this thread:
MRCA Tyroler Gluckspilze
Please support our sponsors.

Copyright 1997-2021 Mind Media. Some rights reserved.

Generated in 0.041 seconds spending 0.011 seconds on 16 queries.