In: Finance
In below mentioned table values are calculated along with Excel Formula used
Price | ||
Date | EMAAR MALLS | ARMX |
01-Jan-17 | 2.64 | 4.04 |
08-Jan-17 | 2.65 | 4.11 |
15-Jan-17 | 2.58 | 4.05 |
22-Jan-17 | 2.58 | 4.09 |
29-Jan-17 | 2.53 | 4.27 |
05-Feb-17 | 2.6 | 4.19 |
12-Feb-17 | 2.57 | 4.36 |
19-Feb-17 | 2.59 | 4.65 |
26-Feb-17 | 2.68 | 4.8 |
05-Mar-17 | 2.65 | 5.5 |
12-Mar-17 | 2.64 | 5.14 |
19-Mar-17 | 2.56 | 5 |
26-Mar-17 | 2.64 | 4.95 |
02-Apr-17 | 2.65 | 5.2 |
09-Apr-17 | 2.62 | 5.25 |
16-Apr-17 | 2.68 | 5.3 |
23-Apr-17 | 2.57 | 5.28 |
30-Apr-17 | 2.51 | 5.33 |
Average Return | 2.61 | 4.75 |
Standard Deviation | 0.05 | 0.53 |
Correlation | 0.17 | |
Corvariance | 0.00 | |
Formula Used | ||
Average Return | AVERAGE(D5:D22) | AVERAGE(E5:E22) |
Standard Deviation | STDEV(D5:D22) | STDEV(E5:E22) |
Correlation | CORREL(D5:D22,E5:E22) | |
Corvariance | COVARIANCE.P(D5:D22,E5:E22) |