how to find the return for the columns that are blank . 

-return for risky free weekly 

-return for portfolio weekly 

-return for market value weekly 

-return for risk-free monthly 

-R(P) monthly 

-R(M) monthly 

arithmetic average 

standard deviation 

variance 

Geometric average  

 

Transcribed Image Text:

Week Arithmetic Average Stdev Variance Geomatric average Portfolio (Value) 0 1 500095.8983 2 500536.7097 3 497800.9023 4 495260.9205 5 502178.4363 6 485254.2777 7 466992.1498 500000 Notes: 1 You ASX 200 (^AXJO) Risk-free rate (%) r(P) weekly r(M) weekly 1386.91 1393.62 1402.01 1396.69 1350.57 1350.7 1331.25 1303.31 2.31 0.000191797 0.004838093 2.31 0.000881454 0.006020292 2.31 -0.00546575 -0.003794552 2.76 -0.0051024 -0.033020928 2.76 0.013967417 9.62557E-05 2.76 -0.03370148 -0.014399941 2.76 -0.03763414 -0.020987793 any calculation for wook 0 r(f) weekly ? ? ? ? ? ? r(P) monthly ? ? ? ? ? ? ? r(M) monthly ? ? ? ? ? ? r(f) monthly R(P) monthly R(M) monthly ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? regression res Week Arithmetic Average Stdev Variance Geomatric average Portfolio (Value) 0 1 500095.8983 2 500536.7097 3 497800.9023 4 495260.9205 5 502178.4363 6 485254.2777 7 466992.1498 500000 Notes: 1 You ASX 200 (^AXJO) Risk-free rate (%) r(P) weekly r(M) weekly 1386.91 1393.62 1402.01 1396.69 1350.57 1350.7 1331.25 1303.31 2.31 0.000191797 0.004838093 2.31 0.000881454 0.006020292 2.31 -0.00546575 -0.003794552 2.76 -0.0051024 -0.033020928 2.76 0.013967417 9.62557E-05 2.76 -0.03370148 -0.014399941 2.76 -0.03763414 -0.020987793 any calculation for wook 0 r(f) weekly ? ? ? ? ? ? r(P) monthly ? ? ? ? ? ? ? r(M) monthly ? ? ? ? ? ? r(f) monthly R(P) monthly R(M) monthly ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? regression res

Answer rating: 100% (QA)

The formula to find the return for blank columns in the spreadsheet depends on what the blank cell represents There are two main interpretations Missing return data If the blank cells represent missin... View the full answer