This FAQ covers 3 common issue types when using COVARIANCE.P: error values, unexpected results, and filling the formula across cells.
FAQ
What should I do if COVARIANCE.P returns #VALUE!?
- Check whether the referenced cells contain text, spaces, or other non-numeric content.
- Make sure the data ranges used in the calculation are formatted as numbers.
- Clean the invalid content and then re-enter or confirm the formula.
Why does the COVARIANCE.P result look different from what I expected?
- Check whether the referenced ranges are correct and make sure the two data ranges were selected as intended.
- Confirm that the cells are stored as numbers instead of text.
- If needed, review the arguments and references in the formula step by step.
How can I use COVARIANCE.P in multiple cells?
- Enter the formula in the first target cell.
- Select that cell, then drag the fill handle at the lower-right corner across the target range, or copy and paste the formula into other cells.
- After filling, check whether relative and absolute references behave as expected.
Glossary
| Term | Definition |
|---|---|
| COVARIANCE.P | A spreadsheet function that returns the population covariance of two data sets. |
| Insert Function | A function entry point in WPS Spreadsheet where you can search for a function and fill in its arguments. |
| Formula bar | The input area above the worksheet where you can type or edit formulas. |
| spreadsheet | A worksheet-based file used to organize, calculate, and analyze tabular data. |