Solved

Use the Data Given Below to Answer the Following Question

question 83

Multiple Choice

Use the data given below to answer the following question.
Following is the purchase order database of 'The Chef Says So', a restaurant in New York, over the last quarter April-June) . $\begin{array}{|c|c|c|c|r|r|}\hline\text { Order Date } & \text { Item } & \text { Region } & \text { Supplier } & \text { Unit Cost } & {\text { Units }} \\\hline 5 / 6 / 2012 & \text { SteelFork } & \text { Antasia } & \text { Peter } & 5.44 & 98 \\\hline 4 / 7 / 2012 & \text { Ceramic Plate } & \text { Puitoria } & \text { Kane } & 23.44 & 53 \\\hline 5 / 13 / 2012 & \text { Steel Fork } & \text { Puitoria } & \text { Jones } & 8.44 & 39 \\\hline 6 / 10 / 2012 & \text { Silver Spoon } & \text { Puitoria } & \text { Gerry } & 23.44 & 30\\\hline 6 / 22 / 2012 & \text { SteelFork } & \text { Almeco } & \text { Sarah } & 6.44 & 59 \\\hline 5 / 17 / 2012 & \text { Ceramic Plate } & \text { Antasia } & \text { Peter } & 8.44 & 63 \\\hline 4 / 25 / 2012 & \text { SteelFork } & \text { Puitoria } & \text { Audrey } & 5.44 & 78 \\\hline 6 / 1 / 2012 & \text { SteelFork } & \text { Puitoria } & \text { Jones } & 8.44 & 93 \\\hline 4 / 2 / 2012 & \text { SteelFork } & \text { Almeco } & \text { Thomas } & 5.44 & 35 \\\hline 5 / 27 / 2012 & \text { Ceramic Plate } & \text { Antasia } & \text { Peter } & 12.44 & 63 \\\hline 6 / 13 / 2012 & \text { Steel Fork } & \text { Puitoria } & \text { Mary } & 8.44 & 93 \\\hline 4 / 30 / 2012 & \text { Ceramic Plate } & \text { Antasia } & \text { Henry } & 5.44 & 32 \\\hline 5 / 11 / 2012 & \text { Ceramic Plate } & \text { Antasia } & \text { Philip } & 23.44 & 84 \\\hline 6 / 18 / 2012 & \text { Steel Fork } & \text { Antasia } & \text { Peter } & 8.44 & 38 \\\hline 5 / 9 / 2012 & \text { Glass Bottle } & \text { Puitoria } & \text { Simson } & 128.45 & 5 \\\hline 5 / 30 / 2012 & \text { Ceramic Bowl } & \text { Antasia } & \text { Peter } & 19.44 & 19 \\\hline 6 / 6 / 2012 & \text { Ceramic Plate } & \text { Puitoria } & \text { Mary } & 12.44 & 31 \\\hline 4 / 3 / 2012 & \text { Silver Spoon } & \text { Antasia } & \text { Peter } & 12.44 & 67 \\\hline 6 / 26 / 2012 & \text { Silver Spoon } & \text { Antasia } & \text { Philip } & 23.44 & 18\\\hline 4 / 23 / 2012 & \text { Ceramic Bowl } & \text { Puitoria } & \text { Kane } & 8.44 & 99 \\\hline 4 / 29 / 2012 & \text { Steel Fork } & \text { Puitoria } & \text { Simson } & 4.74 & 70 \\\hline 4 / 4 / 2012 & \text { Ceramic Bowl } & \text { Antasia } & \text { Philip } & 19.44 & 77 \\\hline 6 / 15 / 2012 & \text { Ceramic Plate } & \text { Puitoria } & \text { Gerry } & 12.44 & 49 \\\hline 6 / 25 / 2012 & \text { Ceramic Plate } & \text { Puitoria } & \text { Simson } & 18.45 & 90 \\\hline 5 / 23 / 2012 & \text { Ceramic Plate } & \text { Antasia } & \text { Peter } & 8.44 & 7 \\\hline 6 / 28 / 2012 & \text { Ceramic Plate } & \text { Almeco } & \text { Sarah } & 23.44 & 10 \\\hline 5 / 25 / 2012 & \text { Ceramic Bowl } & \text { Puitoria } & \text { Jones } & 8.44 & 53 \\\hline 5 / 1 / 2012 & \text { SteelFork } & \text { Puitoria } & \text { Audrev } & 5.44 & 69\\\hline\end{array}$
$\quad$ $\begin{array}{|c|c|c|c|r|r|}\hline\text { Order Date } & \text { Item } & \text { Region } & \text { Supplier } & \text { Unit Cost } & {\text { Units }} \\\hline 4 / 12 / 2012 & \text { Silver Spoon } & \text { Antasia } & \text { Henry } & 8.44 & 99 \\\hline 4 / 18 / 2012 & \text { SteelFork } & \text { Puitoria } & \text { Gerry } & 4.74 & 56 \\\hline 6 / 30 / 2012 & \text { Ceramic Plate } & \text { Puitoria } & \text { Gerry } & 12.44 & 83 \\\hline 5 / 19 / 2012 & \text { Glass Bottle } & \text { Puitoria } & \text { Kane } & 128.45 & 8 \\\hline 4 / 16 / 2012 & \text { Ceramic Bowl } & \text { Antasia } & \text { Peter } & 8.44 & 65 \\\hline 6 / 4 / 2012 & \text { Ceramic Bowl } & \text { Puitoria } & \text { Mary } & 15.94 & 58 \\\hline 5 / 2 / 2012 & \text { Ceramic Bowl } & \text { Puitoria } & \text { Kane } & 27.4 & 45 \\\hline 4 / 19 / 2012 & \text { Glass Bottle } & \text { Almeco } & \text { Sarah } & 278.45 & 6 \\\hline 6 / 11 / 2012 & \text { Steel Fork } & \text { Puitoria } & \text { Gerry } & 4.74 & 10 \\\hline 5 / 31 / 2012 & \text { Silver Spoon } & \text { Almeco } & \text { Sarah } & 5.44 & 79 \\\hline 6 / 2 / 2012 & \text { Ceramic Plate } & \text { Almeco } & \text { Thomas } & 23.44 & 60 \\\hline 4 / 13 / 2012 & \text { SteelFork } & \text { Puitoria } & \text { Audrey } & 4.74 & 17 \\\hline 5 / 3 / 2012 & \text { Ceramic Plate } & \text { Puitoria } & \text { Jones } & 8.44 & 14 \\\hline 6 / 3 / 2012 & \text { Ceramic Plate } & \text { Puitoria } & \text { Jones } & 23.44 & 97 \\\hline 4 / 17 / 2012 & \text { Ceramic Plate } & \text { Puitoria } & \text { Audrey } & 8.44 & 31 \\\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.

Definitions:

Leasehold Estate

An interest in land that grants the tenant exclusive possession until a specific date.

Restrictive Covenant

A clause typically in an employment or real estate contract that limits what the buyer or employee can do, ensuring certain actions are refrained from.

Tenants in Common

A form of co-ownership where individuals hold undivided interests in a property without rights of survivorship, allowing different ownership shares.

Joint Tenancy

A form of property ownership in which two or more individuals hold equal rights to the entire property, and upon the death of one, the survivor(s) automatically assume the deceased's part.