TestMagic

Zay60 · 01-22-2008, 05:22 PM

Excuse me does any one know the functions or commands in excel to calculate the portfolio variance of seven assets in excel?

chartreuse · 01-23-2008, 02:20 PM

why don't you first use the standard deviation and then square that figure to get the variance?
St dev in Excel is "=Stdev(a,b)"

01-22-2008, 05:22 PM	#1 (permalink)
Zay60 Trying to make mom and pop proud Join Date: Dec 2007 Posts: 8	Fin Modellin: Portfolio Analysis Excuse me does any one know the functions or commands in excel to calculate the portfolio variance of seven assets in excel?

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

01-23-2008, 02:20 PM	#2 (permalink)
chartreuse At Crossroads Join Date: Oct 2007 Posts: 56	why don't you first use the standard deviation and then square that figure to get the variance? St dev in Excel is "=Stdev(a,b)"

Free GMAT, GRE, SAT Test, TOEFL practice tests