Question: Can anyone help me understand the functions and steps needed to solve this question? I understand you might not be able to give the answer

Can anyone help me understand the functions and steps needed to solve this question? I understand you might not be able to give the answer without the files but I simply need the steps to help solve it.

Calculate the average monthly returns and the standard deviation of returns for these two stocks from 2015/11 to 2020/08. Make sure you use the stdev.s function for standard deviation calculation.

A: Average Return is 76.42% for Tesla and is 172.53% for Nvidia. Standard deviation is 71.03% for Tesla, and 103.87% for Nvidia.

B: Average Return is 5.82% for Tesla and is 6.04% for Nvidia. Standard deviation is 18.50% for Tesla, and 12.91% for Nvidia

Can anyone help me understand the functions and steps needed to solvethis question? I understand you might not be able to give theanswer without the files but I simply need the steps to help

C9fx45.89

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!