Use the data given below to answer the following question(s).
Following is an extract from the Employee Payroll Database of HFR Informatics Inc.

-The Excel 2010 function ________ computes the kᵗʰ percentile of data in the range specified in the array field, where k is in the range 0 to 1, inclusive.
A)PERCENTILE.INC(array, k)
B)PERCENTILE(array + k)
C)PERCENTILE.IF(array, k)
D)PERCENTILE(SUM(array), k)

Question

Use the data given below to answer the following question(s).
Following is an extract from the Employee Payroll Database of HFR Informatics Inc.
 
-The Excel 2010 function ________ computes the kᵗʰ percentile of data in the range specified in the array field, where k is in the range 0 to 1, inclusive.
A)PERCENTILE.INC(array, k) 
B)PERCENTILE(array + k) 
C)PERCENTILE.IF(array, k) 
D)PERCENTILE(SUM(array), k)

Quizplus · Accepted Answer

The function PERCENTILE.INC computes the kth percentile of data in the range specified in the array field, where k is in the range 0 to 1, inclusive. The other choices either have incorrect syntax or do not perform the required computation.

Use the Data Given Below to Answer the Following Question(s)