Türk | İngilizce |
---|---|
KOVARYANS.P | COVARIANCE.P |
Definition and Usage of the KOVARYANS.P Function
KOVARYANS.P is a statistical function in Microsoft Excel and Google Sheets used to measure the strength of the relationship between two data sets by calculating their covariance. This function helps determine both the direction (positive or negative) and the intensity of the relationship between these sets. A positive relationship indicates that as values in one series increase, values in the other series also increase. Conversely, in a negative relationship, as values in one series increase, those in the other decrease.
Syntax and Examples
The general syntax for the KOVARYANS.P function is as follows:
=KOVARYANS.P(array1, array2)
- array1: The first data set for which the covariance is calculated.
- array2: The second data set with which the covariance of the first is calculated.
For example, let”s analyze the relationship between a store”s sales volume and its advertising budget:
Advertising Budget ($) | Sales Volume (Units) |
---|---|
1500 | 300 |
2000 | 450 |
1000 | 200 |
1200 | 250 |
=KOVARYANS.P(A2:A5, B2:B5)
This function will give a positive covariance value as it is observed that increases in the advertising budget correspond with increases in sales.
Practical Usage Scenarios
1. Market Research
Companies can use the KOVARYANS.P function to understand how demand for their products changes in response to various factors, such as the relationship between temperature and ice cream sales. A high positive covariance value indicates increased ice cream sales on hotter days.
January Temperature (°C): 10, 15, 20, 25, 30 Ice Cream Sales (Units): 200, 240, 300, 350, 400 =KOVARYANS.P(A2:A6, B2:B6)
2. Evaluating Financial Investments
Investors can use covariance calculations between different investment returns to better manage their portfolios. High covariance indicates similar responses of financial assets to market conditions.
Deposit Interest Rate (%): 1.5, 2.0, 2.5, 3.0 Stock Market Returns (%): 5, 7, 9, 12 =KOVARYANS.P(A2:A5, B2:B5)
In this example, the positive covariance between deposit interest rates and stock market returns suggests that as interest rates rise, so do stock market returns.
Daha fazla bilgi: https://support.microsoft.com/tr-tr/office/kovaryans-p-işlevi-6f0e1e6d-956d-4e4b-9943-cfef0bf9edfc