| 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 | |||
Linear Mode
