3.4.4.2. Average profitability rate
through matrix data rates of 5 securities profitability we continue measures the average profitability of each stock based on the ratio of profitability calculated just once securities through 4 years of observation.
Using the AVERAGE function (ref profitability)
3.4.4.3. Variance and standard deviation:
Also with profitability ratio matrix we calculate the variance for each stock using VARP function (TSSL)
From the variance of 5 securities, we calculate the standard deviation of the stock by the SQRT (variance) of the stock has been calculated. Results are as follows:
đang được dịch, vui lòng đợi..