Answered step by step
Verified Expert Solution
Question
1 Approved Answer
How do get the number 0.4633469 in Excel ??? please show me in a way, thank you PORTFOLIO PORTFOLIO PORTFOLIO SD ticker weight Return arith
How do get the number 0.4633469 in Excel ???
please show me in a way, thank youPORTFOLIO PORTFOLIO PORTFOLIO SD ticker weight Return arith return geo SD RETURN ARITH RETURN GEO VAR PORTFOLIO 1 2 TLKM 0,2 2,96% 2,76% 7% 1,16% 2,359% 0,002413138 4,91% 3 JSMR 0,5 0,29% 0% 7% 4 BBCA 0,3 1% 6% 6% 5 6 7 CORR 8 TLKM JSMR 33% 9 TLKM BBCA 36% 10 JSMR BBCA 28% 11 12 0,4633469 0,0797424 0,456911 13 TLKM JSMR BBCA return 14 0,4633469 TLKM 0,00535607 0,0015895 0,001513 2,96% 15 0,07974243 JSMR 0,00158947 0,0041419 0,001029 0,29% 16 0,45691067 BBCA 0,00151309 0,0010289 0,003235 1% 17 1 0,00152896 0,0001226 0,001033 18 0,02032941 mean 19 0,00134234 sd 20 15,1447913 sharpe PORTFOLIO PORTFOLIO PORTFOLIO SD ticker weight Return arith return geo SD RETURN ARITH RETURN GEO VAR PORTFOLIO 1 2 TLKM 0,2 2,96% 2,76% 7% 1,16% 2,359% 0,002413138 4,91% 3 JSMR 0,5 0,29% 0% 7% 4 BBCA 0,3 1% 6% 6% 5 6 7 CORR 8 TLKM JSMR 33% 9 TLKM BBCA 36% 10 JSMR BBCA 28% 11 12 0,4633469 0,0797424 0,456911 13 TLKM JSMR BBCA return 14 0,4633469 TLKM 0,00535607 0,0015895 0,001513 2,96% 15 0,07974243 JSMR 0,00158947 0,0041419 0,001029 0,29% 16 0,45691067 BBCA 0,00151309 0,0010289 0,003235 1% 17 1 0,00152896 0,0001226 0,001033 18 0,02032941 mean 19 0,00134234 sd 20 15,1447913 sharpe
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started