Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Correlation formula/function question.
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Correlation formula/function question.
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Newbie With A Question | Excel Worksheet Functions | |||
Anybody Help with previous question | Excel Discussion (Misc queries) | |||
formula/function question | Excel Worksheet Functions | |||
Correlation Question | Excel Worksheet Functions | |||
Hints And Tips For New Posters In The Excel Newsgroups | Excel Worksheet Functions |