Hello, can somebody show me how to solve this question on excel? I was able to get
Fantastic news! We've Found the answer you've been seeking!
Question:
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/06/667bbd50efec1_424667bbd50cf245.jpg)
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/06/667bbd515f462_425667bbd5142225.jpg)
Hello,
can somebody show me how to solve this question on excel? I was able to get the correlation but I'm not sure how to compute (b) or ( c ), for A it says to multiply the monthly standard deviation by the square root of 12.
I wasnt able to put the excel data up but I put pictures of it. Don't need to compute the answer, just instructions would be fine as well.
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/06/667bbd51bec90_425667bbd5194f66.jpg)
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/06/667bbd5232c9d_426667bbd520aca5.jpg)
Posted Date: