Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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 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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Access Audit Handbook

Authors: Alison Grant

1st Edition

1859461778, 978-1859461778

More Books

Students also viewed these Accounting questions

Question

List the advantages and disadvantages of the pay programs. page 505

Answered: 1 week ago