注册 登录
上一主题：Is the CFA L1 curriculum interesting (On a scale of 1 - 10)
下一主题：作为过来人，愿为大家免费答疑
返回列表 发帖
suyash1989

Rank: 2

UID
223265 
帖子
251 
主题
116 
注册时间
2011-7-11 
最后登录
2016-4-21 
1# 跳转到 » 倒序看帖
打印
tT
发表于 2011-7-26 11:13 | 只看该作者

Negative Standard Deviation?

about, question, possible, excel
Ok heres a question i ws thinking about when doing some work in excel...

The variance of a 2 asset port = (Wa^2)(Var a) + (Wb^2)(Var b) + 2(Wa)(Wb)(Std a)(Std b)(Correl (a,b))

My question is this...lets say the correlation is -1. Wouldnt it be possible to get a variance of the portfolio that is negative? What would that mean? or am i thinking a bout this wrong?

 

相关主题：

. Negative Standard Deviation?

. Negative Standard Deviation?

. Option & Bond Valuaion With Excel VBA

. question about Fixed-Income Forward and Futures Contracts

. question about binomial interest rate tree

收藏 分享

random_walker47

Rank: 2

UID
223429 
帖子
305 
主题
8 
注册时间
2011-7-11 
最后登录
2014-8-7 
2#
发表于 2011-7-26 11:19 | 只看该作者
Variance is squared, removes the negative, and standard dev is obviously the square root of variance which makes it impossible to have a negative standard deviation.

Standard deviation can be zero, but never negative. Both sides of the distribution result in positive value for standard deviation.

I think you're thinking about this one a little too hard.



Edited 2 time(s). Last edit at Thursday, June 23, 2011 at 11:39AM by Chuckrox8.

TOP

bcp901

Rank: 2

UID
223387 
帖子
232 
主题
62 
注册时间
2011-7-11 
最后登录
2014-8-7 
3#
发表于 2011-7-26 11:24 | 只看该作者
Spanishesk Wrote:
-------------------------------------------------------
> Ok heres a question i ws thinking about when doing
> some work in excel...
>
> The variance of a 2 asset port = (Wa^2)(Var a) +
> (Wb^2)(Var b) + 2(Wa)(Wb)(Std a)(Std b)(Correl
> (a,b))
>
> My question is this...lets say the correlation is
> -1. Wouldnt it be possible to get a variance of
> the portfolio that is negative? What would that
> mean? or am i thinking a bout this wrong?

Yes. If the third part of the equation is negative enough to make the summation negative, variance become negative and standard deviation become meaning less as there is no square root for negatives.

However, it is a mathematical truth that third part of the equation can't make the summation negative. The most it can do is making the variance zero (I don't know how to prove it, but know as a fact).

TOP

noel

Rank: 2

UID
223372 
帖子
446 
主题
85 
注册时间
2011-7-11 
最后登录
2014-8-2 
4#
发表于 2011-7-26 11:30 | 只看该作者
The least you can get is when the variances are equal, the weight is equal and correlation is -1. In this case the formula reduces [by letting Wa = Wb, and var(a) = var(b)] to:

2*(Wa^2)(Var(a)) + (-1)*2(Wa^2)(Var(a)) = 0

You will never get a negative variance.

TOP

tango_gs

Rank: 3Rank: 3

UID
223347 
帖子
460 
主题
48 
注册时间
2011-7-11 
最后登录
2013-8-23 
5#
发表于 2011-7-26 11:35 | 只看该作者
Spanishesk Wrote:
-------------------------------------------------------
> Ok heres a question i ws thinking about when doing
> some work in excel...
>
> The variance of a 2 asset port = (Wa^2)(Var a) +
> (Wb^2)(Var b) + 2(Wa)(Wb)(Std a)(Std b)(Correl
> (a,b))
>
> My question is this...lets say the correlation is
> -1. Wouldnt it be possible to get a variance of
> the portfolio that is negative? What would that
> mean? or am i thinking a bout this wrong?

The variance of a 2 asset port = (Wa^2)(Var a) +(Wb^2)(Var b)
+2(Wa)(Wb)(Std a)(Std b)(Correl(a,b)) = (wa*Std a-wb*Std b)^2+2*Wa*Wb*Std a*Std b*(1+cor(a,b)). Each term is non-negative. Therefore, the sum is non-negative.

TOP

economicz

Rank: 2

UID
223395 
帖子
345 
主题
9 
注册时间
2011-7-11 
最后登录
2016-4-19 
6#
发表于 2011-7-26 11:40 | 只看该作者
Forget about formulas. Just think for a second...what is standard deviation? And how can it be negative?

TOP

NakedPuts2011

Rank: 2

UID
222288 
帖子
321 
主题
3 
注册时间
2011-7-2 
最后登录
2015-12-13 
7#
发表于 2011-7-26 11:46 | 只看该作者
Iginla2010 Wrote:
-------------------------------------------------------
> Forget about formulas. Just think for a
> second...what is standard deviation? And how can
> it be negative?


my thoughts exactly....

TOP

yodacaia

Rank: 2

UID
223454 
帖子
341 
主题
12 
注册时间
2011-7-11 
最后登录
2014-8-7 
8#
发表于 2011-7-26 11:51 | 只看该作者
obviously it cant be negative. But mathematically i looked at the equation and started thinking if the third part of the equation was negative enough, it could lead to a negative result. Was just trying to see if it was possible in the equation. I am fully aware that negative std dev wouldnt make sense.

TOP

sabre

Rank: 3Rank: 3

UID
223198 
帖子
385 
主题
170 
注册时间
2011-7-11 
最后登录
2016-4-19 
9#
发表于 2011-7-26 11:57 | 只看该作者
In a two asset portfolio assuming perfect negative correlation your standard deviation would be zero. The third part of the variance equation would most certainly be negative, but the first two expressions would be equal to that amount.

Part of the equation can certainly be less than zero, but it will always be offset by the first two expressions.

TOP

SeanWest

Rank: 2

UID
223460 
帖子
322 
主题
9 
注册时间
2011-7-11 
最后登录
2014-8-7 
10#
发表于 2011-7-26 12:07 | 只看该作者
You guys need to seriously get a life. Evidently I do to for even reading this whole thread...

TOP

返回列表
上一主题：Is the CFA L1 curriculum interesting (On a scale of 1 - 10)
下一主题：作为过来人，愿为大家免费答疑