Question: Based on the excel attached, calculate the montly return as seen in dass (column C) and compute: a) The average return: b) The variance: c)

 Based on the excel attached, calculate the montly return as seen
in dass (column C) and compute: a) The average return: b) The

Based on the excel attached, calculate the montly return as seen in dass (column C) and compute: a) The average return: b) The variance: c) The Standard Deviation: d) The standasd Error: Based on past performance and given a 95% confidence interval, the expected retum range is: e) Lower bound expected eeturn: 1) Upper bound expected retum: \begin{tabular}{|l|l|l|} \hline 1 & Date & Ad Close \\ \hline 2 & 2020/1/1 & 91509404 \\ \hline 3 & 2020/2/1 & 8567.3701 \\ \hline 4 & 2020/3/1 & 77001001 \\ \hline 5 & 2020/4/1 & 8889.5498 \\ \hline 6 & 2020/5/1 & 9489.8701 \\ \hline 7 & 2020/6/1 & 10058.77 \\ \hline 8 & 2020/7/1 & 10745.27 \\ \hline 9 & 2020/8/1 & 11775.46 \\ \hline 10 & 2020/9/1 & 1116751 \\ \hline 11 & 2020/10/1 & 10911.59 \\ \hline 12 & 2020/11/1 & 12198.74 \\ \hline 13 & 2020/12/1 & 12888.28 \\ \hline 14 & 2021/1/1 & 13070.69 \\ \hline 15 & 2021/2/1 & 1319235 \\ \hline 16 & 2021/3/1 & 13246.87 \\ \hline 17 & 2021/4/1 & 13962.68 \\ \hline 18 & 2021/5/1 & 13748.74 \\ \hline 19 & 2021/6/1 & 14503.95 \\ \hline 30 & 2021/7/1 & 14672.68 \\ \hline 31 & 2023/3/1 & 11434.05 \\ \hline 21 & 2022/12/1 & 10466.48 \\ \hline 35 & 202/1/1 & 1158455 \\ \hline 2021/8/1 & 15259.24 \\ \hline 22 & 2021/9/1 & 14448.58 \\ \hline 23 & 2021/10/1 & 15498.39 \\ \hline 24 & 2021/11/1 & 15537.69 \\ \hline 25 & 2021/12/1 & 15644.97 \\ \hline 26 & 2022/1/1 & 14239.88 \\ \hline 27 & 2022/2/1 & 13751.4 \\ \hline 28 & 2022/3/1 & 14220.52 \\ \hline 29 & 2022/4/1 & 12334.64 \\ \hline 30 & 2022/5/1 & 12081.39 \\ \hline 31 & 2022/6/1 & 11028.74 \\ \hline 32 & 2022/7/1 & 12390.69 \\ \hline 33 & 2022/8/1 & 11816.2 \\ \hline 34 & 2022/9/1 & 10575.62 \\ \hline \end{tabular}

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!