COVARIANCE.P in WPS on Windows FAQ

This FAQ covers 4 common question types about COVARIANCE.P in WPS, including input errors, argument guidance, unexpected results, and recalculation checks.

FAQ

What should I do if COVARIANCE.P shows an error after I enter it?

1. Check whether the formula starts with =.
2. Confirm that the function name, parentheses, and separators are correct.
3. Make sure both arguments are entered and the referenced ranges are valid.
4. Press Enter again to submit the formula.

How can I view argument guidance for COVARIANCE.P?

1. Select the target cell.
2. Type =COVARIANCE.P(.
3. Watch for the syntax guidance that appears in the editing area.
4. Continue entering the required ranges based on the prompt.

Why does the calculation result look incorrect?

1. Check whether the referenced ranges include text, blanks, or values that should not be part of the calculation.
2. Confirm that the two data sets correspond to each other as intended.
3. Make sure you are using the population covariance function for the right analysis scenario.
4. Update the data and review whether the result changes as expected.

Why does the result not change after I edit the source data?

1. Confirm that you changed cells that are actually referenced by the formula.
2. Select the result cell again and review the referenced ranges in the formula bar.
3. Reconfirm the formula if needed and check whether the result refreshes.
4. If the worksheet contains more complex linked formulas, review upstream references step by step.

Glossary