Excel Question
Need help with this assignment?Get an original answer from a qualified tutor — from $10/page.
Get it written →Stock Assignment: Union Pacific Group
1) Download 61 months of data (5 years + 1 month)
2) Use the “Adjusted Close” price
3) Calculate the monthly return
4) Plot the monthly return.
5) Calculate the mean and standard deviation of the monthly return (express as percentages)
6) Use the first and last price, calculate the geometric average monthly rate of return.
7) Convert this to an annual number.
Get a plagiarism-free answer to this question
Send us your instructions and we’ll match you with the best writer in your subject.
- 100% human-written, zero AI
- Turnitin report included
- Confidential — we never share your data
- Free revisions & refunds