ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   How do I determine statistical relationship between two series (https://www.excelbanter.com/charts-charting-excel/19788-how-do-i-determine-statistical-relationship-between-two-series.html)

Supermani

How do I determine statistical relationship between two series
 


Michael R Middleton

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