In: Statistics and Probability
Calculate Percentile in Excel for DIS, DAX, Nikkei225 and FTSE100.
Please also plot a histogram in your Excel file.
Date |
DIS |
DAX |
Nikkei225 |
FTSE100 |
7/1/18 |
102.54 |
27.46 |
22304.51 |
7636.90 |
7/2/18 |
103.05 |
27.32 |
21811.93 |
7547.90 |
7/3/18 |
101.79 |
27.41 |
21785.54 |
7593.30 |
7/4/18 |
101.79 |
27.41 |
21717.04 |
7573.10 |
7/5/18 |
103.06 |
27.87 |
21546.99 |
7603.20 |
7/6/18 |
103.33 |
27.95 |
21788.14 |
7617.70 |
7/7/18 |
103.33 |
27.95 |
21788.14 |
7617.70 |
7/8/18 |
103.33 |
27.95 |
21788.14 |
7617.70 |
7/9/18 |
104.56 |
28.15 |
22052.18 |
7688.00 |
7/10/18 |
104.57 |
28.30 |
22196.89 |
7692.00 |
7/11/18 |
106.55 |
27.70 |
21932.21 |
7592.00 |
7/12/18 |
106.76 |
27.89 |
22187.96 |
7651.30 |
7/13/18 |
108.48 |
27.83 |
22597.35 |
7661.90 |
7/14/18 |
108.48 |
27.83 |
22597.35 |
7661.90 |
7/15/18 |
108.48 |
27.83 |
22597.35 |
7661.90 |
7/16/18 |
108.68 |
28.13 |
22597.35 |
7600.50 |
7/17/18 |
108.78 |
28.28 |
22697.36 |
7626.30 |
7/18/18 |
109.16 |
28.32 |
22794.19 |
7676.30 |
7/19/18 |
110.58 |
28.16 |
22764.68 |
7684.00 |
7/20/18 |
109.94 |
28.09 |
22697.88 |
7678.80 |
7/21/18 |
109.94 |
28.09 |
22697.88 |
7678.80 |
7/22/18 |
109.94 |
28.09 |
22697.88 |
7678.80 |