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

question 12

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. $\begin{array}{|l|l|l|l|c|}\hline\text { Employee } & \text { Ethnic Group } & \text { Gender } & \begin{array}{c}\text { Rank / } \\\text { Grade }\end{array} & \begin{array}{c}\text { Pay } \\\text { Scale }\end{array} \\\hline \text { Maria } & \text { Asian American } & \text { Female } & 3 & \text { A } \\\hline \text { Peter } & \text { White American } & \text { Male } & 2 & \text { B } \\\hline \text { George } & \text { Hispanic } & \text { Male } & 1 & \text { C } \\&\text { American }\\\hline \text { Smith } & \text { Black American } & \text { Female } & 1 & \text { D } \\\hline \text { Johnson } & \text { Alaska Native } & \text { Male } & 2 & \text { E } \\\hline \text { Thompson } & \text { Asian American } & \text { Male } & 2 & \text { B } \\\hline \text { Martinez } & \text { Alaska Native } & \text { Male } & 3 & \text { A } \\\hline \text { Lewis } & \text { White American } & \text { Female } & 2 & \text { B } \\\hline \text { Lee } & \text { Black American } & \text { Male } & 2 & \text { A } \\\hline \text { Taylor } & \text { Asian American } & \text { Female } & 1 & \text { B } \\\hline \text { Carter } & \text { Asian American } & \text { Male } & 2 & \text { C } \\\hline \text { Edwards } & \text { Hispanic } & \text { Male } & 2 & \text { E } \\&\text { American }\\\hline \text { Bailey } & \text { White American } & \text { Male } & 2 & \text { B } \\\hline \text { Cooper } & \text { White American } & \text { Male } & 2 & \text { A } \\\hline \text { Bill } & \text { Alaska Native } & \text { Male } & 3 & \text { E } \\\hline \text { Cox } & \text { Asian American } & \text { Male } & 1 & \text { A } \\\hline \text { Perry } & \text { Hispanic } & \text { Female } & 2 & \text { C } \\&\text { American }\\\hline \text { Flores } & \text { Alaska Native } & \text { Female } & 2 & \text { B } \\\hline \text { Woods } & \text { White American } & \text { Male } & 3 & \text { E } \\\hline \text { Cole } & \text { Asian American } & \text { Female } & 1 & \text { A } \\\hline\end{array}$
-The Excel 2010 function computes the kth 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:

Inversion

In chemistry, this refers to the process by which the spatial arrangement of atoms in a molecule is reversed.

Retention

The phenomenon where the configuration of a molecule remains unchanged during or after a chemical process.

Substitution

A chemical reaction in which an atom or group of atoms is replaced with a different atom or group of atoms in a molecule.

Specific Rotation

A measure of the degree to which a compound can rotate plane-polarized light, typically expressed in degrees and dependent on concentration, temperature, and wavelength.