Struggling to Run Covariance Analysis in Excel?

QI Macros can conduct covariance analysis for you!

Analyze Covariance using QI Macros

  1. Select your data.
  2. Click on QI Macros menu > Statistical Tools > Regression & Other Statistics > Covariance.
  3. QI Macros will do the math and analysis for you.

What is Covariance?

Imagine that you'd like to know if variation in one variable is related to the variation in another. While statistical analysis cannot prove that one thing causes another, it can determine if there is a relationship between the variables which gives a direction to the analysis.

Systolic Blood Pressure vs Weight Covariance Example Using QI Macros

While Excel's data analysis toolpak can run covariance analysis, it is difficult to use. QI Macros add-in for Excel makes running covariance as easy as 1-2-3.

  1. Select your data

    Click and drag over two or more columns of data:

    Sample data
  2. Click on QI Macros menu > Statistical Tools >Regression and Other Statistics > Covariance:

    covariance-menu
  3. Evaluate the Covariance Results:

    Covariance results

    Two variables can be positively correlated (more of one means more of another) or negatively correlated (more of one means less of another).

Stop Struggling with Covariance Analysis!
Start conducting Covariance Analysis in just minutes.

Download a free 30-day trial. Run Covariance Analysis now!

QI Macros can draw these charts too!