Fact checked by Pete Rathburn Reviewed by Chip Stapleton What Is Correlation? Correlation measures the linear relationship between two variables. By measuring and relating the variance of each ...

Using Excel's PIVOTBY Function The PIVOTBY function is a dynamic array function in Excel that uses a formula to group rows and columns of data to generate tabular summaries of your data.