Administration and Executive AssistantTier 825 minadvanced

COVARIANCE.P

Calculate population covariance between two related variables, using the right divisor.

What you will learn

• Use COVARIANCE.P to calculate the population covariance between two variables
• Explain that COVARIANCE.P divides by n, the full count of pairs
• Recognise the scaling error introduced by dividing by (n-1) instead, the way a sample statistic would

Excel skills

COVARIANCE.P · Inferential Statistics

The task

Eight students' study hours and exam scores are listed. Work out the population covariance between them in Summary!B3.

You work in a real spreadsheet in your browser, and your answer is checked against hidden traps the moment you submit.

Try this lesson free