Question 1

Use the data given below to answer the following question(s).
Following is the Sales database of Pointler's Inc., a manufacturer of clothing material. \(\begin{array}{|l|l|l|l|l|l|}
\hline \begin{array}{l}
\text { Item } \
\text { Type }
\end{array} & \text { Item } \mathrm{ID} & \text { Region } & \text { Buyer } & \begin{array}{l}
\text { Unit } \
\text { Cost } \
(\$)
\end{array} & \text { Units } \\hline \text { Denim } & \text { D101 } & \text { Quintasia } & \text { Peter } & 9.79 & 101 \
\hline \text { Cotton } & \text { C101 } & \text { Prioland } & \text { Kane } & 27.79 & 56 \
\hline \text { Denim } & \text { D102 } & \text { Prioland } & \text { Jones } & 12.79 & 42 \\hline \text { Leather } & \text { L101 } & \text { Prioland } & \text { Gerry } & 27.79 & 33 \
\hline \text { Denim } & \text { D103 } & \text { Dygertia } & \text { Sarah } & 10.79 & 62 \
\hline \text { Cotton } & \text { C102 } & \text { Quintasia } & \text { Peter } & 12.79 & 66 \
\hline \text { Denim } & \text { D101 } & \text { Prioland } & \text { Audrey } & 9.79 & 81 \
\hline \text { Denim } & \text { D102 } & \text { Prioland } & \text { Jones } & 12.79 & 96 \\hline \text { Denim } & \text { D101 } & \text { Dygertia } & \text { Thomas } & 9.79 & 38 \
\hline \text { Cotton } & \text { C103 } & \text { Quintasia } & \text { Peter } & 16.79 & 66 \
\hline \text { Denim } & \text { D102 } & \text { Prioland } & \text { Mary } & 12.79 & 96 \
\hline \text { Cotton } & \text { C105 } & \text { Quintasia } & \text { Henry } & 9.79 & 35 \
\hline \text { Cotton } & \text { C101 } & \text { Quintasia } & \text { Philip } & 27.79 & 87 \
\hline \text { Denim } & \text { D102 } & \text { Quintasia } & \text { Peter } & 12.79 & 41 \\hline \text { Jute } & \text { J101 } & \text { Prioland } & \text { Simson } & 132.8 & \text { 8 } \
\hline \text { Fur } & \text { F101 } & \text { Quintasia } & \text { Peter } & 23.79 & 22 \
\hline \text { Cotton } & \text { C103 } & \text { Prioland } & \text { Mary } & 16.79 & 34 \
\hline \text { Leather } & \text { L102 } & \text { Quintasia } & \text { Peter } & 16.79 & 70 \
\hline \text { Leather } & \text { L101 } & \text { Quintasia } & \text { Philip } & 27.79 & 21 \\hline \text { Fur } & \text { F102 } & \text { Prioland } & \text { Kane } & 12.79 & 102 \
\hline \text { Denim } & \text { D104 } & \text { Prioland } & \text { Simson } & 9.09 & 73 \
\hline \text { Fur } & \text { F101 } & \text { Quintasia } & \text { Philip } & 23.79 & 80 \
\hline \text { Cotton } & \text { C103 } & \text { Prioland } & \text { Gerry } & 16.79 & 52 \
\hline \text { Cotton } & \text { C104 } & \text { Prioland } & \text { Simson } & 22.8 & 93 \
\hline \text { Cotton } & \text { C101 } & \text { Quintasia } & \text { Peter } & 12.79 & 10 \
\hline
\end{array}\)
-Use Excel to calculate the total $ amount earned from sales of all denim items to Prioland

Accepted Answer

A)  $4449.42 
B)  $22213 
C)  $388 
D)  $57.25

Question 2

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.

Accepted Answer

The answer of Use the data given below to answer...

Question 3

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?

Accepted Answer

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

Question 4

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?

Accepted Answer

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

Question 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 does the second quartile of the costs per order indicate?

Accepted Answer

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.

Question 6

Which of the following charts provides a useful means for displaying data over time?

Accepted Answer

A)  Scatter chart 
B)  A doughnut chart 
C)  Pie chart 
D)  Line chart

Question 7

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)

Accepted Answer

The answer of Use the data given below to answer...

Question 8

How does Excel distinguish between vertical and horizontal bar charts?

Accepted Answer

The answer of How does Excel distinguish between vertical and...

Question 9

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 .

Accepted Answer

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

Question 10

Howard has screened some employee details out of the employee database for tax computation purposes. In order to restore the original data file, Howard must:

Accepted Answer

A)  click Sort Newest to Oldest. 
B)  click Clear filter from Item Description. 
C)  click Unmerge cells. 
D)  click Clear outline from Ungroup.

Question 11

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?

Accepted Answer

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

Question 12

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?

Accepted Answer

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.

Question 13

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?

Accepted Answer

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.

Question 14

Not specifying a Bin Range will not allow Excel to automatically determine bin values for the frequency distribution and histogram.

Accepted Answer

A) True 
 B)False

Question 15

How is a frequency distribution calculated for categorical and numerical data?

Accepted Answer

The answer of How is a frequency distribution calculated for...

Question 16

Describe and construct a cross-tabulation showing the region-wise percentage breakdown of purchase of glass bottles and silver spoons and visually represent the data in a 3-D column chart.
Counts: $$\begin{array} { | r | r | r | r | } 
\hline \text { Region } & \begin{array} { r } 
\text { Glass } \
\text { Bottle }
\end{array} & \begin{array} { r } 
\text { Silver } \
\text { Spoon }
\end{array} & \begin{array} { r } 
\text { Grand } \
\text { Total }
\end{array} \
\hline \text { Almeco } & 6 & 79 & 85 \
\hline \text { Antasia } & 0 & 184 & 184 \
\hline \text { Puitoria } & 13 & 30 & 43 \
\hline
\end{array}$$ Percentages by Region: $$\begin{array} { | r | r | r | r | } 
\hline \text { Region } & \begin{array} { r } 
\text { Glass } \
\text { Bottle }
\end{array} & \begin{array} { r } 
\text { Silver } \
\text { Spoon }
\end{array} & \begin{array} { r } 
\text { Grand } \
\text { Total }
\end{array} \
\hline \text { Almeco } & 7 \% & 93 \% & 100 \% \
\hline \text { Antasia } & 0 \% & 100 \% & 100 \% \
\hline \text { Puitoria } & 30 \% & 70 \% & 100 \% \
\hline
\end{array}$$

Accepted Answer

The answer of Describe and construct a cross-tabulation showing the...

Question 17

After choosing the PivotTable, the PivotChart can be found on the tab.

Accepted Answer

A)  Design 
B)  View 
C)  Options 
D)  Layout

Question 18

Which of the following charts shows three-dimensional data?

Accepted Answer

A)  Surface chart 
B)  Column chart 
C)  Stock chart 
D)  Doughnut chart

Question 19

Fewer groups provide a "coarser" histogram.

Accepted Answer