Question: Date Open High Low Close Adj Close Volume 23/04/2018 12.9 13.35 12.9 13.2 11.814017 3692900 24/04/2018 13.29 13.64 13.12 13.41 12.001967 3613600 25/04/2018 13.35 13.63

Date Open High Low Close Adj Close Volume
23/04/2018 12.9 13.35 12.9 13.2 11.814017 3692900
24/04/2018 13.29 13.64 13.12 13.41 12.001967 3613600
25/04/2018 13.35 13.63 13.29 13.46 12.046718 3647100
26/04/2018 13.6 13.88 13.45 13.67 12.234669 3212000
27/04/2018 13.68 13.91 13.6 13.86 12.404718 2500600
30/04/2018 13.97 14 13.56 13.65 12.216769 3151900

**please include excel formula**

- use the figures in the chart above to help calculate each of the following -

In the excel data above how do you calculate the following;

1. The minimum daily return 2 the maximum daily return 3. A count of the number of observations on return 4. graph a time series of daily returns.

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!