# 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.