Hey Excel Gurus!! - Great Lakes 4x4. The largest offroad forum in the Midwest

Go Back   Great Lakes 4x4. The largest offroad forum in the Midwest > General 4x4 Stuff > The Pub
GL4x4 Live! GL4x4 Casino

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.
Search
Reply
 
Thread Tools Search this Thread
Old January 10th, 2013, 08:38 AM   #1
Mr.Green456123
I can levitate!
 
Mr.Green456123's Avatar
 
Join Date: 11-29-05
Location: Nort Keralina
Posts: 8,300
iTrader: (6)
Mentioned: 7 Post(s)
Default 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!
Mr.Green456123 is offline   Reply With Quote
Sponsored Links
Advertisement
 
Old January 10th, 2013, 08:51 AM   #2
WSU JK
Senior Member
 
WSU JK's Avatar
 
Join Date: 04-25-08
Location: Lowering the Per-Capita Income of Bloomfield Hills since 2009!
Posts: 2,650
iTrader: (4)
Mentioned: 1 Post(s)
Default

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.
WSU JK is offline   Reply With Quote
Old January 10th, 2013, 09:29 AM   #3
Mr.Green456123
I can levitate!
 
Mr.Green456123's Avatar
 
Join Date: 11-29-05
Location: Nort Keralina
Posts: 8,300
iTrader: (6)
Mentioned: 7 Post(s)
Default

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?
Mr.Green456123 is offline   Reply With Quote
Old January 10th, 2013, 09:41 AM   #4
Mr.Green456123
I can levitate!
 
Mr.Green456123's Avatar
 
Join Date: 11-29-05
Location: Nort Keralina
Posts: 8,300
iTrader: (6)
Mentioned: 7 Post(s)
Default

Which one do you recommend and why?? R vs SPSS
Mr.Green456123 is offline   Reply With Quote
Old January 10th, 2013, 09:47 AM   #5
Mr.Green456123
I can levitate!
 
Mr.Green456123's Avatar
 
Join Date: 11-29-05
Location: Nort Keralina
Posts: 8,300
iTrader: (6)
Mentioned: 7 Post(s)
Default

I am downloading SPSS now.
Mr.Green456123 is offline   Reply With Quote
Old January 10th, 2013, 10:26 AM   #6
feva4u
LCG
 
feva4u's Avatar
 
Join Date: 04-01-07
Location: Petoskey, MI
Posts: 10,498
iTrader: (12)
Mentioned: 6 Post(s)
Default

[Rant] It's unbelievable the amount of people that use trend lines without looking at the P value or even knowing what the P value of the line means [\Rant]
__________________
My Jeep
feva4u is offline   Reply With Quote
Old January 10th, 2013, 10:26 AM   #7
whiterhino
I'm not old, honest...
 
whiterhino's Avatar
 
Join Date: 03-07-06
Location: Davisburg MI
Posts: 22,361
iTrader: (22)
Mentioned: 28 Post(s)
Default

Is this on the job training?
__________________
GLFWDA member since 1979.
Member Southern Michigan Rock Crawlers.
whiterhino is offline   Reply With Quote
Old January 10th, 2013, 10:36 AM   #8
Mr.Green456123
I can levitate!
 
Mr.Green456123's Avatar
 
Join Date: 11-29-05
Location: Nort Keralina
Posts: 8,300
iTrader: (6)
Mentioned: 7 Post(s)
Default

Quote:
Originally Posted by whiterhino View Post
Is this on the job training?
No, this is just the job. Trying to revamp some tools I developed from my past. I have not had any success downloading SPSS yet. $%^&^%$!
Mr.Green456123 is offline   Reply With Quote
Old January 10th, 2013, 11:04 AM   #9
RyeBread
Catch the wave
 
RyeBread's Avatar
 
Join Date: 11-08-05
Location: Fenton
Posts: 7,959
iTrader: (2)
Mentioned: 0 Post(s)
Default

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 add-ins 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 flat-file formats, or comingled data with inconsistent field values.

along the same line, I don't use this: http://www.qimacros.com/hypothesis-t...ormality-test/ 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.
RyeBread is offline   Reply With Quote
Old January 10th, 2013, 11:24 AM   #10
Mr.Green456123
I can levitate!
 
Mr.Green456123's Avatar
 
Join Date: 11-29-05
Location: Nort Keralina
Posts: 8,300
iTrader: (6)
Mentioned: 7 Post(s)
Default

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.
Mr.Green456123 is offline   Reply With Quote
Old January 10th, 2013, 01:15 PM   #11
WSU JK
Senior Member
 
WSU JK's Avatar
 
Join Date: 04-25-08
Location: Lowering the Per-Capita Income of Bloomfield Hills since 2009!
Posts: 2,650
iTrader: (4)
Mentioned: 1 Post(s)
Default

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.r-project.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.
WSU JK is offline   Reply With Quote
Old January 10th, 2013, 02:42 PM   #12
RyeBread
Catch the wave
 
RyeBread's Avatar
 
Join Date: 11-08-05
Location: Fenton
Posts: 7,959
iTrader: (2)
Mentioned: 0 Post(s)
Default

Quote:
Originally Posted by WSU JK View Post
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).
I had a "legal" version from a course I took at OU a couple semesters back that was included in the text book's online course materials - new PC arrived, and I found it quicker online than trying to remember my password for the companion website log-in :) - I don't use it a lot, but every once in a while it comes in handy as it's just "that much more robust" than excel out of the box.



Quote:
Originally Posted by WSU JK View Post
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.
x2+3

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/en-us/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
RyeBread is offline   Reply With Quote
Old January 10th, 2013, 03:26 PM   #13
Sandals
Fucking Zen as Shit
 
Sandals's Avatar
 
Join Date: 11-05-05
Location: Lindenhurst, IL
Posts: 15,426
iTrader: (7)
Mentioned: 4 Post(s)
Default

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.
Sandals is offline   Reply With Quote
Old January 10th, 2013, 03:46 PM   #14
Mr.Green456123
I can levitate!
 
Mr.Green456123's Avatar
 
Join Date: 11-29-05
Location: Nort Keralina
Posts: 8,300
iTrader: (6)
Mentioned: 7 Post(s)
Default

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.
Mr.Green456123 is offline   Reply With Quote
Old January 10th, 2013, 04:05 PM   #15
Mr.Green456123
I can levitate!
 
Mr.Green456123's Avatar
 
Join Date: 11-29-05
Location: Nort Keralina
Posts: 8,300
iTrader: (6)
Mentioned: 7 Post(s)
Default

This R looks scary. I need a good user interface. I have not downloaded anyones custom packages yet, but it looks like they will require coding.
Mr.Green456123 is offline   Reply With Quote
Old January 10th, 2013, 04:11 PM   #16
Mr.Green456123
I can levitate!
 
Mr.Green456123's Avatar
 
Join Date: 11-29-05
Location: Nort Keralina
Posts: 8,300
iTrader: (6)
Mentioned: 7 Post(s)
Default

Looks like Megastat may be what I need. I will try to find it or buy it tomorrow. I have had enough for today.
Mr.Green456123 is offline   Reply With Quote
Old January 10th, 2013, 04:24 PM   #17
DTunis123
Newbie
 
Join Date: 08-06-11
Location: Waterford MI
Posts: 13
iTrader: (0)
Mentioned: 0 Post(s)
Default

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.
DTunis123 is offline   Reply With Quote
Old January 10th, 2013, 04:25 PM   #18
RyeBread
Catch the wave
 
RyeBread's Avatar
 
Join Date: 11-08-05
Location: Fenton
Posts: 7,959
iTrader: (2)
Mentioned: 0 Post(s)
Default

Quote:
Originally Posted by Mr.Green again View Post
Looks like Megastat may be what I need. I will try to find it or buy it tomorrow. I have had enough for today.
http://glencoe.mcgraw-hill.com/sites.../megastat.html

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.
RyeBread is offline   Reply With Quote
Old January 10th, 2013, 04:42 PM   #19
Blue XJ
The Green Machine
 
Blue XJ's Avatar
 
Join Date: 11-05-05
Location: Sterling Heights
Posts: 3,746
iTrader: (29)
Mentioned: 0 Post(s)
Send a message via AIM to Blue XJ
Default

Quote:
Originally Posted by DTunis123 View Post
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.

x2 that is what I was thinking could be done as well.
Blue XJ is offline   Reply With Quote
Old January 10th, 2013, 09:59 PM   #20
RyeBread
Catch the wave
 
RyeBread's Avatar
 
Join Date: 11-08-05
Location: Fenton
Posts: 7,959
iTrader: (2)
Mentioned: 0 Post(s)
Default

Quote:
Originally Posted by DTunis123 View Post
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.
it sounded to me like he was getting new data, replotting and developing new trendlines - and wanted the trend line to generate a new model/equation automagically so he could input variables and test the results before seeking new data again, in a recursive/repetitive fashion.

Last edited by RyeBread; January 10th, 2013 at 10:04 PM.
RyeBread is offline   Reply With Quote
Reply
Great Lakes 4x4. The largest offroad forum in the Midwest > General 4x4 Stuff > The Pub

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -5. The time now is 03:48 AM.


Powered by: vBulletin, Copyright 2000 - 2012, Jelsoft Enterprises Ltd.
User Alert System provided by Advanced User Tagging (Lite) - vBulletin Mods & Addons Copyright © 2014 DragonByte Technologies Ltd. Runs best on HiVelocity Hosting.
Page generated in 0.25601 seconds with 81 queries