variance(p) = avg variance(asset)* [(1 - correlation)/n + correlation]
So as correlation–tendsTo–>0
the term, [(1 - correlation)/n + correlation] –tendsTo–> 1
Hence variance(p) = avg variance(asset)*[1]
Now consider the table
correlation = 0.1, n=90,
[(1 - correlation)/n + correlation] = [0.9/90 + 0.1] = 0.11
Similarly, if,
correlation = 0.5, n=23,
[(1 - correlation)/n + correlation] = [0.5/23 + 0.5] = 0.52
best possible values,
correlation = 0, n = veryLargeNumber (ex: 1000),
[(1 - correlation)/n + correlation] = [1/1000 + 0] = 0.0001
So the multiplier gets smaller and smaller…
Thus as a conclusion it is said that:
variance of the portfolio decreases as correlation decreases and also the number of assets increases to infinity.
variance(p) will become = avg variance(asset) when correlation is 0 and no of assets are infinite.
I think I got you confused even more?