Thread: Correlation Finding Software?
View Single Post
  #7   Spotlight this post!  
Unread 02-07-2007, 15:38
kramarczyk's Avatar
kramarczyk kramarczyk is offline
is getting his kicks.
AKA: Mark Kramarczyk
FRC #3096 (Highlanders)
Team Role: Mentor
  
Join Date: Mar 2006
Rookie Year: 2006
Location: Sterling Heights, MI
Posts: 602
kramarczyk has a reputation beyond reputekramarczyk has a reputation beyond reputekramarczyk has a reputation beyond reputekramarczyk has a reputation beyond reputekramarczyk has a reputation beyond reputekramarczyk has a reputation beyond reputekramarczyk has a reputation beyond reputekramarczyk has a reputation beyond reputekramarczyk has a reputation beyond reputekramarczyk has a reputation beyond reputekramarczyk has a reputation beyond repute
Re: Correlation Finding Software?
Quote:
Originally Posted by Kevin Sevcik View Post
The suggestion to use excel's linear fit is a bit misguided.
For the record I am not suggesting that excel's linear fit should be used as I have no idea what data is being worked with. The question was about finding correlation between data ranges in a spreadsheet. I was simply pointing out that excel has built in functions for that... I see no reason to reinvent the wheel if one is just trying to convert the data into information. However, if one is trying to learn about the technique then, yeah, grab a book.

I also found this page that gives the excel calcs for other trendlines... http://j-walk.com/ss/excel/tips/tip101.htm
__________________
Mark

Brick walls are for other people. - Randy Pausch
Last edited by kramarczyk : 02-07-2007 at 15:39. Reason: typo
Reply With Quote