How To Calculate

Learn how to calculate anything
Menu
  • bmi
Home
statistics
How to Calculate Covariance in Excel.
statistics

How to Calculate Covariance in Excel.

Rosemary Njeri

Covariance measures the directional relationship between the return on two assets.

Covariance is used in portfolio theory to determine what assets to include in the portfolio.

Formula to calculate covariance in excel.

To calculate covariance in excel, we use the COVARIANCE Function.

There are two covariance functions;

i). COVARIANCE.P – Used to calculate population covariance.

ii). COVARIANCE.S – Used to calculate sample covariance.

Example:

Calculate the covariance of the following data set.

Day of the WeekHighest TemperatureLowest Temperature
Monday3712
Tuesday4015
Wednesday283
Thursday212
Friday3714
Saturday253
Sunday254

We begin by transferring the data onto an excel worksheet.

Calculate Covariance in Excel.

Fill the function argument sector and get your answer.

Calculate Covariance in Excel.

Therefore, your covariance is 35.75510204.

Share
Tweet
Reddit
Pinterest
Email
Prev Article
Next Article

Related Articles

How to Calculate Income Elasticity of Demand.
Income elasticity of demand (IED) refers to the sensitivity of …

How to Calculate Income Elasticity of Demand.

How to Calculate GDP per Capita.
GDP is the gross domestic product of a country. It …

How to Calculate GDP per Capita.

Leave a Reply Cancel Reply

Popular Posts

  • 5 Best AI Apps for Solving Complex …
    March 22, 2023 0

Categories

learntocalculate.com is a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for sites to earn advertising fees by advertising and linking to amazon.com.

How To Calculate

Learn how to calculate anything

Pages

  • About Us
  • Contact Us
  • Privacy Policy
Copyright © 2023 How To Calculate

Ad Blocker Detected

Our website is made possible by displaying online advertisements to our visitors. Please consider supporting us by disabling your ad blocker.

Refresh