Question: how to find the return for the columns that are blank . -return for risky free weekly -return for portfolio weekly -return for market value
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
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
Step by Step Solution
3.38 Rating (157 Votes )
There are 3 Steps involved in it
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 full answer
Get step-by-step solutions from verified subject matter experts
