Correlation formula/function question.

's Computer Specifications

Can excel create a correlation formula? For instance, let's say I have 2
trend lines on price over time. I want to see if there is some correlation
between the 2. If price one moves $1, then you can expect price 2 to move $x
amount. Is there an excel function that will find that correlation?

Thank you!
--
Marv Lusk
Boise Corporation

's Computer Specifications

See the Excel help for the CORREL function.

Hutch

"MarvInBoise" wrote:

> Can excel create a correlation formula? For instance, let's say I have 2
> trend lines on price over time. I want to see if there is some correlation
> between the 2. If price one moves $1, then you can expect price 2 to move $x
> amount. Is there an excel function that will find that correlation?
>
> Thank you!
> --
> Marv Lusk
> Boise Corporation

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How many cells can a correlation function cover?	Correl	Microsoft Excel Misc	0	5th Jun 2010 02:37 PM
correlation function	leopons_rock	Microsoft Excel Misc	3	5th Dec 2007 10:11 PM
Correlation - Which Analytical Function to Use	=?Utf-8?B?UGFza28x?=	Microsoft Excel Misc	2	7th Oct 2005 12:54 AM
How do I set up a correlation formula?	=?Utf-8?B?Q3Jvdzk4NzU=?=	Microsoft Excel Worksheet Functions	1	13th Apr 2005 01:02 PM
correlation function in macro	Sam	Microsoft Excel Programming	0	29th Jul 2003 09:38 AM