Home » Statistical Analysis Excel » Covariance

Struggling to Run Covariance Analysis in Excel?

QI Macros can conduct covariance 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:
   
   
2. Click on QI Macros menu > Statistical Tools >Regression and Other Statistics > Covariance:
   
   
3. Evaluate the 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).

QI Macros can draw these charts too!