Question 1

Explain statistics as defined by David Hand. What are the two ways in which Microsoft Excel supports statistical analysis?

Accepted Answer

Statistics, as defined by David Hand, is both the science of uncertainty and the technology of extracting information from data. Statistics involves collecting, organizing, analyzing, interpreting, and presenting data. A statistic is a summary measure of data. Microsoft Excel supports statistical analysis in two ways:
• with statistical functions that are entered in worksheet cells directly, or embedded in formulas
• with the Excel Analysis Toolpak add-in to perform more complex statistical computations.

Question 2

Observations consisting of pairs of variable data are required to construct a chart.

Accepted Answer

A)  doughnut 
B)  scatter 
C)  radar 
D)  line 
A)  doughnut 
B)  scatter 
C)  radar 
D)  line B

Question 3

Roger wants to compare values across categories using vertical rectangles. Which of the following charts must Roger use?

Accepted Answer

A)  Line chart 
B)  Clustered column chart 
C)  Pie chart 
D)  Stacked column chart 
A)  Line chart 
B)  Clustered column chart 
C)  Pie chart 
D)  Stacked column chart B

Question 4

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 and construct a line chart exhibiting the purchase order of ceramic plates over the three months.

Accepted Answer

Filter the data set by Item (Ceramic Pla

Question 5

Construct a PivotChart to visualize the purchase order total units for steel forks and ceramic bowls within each region.

Accepted Answer

Choose the whole range of data

Question 6

Which of the following relies on sorting data and calculating the cumulative percentage of the characteristic of interest?

Accepted Answer

A)  Randolph diagram 
B)  Anscombe's quartet 
C)  Bland-Altman plot 
D)  Pareto analysis 
A)  Randolph diagram 
B)  Anscombe's quartet 
C)  Bland-Altman plot 
D)  Pareto analysis

Question 7

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 observations is closest to the third quartile?

Accepted Answer

A)  35 N102 nuts for $190.40 
B)  59 S103 screws for $556.96 
C)  13 N103 nuts for $22.62 
D)  2 NG102 nailgun packs for $550.90 
A)  35 N102 nuts for $190.40 
B)  59 S103 screws for $556.96 
C)  13 N103 nuts for $22.62 
D)  2 NG102 nailgun packs for $550.90

Question 8

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 cumulative relative frequency of Ranks 1 and 2?

Accepted Answer

A)  0.80 
B)  0.15 
C)  0.30 
D)  0.25 
A)  0.80 
B)  0.15 
C)  0.30 
D)  0.25

Question 9

When constructing frequency distributions for numerical data, SUMIF is used to count the frequencies of each discrete value.

Accepted Answer

A) True 
 B)False

Question 10

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 38th percentile of the costs per order indicate?

Accepted Answer

A)  62% of the costs per order are more than or equal to $190.40. 
B)  38% of the costs per order are less than or equal to $189.20. 
C)  62% of the costs per order are less than or equal to $484.16. 
D)  38% of the costs per order are more than or equal to $501.80. 
A)  62% of the costs per order are more than or equal to $190.40. 
B)  38% of the costs per order are less than or equal to $189.20. 
C)  62% of the costs per order are less than or equal to $484.16. 
D)  38% of the costs per order are more than or equal to $501.80.

Question 11

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}$$
-What is the rank of the 42nd percentile of the costs per order ?

Accepted Answer

A)  17 
B)  13.35 
C)  19 
D)  33.75 
A)  17 
B)  13.35 
C)  19 
D)  33.75

Question 12

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.

Accepted Answer

A)  PERCENTILE.INC(array, k) 
B)  PERCENTILE(array + k) 
C)  PERCENTILE.IF(array, k) 
D)  PERCENTILE(SUM(array), k) 
A)  PERCENTILE.INC(array, k) 
B)  PERCENTILE(array + k) 
C)  PERCENTILE.IF(array, k) 
D)  PERCENTILE(SUM(array), k)

Question 13

The sort buttons in Excel can be found under:

Accepted Answer

A)  the Data tab in the Sort & Filter group. 
B)  the Home tab in the Styles group. 
C)  the Insert tab in the Sort group. 
D)  the Sort tab in the Filter group. 
A)  the Data tab in the Sort & Filter group. 
B)  the Home tab in the Styles group. 
C)  the Insert tab in the Sort group. 
D)  the Sort tab in the Filter group.

Question 14

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 cross-tabulation?

Accepted Answer

A)  All subcategories together must constitute the complete data set. 
B)  A cross-tabulation table is often called a latent class model. 
C)  Each observation can be classified into many subcategories. 
D)  The table displays the number of categorical variables between two observations. 
A)  All subcategories together must constitute the complete data set. 
B)  A cross-tabulation table is often called a latent class model. 
C)  Each observation can be classified into many subcategories. 
D)  The table displays the number of categorical variables between two observations.

Question 15

Changes to the type of chart, data included in the chart, and chart layout and styles can be made from the Layout tab.

Accepted Answer

A) True 
 B)False

Question 16

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 of sales made to Quintasia. Include the sale of fur, jute, and leather.

Accepted Answer

A)  $193 
B)  $4185.47 
C)  $25250.19 
D)  $130.83 
A)  $193 
B)  $4185.47 
C)  $25250.19 
D)  $130.83

Question 17

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 identify the buyer who made the highest single purchase of cotton (in terms of sales revenue for Pointler's Inc.) in Quintasia.

Accepted Answer

A)  Peter 
B)  Henry 
C)  Philip 
D)  Simson 
A)  Peter 
B)  Henry 
C)  Philip 
D)  Simson

Question 18

Elaborate on the use of geographic data mapping in business analytics.

Accepted Answer

Many applications of business analytics

Question 19

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}\)
-While constructing a histogram, how is group width calculated?

Accepted Answer

A)  number of groups × (lower limit of the last group + upper limit of the first group) 
B)  (upper limit of the last group - lower limit of the first group) / number of groups 
C)  (upper limit of the first group + number of groups) × lower limit of the last group + number of groups) 
D)  (lower limit of the first group - number of groups) × upper limit of the last group 
A)  number of groups × (lower limit of the last group + upper limit of the first group) 
B)  (upper limit of the last group - lower limit of the first group) / number of groups 
C)  (upper limit of the first group + number of groups) × lower limit of the last group + number of groups) 
D)  (lower limit of the first group - number of groups) × upper limit of the last group

Question 20

AutoFilter creates filtering criteria based on the type of data being filtered.

Accepted Answer

A) True 
 B)False

Explain statistics as defined by David Hand. What are the two ways in which Microsoft Excel supports statistical analysis?

Observations consisting of pairs of variable data are required to construct a chart.

Roger wants to compare values across categories using vertical rectangles. Which of the following charts must Roger use?

Construct a PivotChart to visualize the purchase order total units for steel forks and ceramic bowls within each region.

Which of the following relies on sorting data and calculating the cumulative percentage of the characteristic of interest?

When constructing frequency distributions for numerical data, SUMIF is used to count the frequencies of each discrete value.

The sort buttons in Excel can be found under:

Changes to the type of chart, data included in the chart, and chart layout and styles can be made from the Layout tab.

Elaborate on the use of geographic data mapping in business analytics.

AutoFilter creates filtering criteria based on the type of data being filtered.

Business Analytics

Analytics on Spreadsheets

Descriptive Statistical Measures

Probability Distributions and Data Modeling

Sampling and Estimation

Statistical Inference

Trendlines and Regression Analysis

Forecasting Techniques

Introduction to Data Mining

Spreadsheet Modeling and Analysis

Monte Carlo Simulation and Risk Analysis

Linear Optimization

Applications of Linear Optimization

Integer Optimization

Decision Analysis

Filters

Exam 3: Visualizing and Exploring Data

Explain statistics as defined by David Hand. What are the two ways in which Microsoft Excel supports statistical analysis?

Observations consisting of pairs of variable data are required to construct a chart.

Roger wants to compare values across categories using vertical rectangles. Which of the following charts must Roger use?

Construct a PivotChart to visualize the purchase order total units for steel forks and ceramic bowls within each region.

Which of the following relies on sorting data and calculating the cumulative percentage of the characteristic of interest?

When constructing frequency distributions for numerical data, SUMIF is used to count the frequencies of each discrete value.

The sort buttons in Excel can be found under:

Changes to the type of chart, data included in the chart, and chart layout and styles can be made from the Layout tab.

Elaborate on the use of geographic data mapping in business analytics.

AutoFilter creates filtering criteria based on the type of data being filtered.

Business Analytics

Analytics on Spreadsheets

Descriptive Statistical Measures

Probability Distributions and Data Modeling

Sampling and Estimation

Statistical Inference

Trendlines and Regression Analysis

Forecasting Techniques

Introduction to Data Mining

Spreadsheet Modeling and Analysis

Monte Carlo Simulation and Risk Analysis

Linear Optimization

Applications of Linear Optimization

Integer Optimization

Decision Analysis

Filters