

Home  Register  iTrader  Members List  Calendar  Search  Today's Posts  Mark Forums Read  Store  Photo Gallery  Chat 
The Pub A friendly forum where everybody is nice, and will answer any questions you have about life. 
greatlakes4x4.com is the premier Great Lakes 4x4 Forum on the internet. Registered Users do not see the above ads.


Thread Tools  Search this Thread 
January 10th, 2013, 08:38 AM  #1 
I can levitate!

Hey Excel Gurus!!
Is there any way of using the trend line equation displayed on graphs for other calculations? My trend line will change and I dont want to have to go change the coefficients for my other calculations every time. It seems like this should be a simple / obvious option. HELP!

Sponsored Links  
Advertisement


January 10th, 2013, 08:51 AM  #2 
Senior Member
Join Date: 042508
Location: Lowering the PerCapita Income of Bloomfield Hills since 2009!
Posts: 2,730
iTrader: (4)
Mentioned: 1 Post(s)

What other calculations are you trying to display?
The basic trend line equation is good for trend lines and that's about it really (and even then it doesn't allow as much user input as it should). I use Excel quite a bit but for graphing more complex statistics and trends, you're generally better off with an actual stats program like R (which is a free open source program) or SPSS. 
January 10th, 2013, 09:29 AM  #3 
I can levitate!

I want to be able to compare other data to the trend line equation. My trend line equation will change as I tweak and add additional data. Can I download these other programs for free?

January 10th, 2013, 10:36 AM  #8 
I can levitate!


January 10th, 2013, 11:04 AM  #9 
Catch the wave

how many variables/coefficients at play? or is this a linear trend line?
how much data? as wsu jk mentioned there may simply be a better tool, or simply adding in some addins for excel may help you massage/tweak your excel models a bit better. while spss may be a bit of a challenge to "download"  megastat is often easily found with a google search on one or more university professor sites. and ASAP Utilities is invaluable to me cleaning up excel data that originated from other sources  especially if it's old flatfile formats, or comingled data with inconsistent field values. along the same line, I don't use this: http://www.qimacros.com/hypothesist...ormalitytest/ bit it claims to take a bit more rigorous look at the data to determine the normality of it, address the aforementioned pvalue/critical values, etc. googling process management, process controls can yield some examples in excel from operations' management courses as well that may prove helpful or be adapted to what your'e trying to do. 
January 10th, 2013, 11:24 AM  #10 
I can levitate!

Linear trending for the most part. Variables will grow as the program does, but my guess would be no more than 20 variables, maybe as low as 10ish. I just want to do some basic trending and comparisons of trends.

January 10th, 2013, 01:15 PM  #11 
Senior Member
Join Date: 042508
Location: Lowering the PerCapita Income of Bloomfield Hills since 2009!
Posts: 2,730
iTrader: (4)
Mentioned: 1 Post(s)

Good luck downloading a working version of SPSS; they have been very good in the past at keeping pirated copies (or license keys) off of the internet. Though I am sure that there are folks more skilled at getting a copy than I am.
R is available free and legal here: http://www.rproject.org/. I have limited experience with it (because I have access to a full version of SPSS) but based on that small bit of time with it it seems pretty straightforward once you get it set up. RyeBread recommends looking for Megastat  I have no personal experience with it but I have heard very good things about it, especially if the user is not somebody who has an academic background in statistics and the social sciences (both R and SPSS are geared toward that type of user). If you want to stick with Excel, do a few searches in YouTube (of all places). I like to think I am pretty proficient with Excel but whenever I run into something I cannot figure out, I turn to that and am always amazed by the amount of effort some folks will put into a tutorial. 
January 10th, 2013, 02:42 PM  #12  
Catch the wave

Quote:
Quote:
oh yeah, I almost forgot. I grabbed this a while ago at home to play with it, messed around a bit with it and promptly forgot about it until this thread came up. http://www.microsoft.com/enus/downl....aspx?id=15702 it may not help per se' with the task at hand / stats / trending / process control/mapping but it appears to be able to do some pretty complex graphing/equation solving including polynomials. when my 7th grader starts taking calc in a couple of years (he's already in 9th grade algebra) I'll have him tackle MS Math to check (not do, but check) his homework, as I really don't care to relearn calc 

January 10th, 2013, 03:26 PM  #13 
Fucking Zen as Shit

if everything is excel,
you can copy the sheets from all other workbooks into one central workbook and reference that calculations numbers on the other sheets. 
January 10th, 2013, 03:46 PM  #14 
I can levitate!

OK, I will download R and see where it gets me. I am not doing very complex trending and comparisons. It is all mostly linear trends, but I am dealing with a rubix cube. I change one variable and the rest can change. I need to compare emperical data with the trends that I am producing from this (and other) emperical data to try and determine what variables are important, how they effect each other, etc. Basic stuff, but Excel seems to be a bit limited. It looks like these programs you guys are recomending may help me find trends that may not be obvious. That makes me happy, excited, and fuzzy.

January 10th, 2013, 04:24 PM  #17 
Newbie

If you get the equation for your trendline you want to use, right click on the line, go under properties and click display equation. Then write a formula using that equation, and graph those points seperately. You can modify your other values, without that data set changing.

January 10th, 2013, 04:25 PM  #18  
Catch the wave

Quote:
http://blue.butler.edu/~orris/megastat/index.html not sure if they actually charge for it, and it's been a long time since I actually thought about skimming the EULA on it. 

January 10th, 2013, 04:42 PM  #19  
The Green Machine

Quote:
x2 that is what I was thinking could be done as well. 

January 10th, 2013, 09:59 PM  #20  
Catch the wave

Quote:
Last edited by RyeBread; January 10th, 2013 at 10:04 PM. 

Thread Tools  Search this Thread 

