Use the data given below to answer the following question(s). Following is the purchase order database of 'The Chef Says So', a restaurant in New York, over the last quarter (April-June). \(\begin{array}{|l|l|l|l|l|l|} \hline \text { Order Date } & \text { Item } & \text { Region } & \text { Supplier } & \begin{array}{c} \text { Unit } \\ \text { Cost } \end{array} & \text { Units } \\\hline 5 / 6 / 2012 & \text { Steel Fork } & \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 { Steel Fork } & \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 { Steel Fork } & \text { Puitoria } & \text { Audrey } & 5.44 & 78 \\ \hline 6 / 1 / 2012 & \text { Steel Fork } & \text { Puitoria } & \text { Jones } & 8.44 & 93 \\ \hline 4 / 2 / 2012 & \text { Steel Fork } & \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 Bow1 } & \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 { Steel Fork } & \text { Puitoria } & \text { Audrey } & 5.44 & 69 \\ \hline 4 / 12 / 2012 & \text { Silver Spoon } & \text { Antasia } & \text { Henry } & 8.44 & 99 \\ \hline 4 / 18 / 2012 & \text { Steel Fork } & \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 Bow1 } & \text { Puitoria } & \text { Mary } & 15.94 & 58 \\ \hline 5 / 2 / 2012 & \text { Ceramic Bow1 } & \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 \end{array}\) $\quad$ \[\begin{array} { | c | c | l | c | r | r |} \hline 4 / 13 / 2012 & \text { Steel Fork } & \text { Puitoria } & \text { Audrey } & 4.74 & 17 \\ \hline 5 / 3 / 2012 & \text { Cerarnic Plate } & \text { Puitoria } & \text { Jones } & 8.44 & 14 \\ \hline 6 / 3 / 2012 & \text { Cerarnic Plate } & \text { Puitoria } & \text { Jones } & 23.44 & 97 \\ \hline 4 / 17 / 2012 & \text { Cerarnic Plate } & \text { Puitoria } & \text { Audrey } & 8.44 & 31 \\ \hline \end{array}\] -Construct a relative frequency distribution for items in the purchase order database and show the proportions of the frequencies visually using a pie chart.

In a new table, list out the items and u

Use the data given below to answer the following question(s). Following is an extract from the Cost per Order Database of Grogtes LLC. \(\begin{array}{|l|l|c|l|lr|} \hline\text { Item Category } & \text { Item } \mathrm{ID} &{\text { Item Cost }} & \text { Units } & \text { Cost per Order } \\ \hline \text { Nuts } & \text { N101 } & \$ 2.44 & 94 & \$ &229.36\\\hline \text { Screws } & \text { S101 } & \$ 20.44 & 49 & \$ & 1,001.56 \\ \hline \text { Nuts } & \text { N102 } & \$ 5.44 & 35 & \$ & 190.40 \\ \hline \text { Screwdriver } & \text { SD 101 } & \$ 20.44 & 26 & \$ & 531.44 \\ \hline \text { Nuts } & \text { N102 } & \$ 3.44 & 55 & \$ & 189.20 \\\hline \text { Screws } & \text { S102 } & \$ 5.44 & 59 & \$ & 320.96 \\ \hline \text { Nuts } & \text { N101 } & \$ 2.44 & 74 & \$ & 180.56 \\ \hline \text { Nuts } & \text { N102 } & \$ 5.44 & 89 & \$ & 484.16 \\ \hline \text { Nuts } & \text { N101 } & \$ 2.44 & 31 & \$ & 75.64 \\ \hline \text { Screws } & \text { S103 } & \$ 9.44 & 59 & \$ & 556.96 \\ \hline \text { Nuts } & \text { N102 } & \$ 5.44 & 89 & \$ & 484.16 \\\hline \text { Screws } & \text { S101 } & \$ 2.44 & 28 & \$ & 68.32 \\ \hline \text { Screws } & \text { S101 } & \$ 20.44 & 80 & \$ & 1,635.20 \\ \hline \text { Nuts } & \text { N102 } & \$ 5.44 & 34 & \$ & 184.96 \\ \hline \text { Nails } & \text { NG101 } & \$ 125.45 & 1 & \$ & 125.45 \\\hline \text { Bolts } & \text { B101 } & \$ 16.44 & 15 & \$ & 246.60 \\ \hline \text { Screws } & \text { S103 } & \$ 9.44 & 27 & \$ & 254.88 \\ \hline \text { Screwdriver } & \text { SD 102 } & \$ 9.44 & 63 & \$ & 594.72 \\ \hline \text { Screwdriver } & \text { SD 101 } & \$ 20.44 & 14 & \$ & 286.16 \\\hline \text { Bolts } & \text { B102 } & \$ 5.44 & 95 & \$ & 516.80 \\ \hline \text { Nuts } & \text { N103 } & \$ 1.74 & 66 & \$ & 114.84 \\ \hline \text { Bolts } & \text { B101 } & \$ 16.44 & 73 & \$ & 1,200.12 \\\hline \text { Screws } & \text { S103 } & \$ 9.44 & 45 & \$ & 424.80 \\ \hline \text { Screws } & \text { S104 } & \$ 15.45 & 86 & \$ & 1,328.70 \\ \hline \text { Screws } & \text { S102 } & \$ 5.44 & 3 & \$ & 16.32 \\ \hline \text { Screws } & \text { S101 } & \$ 20.44 & 6 & \$ & 122.64 \\ \hline \text { Bolts } & \text { B } 102 & \$ 5.44 & 49 & \$ & 266.56 \\\hline \text { Nuts } & \text { N101 } & \$ 2.44 & 65 & \$ & 158.60 \\ \hline \text { Screw driver } & \text { SD 103 } & \$ 5.44 & 95 & \$ & 516.80 \\ \hline \text { Nuts } & \text { N103 } & \$ 1.74 & 52 & \$ & 90.48 \\ \hline \text { Screws } & \text { S103 } & \$ 9.44 & 79 & \$ & 745.76 \\ \hline \text { Nailgun pack } & \text { NG101 } & \$ 125.45 & 4 & \$ & 501.80 \\\hline \text { Bolts } & \text { B102 } & \$ 5.44 & 61 & \$ & 331.84 \\ \hline \text { Bolts } & \text { B103 } & \$ 12.94 & 54 & \$ & 698.76 \\ \hline \text { Bolts } & \text { B104 } & \$ 24.40 & 41 & \$ & 1,000.40 \\ \hline \text { Nails } & \text { NG102 } & \$ 275.45 & 2 & \$ & 550.90 \\ \hline \text { Nuts } & \text { N103 } & \$ 1.74 & 6 & \$ & 10.44 \\\hline \text { Screw driver } & \text { SD } 104 & \$ 2.44 & 75 & \$ & 183.00 \\ \hline \text { Screws } & \text { S101 } & \$ 20.44 & 56 & \$ & 1,144.64 \\ \hline \text { Nuts } & \text { N103 } & \$ 1.74 & 13 & \$ & 22.62 \\ \hline \text { Screws } & \$ 102 & \$ 5.44 & 10 & \$ & 54.40 \\ \hline \end{array}\) $\quad$ \[\begin{array} { | c | l | r | l | l c | } \hline \text { Screws } & \text { S101 } & \$ 20.44 & 93 & \$ & 1,900.92 \\ \hline \text { Screws } & \text { S102 } & \$ 5.44 & 27 & \$ & 146.88 \\ \hline \end{array}\] -Which of the following will give the value for the third quartile?

A) PERCENTILE.INC(array, 0.75) B) QUARTILE.INC(array, 0.75) C) DECILE.INC(array, 0.30) D) QUARTILE.INC(array, 0.25) A) PERCENTILE.INC(array, 0.75) B) QUARTILE.INC(array, 0.75) C) DECILE.INC(array, 0.30) D) QUARTILE.INC(array, 0.25)

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}\) -Which of the following represents the proportion of the total number of observations that fall at or below the upper limit of each group?

A) Percentile B) Pareto chart C) Frequency distribution D) Cumulative relative frequency A) Percentile B) Pareto chart C) Frequency distribution D) Cumulative relative frequency

Use the data given below to answer the following question(s). Following is an extract from the Cost per Order Database of Grogtes LLC. \(\begin{array}{|l|l|c|l|lr|} \hline\text { Item Category } & \text { Item } \mathrm{ID} &{\text { Item Cost }} & \text { Units } & \text { Cost per Order } \\ \hline \text { Nuts } & \text { N101 } & \$ 2.44 & 94 & \$ &229.36\\\hline \text { Screws } & \text { S101 } & \$ 20.44 & 49 & \$ & 1,001.56 \\ \hline \text { Nuts } & \text { N102 } & \$ 5.44 & 35 & \$ & 190.40 \\ \hline \text { Screwdriver } & \text { SD 101 } & \$ 20.44 & 26 & \$ & 531.44 \\ \hline \text { Nuts } & \text { N102 } & \$ 3.44 & 55 & \$ & 189.20 \\\hline \text { Screws } & \text { S102 } & \$ 5.44 & 59 & \$ & 320.96 \\ \hline \text { Nuts } & \text { N101 } & \$ 2.44 & 74 & \$ & 180.56 \\ \hline \text { Nuts } & \text { N102 } & \$ 5.44 & 89 & \$ & 484.16 \\ \hline \text { Nuts } & \text { N101 } & \$ 2.44 & 31 & \$ & 75.64 \\ \hline \text { Screws } & \text { S103 } & \$ 9.44 & 59 & \$ & 556.96 \\ \hline \text { Nuts } & \text { N102 } & \$ 5.44 & 89 & \$ & 484.16 \\\hline \text { Screws } & \text { S101 } & \$ 2.44 & 28 & \$ & 68.32 \\ \hline \text { Screws } & \text { S101 } & \$ 20.44 & 80 & \$ & 1,635.20 \\ \hline \text { Nuts } & \text { N102 } & \$ 5.44 & 34 & \$ & 184.96 \\ \hline \text { Nails } & \text { NG101 } & \$ 125.45 & 1 & \$ & 125.45 \\\hline \text { Bolts } & \text { B101 } & \$ 16.44 & 15 & \$ & 246.60 \\ \hline \text { Screws } & \text { S103 } & \$ 9.44 & 27 & \$ & 254.88 \\ \hline \text { Screwdriver } & \text { SD 102 } & \$ 9.44 & 63 & \$ & 594.72 \\ \hline \text { Screwdriver } & \text { SD 101 } & \$ 20.44 & 14 & \$ & 286.16 \\\hline \text { Bolts } & \text { B102 } & \$ 5.44 & 95 & \$ & 516.80 \\ \hline \text { Nuts } & \text { N103 } & \$ 1.74 & 66 & \$ & 114.84 \\ \hline \text { Bolts } & \text { B101 } & \$ 16.44 & 73 & \$ & 1,200.12 \\\hline \text { Screws } & \text { S103 } & \$ 9.44 & 45 & \$ & 424.80 \\ \hline \text { Screws } & \text { S104 } & \$ 15.45 & 86 & \$ & 1,328.70 \\ \hline \text { Screws } & \text { S102 } & \$ 5.44 & 3 & \$ & 16.32 \\ \hline \text { Screws } & \text { S101 } & \$ 20.44 & 6 & \$ & 122.64 \\ \hline \text { Bolts } & \text { B } 102 & \$ 5.44 & 49 & \$ & 266.56 \\\hline \text { Nuts } & \text { N101 } & \$ 2.44 & 65 & \$ & 158.60 \\ \hline \text { Screw driver } & \text { SD 103 } & \$ 5.44 & 95 & \$ & 516.80 \\ \hline \text { Nuts } & \text { N103 } & \$ 1.74 & 52 & \$ & 90.48 \\ \hline \text { Screws } & \text { S103 } & \$ 9.44 & 79 & \$ & 745.76 \\ \hline \text { Nailgun pack } & \text { NG101 } & \$ 125.45 & 4 & \$ & 501.80 \\\hline \text { Bolts } & \text { B102 } & \$ 5.44 & 61 & \$ & 331.84 \\ \hline \text { Bolts } & \text { B103 } & \$ 12.94 & 54 & \$ & 698.76 \\ \hline \text { Bolts } & \text { B104 } & \$ 24.40 & 41 & \$ & 1,000.40 \\ \hline \text { Nails } & \text { NG102 } & \$ 275.45 & 2 & \$ & 550.90 \\ \hline \text { Nuts } & \text { N103 } & \$ 1.74 & 6 & \$ & 10.44 \\\hline \text { Screw driver } & \text { SD } 104 & \$ 2.44 & 75 & \$ & 183.00 \\ \hline \text { Screws } & \text { S101 } & \$ 20.44 & 56 & \$ & 1,144.64 \\ \hline \text { Nuts } & \text { N103 } & \$ 1.74 & 13 & \$ & 22.62 \\ \hline \text { Screws } & \$ 102 & \$ 5.44 & 10 & \$ & 54.40 \\ \hline \end{array}\) $\quad$ \[\begin{array} { | c | l | r | l | l c | } \hline \text { Screws } & \text { S101 } & \$ 20.44 & 93 & \$ & 1,900.92 \\ \hline \text { Screws } & \text { S102 } & \$ 5.44 & 27 & \$ & 146.88 \\ \hline \end{array}\] -Which of the following does the second quartile of the costs per order indicate?

A) 2% of the costs per order are less than or equal to $114.84. B) 20% of the costs per order are less than or equal to $1,200.12. C) 5% of the costs per order are less than or equal to $229.36. D) 50% of the costs per order are less than or equal to $286.16. A) 2% of the costs per order are less than or equal to $114.84. B) 20% of the costs per order are less than or equal to $1,200.12. C) 5% of the costs per order are less than or equal to $229.36. D) 50% of the costs per order are less than or equal to $286.16.

Use the data given below to answer the following question(s). Following is the purchase order database of 'The Chef Says So', a restaurant in New York, over the last quarter (April-June). \(\begin{array}{|l|l|l|l|l|l|} \hline \text { Order Date } & \text { Item } & \text { Region } & \text { Supplier } & \begin{array}{c} \text { Unit } \\ \text { Cost } \end{array} & \text { Units } \\\hline 5 / 6 / 2012 & \text { Steel Fork } & \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 { Steel Fork } & \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 { Steel Fork } & \text { Puitoria } & \text { Audrey } & 5.44 & 78 \\ \hline 6 / 1 / 2012 & \text { Steel Fork } & \text { Puitoria } & \text { Jones } & 8.44 & 93 \\ \hline 4 / 2 / 2012 & \text { Steel Fork } & \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 Bow1 } & \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 { Steel Fork } & \text { Puitoria } & \text { Audrey } & 5.44 & 69 \\ \hline 4 / 12 / 2012 & \text { Silver Spoon } & \text { Antasia } & \text { Henry } & 8.44 & 99 \\ \hline 4 / 18 / 2012 & \text { Steel Fork } & \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 Bow1 } & \text { Puitoria } & \text { Mary } & 15.94 & 58 \\ \hline 5 / 2 / 2012 & \text { Ceramic Bow1 } & \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 \end{array}\) $\quad$ \[\begin{array} { | c | c | l | c | r | r |} \hline 4 / 13 / 2012 & \text { Steel Fork } & \text { Puitoria } & \text { Audrey } & 4.74 & 17 \\ \hline 5 / 3 / 2012 & \text { Cerarnic Plate } & \text { Puitoria } & \text { Jones } & 8.44 & 14 \\ \hline 6 / 3 / 2012 & \text { Cerarnic Plate } & \text { Puitoria } & \text { Jones } & 23.44 & 97 \\ \hline 4 / 17 / 2012 & \text { Cerarnic Plate } & \text { Puitoria } & \text { Audrey } & 8.44 & 31 \\ \hline \end{array}\] -Describe how to sort the data by inventory value to compute cumulative percentage of total inventory value to help the restaurateur conduct a Pareto analysis. (Assume that no damages were caused to the inventory purchased over the three months)

In order to calculate inventory value of

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}\) -A graphical depiction of a frequency distribution for numerical data in the form of a column chart is called a .

A) cartogram B) correlogram C) histogram D) dendogram A) cartogram B) correlogram C) histogram D) dendogram

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}\) -What is the relative frequency of Grade 3 employees?

A) 4 B) 0.55 C) 0.20 D) 5 A) 4 B) 0.55 C) 0.20 D) 5

Use the data given below to answer the following question(s). Following is an extract from the Cost per Order Database of Grogtes LLC. \(\begin{array}{|l|l|c|l|lr|} \hline\text { Item Category } & \text { Item } \mathrm{ID} &{\text { Item Cost }} & \text { Units } & \text { Cost per Order } \\ \hline \text { Nuts } & \text { N101 } & \$ 2.44 & 94 & \$ &229.36\\\hline \text { Screws } & \text { S101 } & \$ 20.44 & 49 & \$ & 1,001.56 \\ \hline \text { Nuts } & \text { N102 } & \$ 5.44 & 35 & \$ & 190.40 \\ \hline \text { Screwdriver } & \text { SD 101 } & \$ 20.44 & 26 & \$ & 531.44 \\ \hline \text { Nuts } & \text { N102 } & \$ 3.44 & 55 & \$ & 189.20 \\\hline \text { Screws } & \text { S102 } & \$ 5.44 & 59 & \$ & 320.96 \\ \hline \text { Nuts } & \text { N101 } & \$ 2.44 & 74 & \$ & 180.56 \\ \hline \text { Nuts } & \text { N102 } & \$ 5.44 & 89 & \$ & 484.16 \\ \hline \text { Nuts } & \text { N101 } & \$ 2.44 & 31 & \$ & 75.64 \\ \hline \text { Screws } & \text { S103 } & \$ 9.44 & 59 & \$ & 556.96 \\ \hline \text { Nuts } & \text { N102 } & \$ 5.44 & 89 & \$ & 484.16 \\\hline \text { Screws } & \text { S101 } & \$ 2.44 & 28 & \$ & 68.32 \\ \hline \text { Screws } & \text { S101 } & \$ 20.44 & 80 & \$ & 1,635.20 \\ \hline \text { Nuts } & \text { N102 } & \$ 5.44 & 34 & \$ & 184.96 \\ \hline \text { Nails } & \text { NG101 } & \$ 125.45 & 1 & \$ & 125.45 \\\hline \text { Bolts } & \text { B101 } & \$ 16.44 & 15 & \$ & 246.60 \\ \hline \text { Screws } & \text { S103 } & \$ 9.44 & 27 & \$ & 254.88 \\ \hline \text { Screwdriver } & \text { SD 102 } & \$ 9.44 & 63 & \$ & 594.72 \\ \hline \text { Screwdriver } & \text { SD 101 } & \$ 20.44 & 14 & \$ & 286.16 \\\hline \text { Bolts } & \text { B102 } & \$ 5.44 & 95 & \$ & 516.80 \\ \hline \text { Nuts } & \text { N103 } & \$ 1.74 & 66 & \$ & 114.84 \\ \hline \text { Bolts } & \text { B101 } & \$ 16.44 & 73 & \$ & 1,200.12 \\\hline \text { Screws } & \text { S103 } & \$ 9.44 & 45 & \$ & 424.80 \\ \hline \text { Screws } & \text { S104 } & \$ 15.45 & 86 & \$ & 1,328.70 \\ \hline \text { Screws } & \text { S102 } & \$ 5.44 & 3 & \$ & 16.32 \\ \hline \text { Screws } & \text { S101 } & \$ 20.44 & 6 & \$ & 122.64 \\ \hline \text { Bolts } & \text { B } 102 & \$ 5.44 & 49 & \$ & 266.56 \\\hline \text { Nuts } & \text { N101 } & \$ 2.44 & 65 & \$ & 158.60 \\ \hline \text { Screw driver } & \text { SD 103 } & \$ 5.44 & 95 & \$ & 516.80 \\ \hline \text { Nuts } & \text { N103 } & \$ 1.74 & 52 & \$ & 90.48 \\ \hline \text { Screws } & \text { S103 } & \$ 9.44 & 79 & \$ & 745.76 \\ \hline \text { Nailgun pack } & \text { NG101 } & \$ 125.45 & 4 & \$ & 501.80 \\\hline \text { Bolts } & \text { B102 } & \$ 5.44 & 61 & \$ & 331.84 \\ \hline \text { Bolts } & \text { B103 } & \$ 12.94 & 54 & \$ & 698.76 \\ \hline \text { Bolts } & \text { B104 } & \$ 24.40 & 41 & \$ & 1,000.40 \\ \hline \text { Nails } & \text { NG102 } & \$ 275.45 & 2 & \$ & 550.90 \\ \hline \text { Nuts } & \text { N103 } & \$ 1.74 & 6 & \$ & 10.44 \\\hline \text { Screw driver } & \text { SD } 104 & \$ 2.44 & 75 & \$ & 183.00 \\ \hline \text { Screws } & \text { S101 } & \$ 20.44 & 56 & \$ & 1,144.64 \\ \hline \text { Nuts } & \text { N103 } & \$ 1.74 & 13 & \$ & 22.62 \\ \hline \text { Screws } & \$ 102 & \$ 5.44 & 10 & \$ & 54.40 \\ \hline \end{array}\) $\quad$ \[\begin{array} { | c | l | r | l | l c | } \hline \text { Screws } & \text { S101 } & \$ 20.44 & 93 & \$ & 1,900.92 \\ \hline \text { Screws } & \text { S102 } & \$ 5.44 & 27 & \$ & 146.88 \\ \hline \end{array}\] -Which of the following is true about quartiles?

A) The 25th percentile is called the fourth quartile. B) One-fourth of the data fall below the fourth quartile. C) Three-fourths of the data are below the third quartile. D) The 50th quartile is the third percentile. A) The 25th percentile is called the fourth quartile. B) One-fourth of the data fall below the fourth quartile. C) Three-fourths of the data are below the third quartile. D) The 50th quartile is the third percentile.

Use the data given below to answer the following question(s). Following is an extract from the Cost per Order Database of Grogtes LLC. \(\begin{array}{|l|l|c|l|lr|} \hline\text { Item Category } & \text { Item } \mathrm{ID} &{\text { Item Cost }} & \text { Units } & \text { Cost per Order } \\ \hline \text { Nuts } & \text { N101 } & \$ 2.44 & 94 & \$ &229.36\\\hline \text { Screws } & \text { S101 } & \$ 20.44 & 49 & \$ & 1,001.56 \\ \hline \text { Nuts } & \text { N102 } & \$ 5.44 & 35 & \$ & 190.40 \\ \hline \text { Screwdriver } & \text { SD 101 } & \$ 20.44 & 26 & \$ & 531.44 \\ \hline \text { Nuts } & \text { N102 } & \$ 3.44 & 55 & \$ & 189.20 \\\hline \text { Screws } & \text { S102 } & \$ 5.44 & 59 & \$ & 320.96 \\ \hline \text { Nuts } & \text { N101 } & \$ 2.44 & 74 & \$ & 180.56 \\ \hline \text { Nuts } & \text { N102 } & \$ 5.44 & 89 & \$ & 484.16 \\ \hline \text { Nuts } & \text { N101 } & \$ 2.44 & 31 & \$ & 75.64 \\ \hline \text { Screws } & \text { S103 } & \$ 9.44 & 59 & \$ & 556.96 \\ \hline \text { Nuts } & \text { N102 } & \$ 5.44 & 89 & \$ & 484.16 \\\hline \text { Screws } & \text { S101 } & \$ 2.44 & 28 & \$ & 68.32 \\ \hline \text { Screws } & \text { S101 } & \$ 20.44 & 80 & \$ & 1,635.20 \\ \hline \text { Nuts } & \text { N102 } & \$ 5.44 & 34 & \$ & 184.96 \\ \hline \text { Nails } & \text { NG101 } & \$ 125.45 & 1 & \$ & 125.45 \\\hline \text { Bolts } & \text { B101 } & \$ 16.44 & 15 & \$ & 246.60 \\ \hline \text { Screws } & \text { S103 } & \$ 9.44 & 27 & \$ & 254.88 \\ \hline \text { Screwdriver } & \text { SD 102 } & \$ 9.44 & 63 & \$ & 594.72 \\ \hline \text { Screwdriver } & \text { SD 101 } & \$ 20.44 & 14 & \$ & 286.16 \\\hline \text { Bolts } & \text { B102 } & \$ 5.44 & 95 & \$ & 516.80 \\ \hline \text { Nuts } & \text { N103 } & \$ 1.74 & 66 & \$ & 114.84 \\ \hline \text { Bolts } & \text { B101 } & \$ 16.44 & 73 & \$ & 1,200.12 \\\hline \text { Screws } & \text { S103 } & \$ 9.44 & 45 & \$ & 424.80 \\ \hline \text { Screws } & \text { S104 } & \$ 15.45 & 86 & \$ & 1,328.70 \\ \hline \text { Screws } & \text { S102 } & \$ 5.44 & 3 & \$ & 16.32 \\ \hline \text { Screws } & \text { S101 } & \$ 20.44 & 6 & \$ & 122.64 \\ \hline \text { Bolts } & \text { B } 102 & \$ 5.44 & 49 & \$ & 266.56 \\\hline \text { Nuts } & \text { N101 } & \$ 2.44 & 65 & \$ & 158.60 \\ \hline \text { Screw driver } & \text { SD 103 } & \$ 5.44 & 95 & \$ & 516.80 \\ \hline \text { Nuts } & \text { N103 } & \$ 1.74 & 52 & \$ & 90.48 \\ \hline \text { Screws } & \text { S103 } & \$ 9.44 & 79 & \$ & 745.76 \\ \hline \text { Nailgun pack } & \text { NG101 } & \$ 125.45 & 4 & \$ & 501.80 \\\hline \text { Bolts } & \text { B102 } & \$ 5.44 & 61 & \$ & 331.84 \\ \hline \text { Bolts } & \text { B103 } & \$ 12.94 & 54 & \$ & 698.76 \\ \hline \text { Bolts } & \text { B104 } & \$ 24.40 & 41 & \$ & 1,000.40 \\ \hline \text { Nails } & \text { NG102 } & \$ 275.45 & 2 & \$ & 550.90 \\ \hline \text { Nuts } & \text { N103 } & \$ 1.74 & 6 & \$ & 10.44 \\\hline \text { Screw driver } & \text { SD } 104 & \$ 2.44 & 75 & \$ & 183.00 \\ \hline \text { Screws } & \text { S101 } & \$ 20.44 & 56 & \$ & 1,144.64 \\ \hline \text { Nuts } & \text { N103 } & \$ 1.74 & 13 & \$ & 22.62 \\ \hline \text { Screws } & \$ 102 & \$ 5.44 & 10 & \$ & 54.40 \\ \hline \end{array}\) $\quad$ \[\begin{array} { | c | l | r | l | l c | } \hline \text { Screws } & \text { S101 } & \$ 20.44 & 93 & \$ & 1,900.92 \\ \hline \text { Screws } & \text { S102 } & \$ 5.44 & 27 & \$ & 146.88 \\ \hline \end{array}\] -Which of the following is true about constructing PivotTables?

A) It is not possible to construct the PivotTable in the same worksheet. B) Dragging a field into the Report Filter area allows addition of a third dimension to the analysis. C) Placing a field each in the row and column labels will automatically sum the variable values in the table. D) PivotTables cannot be duplicated by copying and pasting an existing table. A) It is not possible to construct the PivotTable in the same worksheet. B) Dragging a field into the Report Filter area allows addition of a third dimension to the analysis. C) Placing a field each in the row and column labels will automatically sum the variable values in the table. D) PivotTables cannot be duplicated by copying and pasting an existing table.