Question

• How do you find the 90^th percentile of the data from Table 1 in Question #2 using Percentile.INC( ) function in Excel.

Table 1: Health Expenditures as a Percentage of GDP of countries around the world

3.35	5.96	10.64	5.24	3.79	5.65
7.66	7.38	5.87	11.15	5.96	4.78
7.75	2.72	9.50	7.69	10.05	11.96
8.18	6.74	5.89	6.20	5.98	8.83
6.78	6.66	9.45	5.41	5.16	8.55

Answer 1

In this problem we have to used the command(=PERCENTILE.INC(A1:A30,0.9))
we get a 90th percentile .
you can run this command in excel with given command.