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

question 50

Multiple Choice

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)

---

Definitions:

Periderm

is the protective outer secondary layer of bark in woody plants and trees, comprising the phellem, phellogen, and phelloderm.

Sapwood

The outer, younger part of a tree's trunk or branch that is active in transporting water and minerals from the roots to the leaves.

Secondary Xylem

Plant tissue that transports water and nutrients upwards from the roots; it also provides structural support and is a major component of wood.

Water Potential

Free energy of water; the water potential of pure water is zero and that of solutions is a negative value. Differences in water potential are used to predict the direction of water movement (always from a region of less negative water potential to a region of more negative water potential).