How do I determine statistical relationship between two series

  • Thread starter Michael R Middleton
  • Start date
M

Michael R Middleton

Supermani -
How do I determine statistical relationship between two series <
Click to expand...

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I adjust marker spacing in Excel scatter plot? 1
How do I specify a constant Y-value for an X-series 2
How do I shade the space between two data series in Excel? 1
How do I shade the area between two lines on a chart? 3
Comparing 2 series of data 1
how do I define a chart series with an indirect reference 4
Comparing 2 series of data on Excel 2000 0
How do I set up a parallel or ladder link between two activities? 1

Top