![]() |
How do I determine statistical relationship between two series
|
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 |
All times are GMT +1. The time now is 04:42 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com