How to Calculate CV in Excel

CV is an abbreviation for covariance. Covariance is defined as a measure of the tendency of two things to move or vary together, and is widely used in statistics. The calculations needed to arrive at the covariance are very complex; however, Microsoft Excel has a simple formula that can be used to determine this measurement.

...

Step

Go to "Start">"Programs">"Microsoft Office">"Microsoft Excel," or "Start">"Microsoft Excel."

...
...

Step

Open Microsoft Excel.

...

Step

Type "Month" in cell A1; then type the months "January," "February," "March," "April" and "May" in the rows under "Month."

...

Step

Type "Rain (inches)" and "Frequency" in columns B and C, respectively.

...

Step

Type 5, 7, 3, 8, 4 in the "Rain (inches)" column.

...

Step

Type 2, 3, 5, 7, 1 in the "Frequency" column. The program is asking if the amount of rain changes with the number of times it rains in a month.

...

Step

Type "=covar" in cell C7.

...

Step

Type the opening parenthesis for the formula, then highlight cells B2 through B6.

...

Step

Type the comma, highlight cells C2 through C6, then type the closing parenthesis.

Step

Press "Enter." The result is 1.76, which means the more often it rains, the more rain the town receives.

...