Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]() |
#2
![]() |
|||
|
|||
![]()
Supermani -
How do I determine statistical relationship between two series < If the "two series" are time sequence data, e.g., monthly sales and monthly advertising over several years, start with a Line chart showing the two series. If the "two series" are cross-sectional data, e.g., productivity-units and hours-of-training for each member of a group during a single time period, start with an XY (Scatter) chart. Then add a trendline or use worksheet functions like CORREL to obtain summary measures. - Mike www.mikemiddleton.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Using Excel or Access for relationship webs | Charts and Charting in Excel | |||
Statistical functions | Excel Worksheet Functions | |||
formula to determine the first column containing any data | Excel Worksheet Functions | |||
Statistical Excel Function Question within Excel 2000... | Excel Worksheet Functions |