Skip to content
xlsoffice. All Rights Reserved
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Lookup and Reference Examples

  • Find closest match in Excel
  • Approximate match with multiple criteria in Excel
  • Complete List of Excel Lookup and Reference Functions, References and Examples
  • MATCH function: Description, Usage, Syntax, Examples and Explanation
  • To count total rows in a range in Excel

Data Analysis Examples

  • Get column name from index in Excel Table
  • How to Use Solver Tool in Excel
  • How to create a Histogram in Excel
  • How to combine 2 or more chart types in a single chart in Excel
  • How to Sort by Color in Excel

Data Validation Examples

  • Excel Data validation unique values only
  • Excel Data validation only dates between
  • Excel Data validation must not contain
  • Excel Data validation must begin with
  • Excel Data validation number multiple 100

COVARIANCE.P function: Description, Usage, Syntax, Examples and Explanation

by

What is COVARIANCE.P function in Excel?

COVARIANCE.P function is one of Statistical functions in Microsoft Excel that returns population covariance, the average of the products of deviations for each data point pair in two data sets. Use covariance to determine the relationship between two data sets. For example, you can examine whether greater income accompanies greater levels of education.

Syntax of COVARIANCE.P function

COVARIANCE.P(array1,array2)

The COVARIANCE.P function syntax has the following arguments:

  • Array1     Required. The first cell range of integers.
  • Array2     Required. The second cell range of integers.

COVARIANCE.P formula explanation

  • The arguments must either be numbers or be names, arrays, or references that contain numbers.
  • If an array or reference argument contains text, logical values, or empty cells, those values are ignored; however, cells with the value zero are included.
  • If array1 and array2 have different numbers of data points, COVARIANCE.P returns the #N/A error value.
  • If either array1 or array2 is empty, COVARIANCE.P returns the #DIV/0! error value.
  • The covariance is:Equationwherex and y

    are the sample means AVERAGE(array1) and AVERAGE(array2), and n is the sample size.

Example of COVARIANCE.P function

Steps to follow:

1. Open a new Excel worksheet.

2. Copy data in the following table below and paste it in cell A1

Note: For formulas to show results, select them, press F2 key on your keyboard and then press Enter.

You can adjust the column widths to see all the data, if need be.

Data1 Data2
3 9
2 7
4 12
5 15
6 17
Formula Description Result
=COVARIANCE.P(A2:A6, B2:B6) Covariance, the average of the products of deviations for each data point pair above 5.2

Post navigation

Previous Post:

COUNTIFS function: Description, Usage, Syntax, Examples and Explanation

Next Post:

COVARIANCE.S function: Description, Usage, Syntax, Examples and Explanation

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Learn Basic Excel

Ribbon
Workbook
Worksheets
Format Cells
Find & Select
Sort & Filter
Templates
Print
Share
Protect
Keyboard Shortcuts

Categories

  • Charts
  • Data Analysis
  • Data Validation
  • Excel Functions
    • Cube Functions
    • Database Functions
    • Date and Time Functions
    • Engineering Functions
    • Financial Functions
    • Information Functions
    • Logical Functions
    • Lookup and Reference Functions
    • Math and Trig Functions
    • Statistical Functions
    • Text Functions
    • Web Functions
  • Excel VBA
  • Excel Video Tutorials
  • Formatting
  • Grouping
  • Others
  • Extract word that begins with specific character in Excel
  • How to find nth occurrence of character in Excel
  • How to abbreviate names or words in Excel
  • Remove last characters from right in a cell in Excel
  • How to count total words in a range in Excel
  • NETWORKDAYS function: Description, Usage, Syntax, Examples and Explanation
  • How to calculate Next working/business day in Excel
  • Display Days until expiration date in Excel
  • Assign points based on late time in Excel
  • How to get Holiday Date from Year in Excel
  • Calculate cumulative loan principal payments in Excel
  • EFFECT function: Description, Usage, Syntax, Examples and Explanation
  • DOLLARFR function: Description, Usage, Syntax, Examples and Explanation
  • Calculate cumulative loan interest in Excel
  • How to calculate annuity for interest rate in excel
© 2022 xlsoffice . All Right Reserved. | Teal Smiles