Question

Calculate Quantiles and 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

Answer 1

Answers :

Quantiles & Percentiles	DIS	DAX	Nikkei225	FTSE100
10%	102.02	27.41	21,737.59	7,578.77
15%	102.77	27.43	21,786.71	7,592.59
20%	103.06	27.60	21,788.14	7,597.62
25%	103.26	27.80	21,788.14	7,602.53	Quartile-1
30%	103.33	27.83	21,809.55	7,616.25
35%	103.39	27.83	21,938.21	7,617.70
40%	104.56	27.87	22,079.34	7,619.42
45%	105.26	27.91	22,191.09	7,630.01
50%	106.66	27.95	22,250.70	7,644.10	Quartile-2
55%	107.88	27.95	22,494.86	7,658.19
60%	108.48	28.06	22,597.35	7,661.90
65%	108.48	28.09	22,597.35	7,661.90
70%	108.69	28.09	22,607.35	7,676.55
75%	108.88	28.14	22,697.49	7,678.80	Quartile-3
80%	109.47	28.15	22,697.88	7,678.80
85%	109.94	28.23	22,697.88	7,681.66
90%	109.94	28.29	22,744.64	7,686.80
95%	110.48	28.32	22,789.76	7,691.40

Explnataion:

## End of answers