Deck 3: Visualizing and Exploring Data

Question 1

Philip wishes to understand the relative proportion of each data source to the total. Which of the following charts must Philip use?

A) Pie chart
B) Bar chart
C) Scatter chart
D) Column chart

Answer 1

A

Question 2

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

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

Answer 2

D

Question 3

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}$

-If a data set has 'c' number of observations, the relative frequency of category 'l' is computed as .

A) (frequency of category 'l') / 'c'
B) 'c' × (number of observations in category 'l')
C) (sum of all observations in category 'l') / 'c'
D) sum of ('c' + each observation in category 'l')

Answer 3

(frequency of category 'l') / 'c'

Question 4

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

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

Question 5

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.

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

Question 6

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?

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

Question 7

To select a chart type in Excel from the Charts group, which tab has to be accessed?

A) Design tab
B) Layout tab
C) Insert tab
D) Format tab

Question 8

Which of the following charts shows three-dimensional data?

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

Question 9

Which of the following charts allows plotting of multiple dimensions of several data series?

A) Doughnut chart
B) Bubble chart
C) Radar chart
D) Area chart

Question 10

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

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

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?

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 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 employees on a 'A to D' pay scale?

A) 1.00
B) 0.80
C) 0.30
D) 0.60

Question 13

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:

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

Question 14

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

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

Question 15

The sort buttons in Excel can be found under:

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 16

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 Female employees?

A) 0.65
B) 0.75
C) 0.25
D) 0.35

Question 17

Peige, a stock broker, has data consisting of price, price/earnings ratio, and market capitalization for seven different stocks on one particular day. She wishes to plot these three variables in two dimensions. Which of the following charts must Peige use?

A) Stock chart
B) Surface chart
C) Bubble chart
D) Line chart

Question 18

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.

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

Question 19

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}$

-To construct a frequency distribution for categorical data, the

A) observations that appear in each category must be summed up.
B) number of observations that appear in each category must be counted.
C) observations in each category must be multiplied by observations in the corresponding category.
D) number of observations in each category must be divided by the total number of observations in all categories.

Question 20

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

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

Question 21

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

Question 22

Use the data given below to answer the following question(s).
Following is an extract from the Employee Payroll Database of HFR Informatics Inc. $\begin{array}{|l|l|l|l|c|}\hline\text { Employee } & \text { Ethnic Group } & \text { Gender } & \begin{array}{c}\text { Rank / } \\\text { Grade }\end{array} & \begin{array}{c}\text { Pay } \\\text { Scale }\end{array} \\\hline \text { Maria } & \text { Asian American } & \text { Female } & 3 & \text { A } \\\hline \text { Peter } & \text { White American } & \text { Male } & 2 & \text { B } \\\hline \text { George } & \text { Hispanic } & \text { Male } & 1 & \text { C } \\&\text { American }\\\hline \text { Smith } & \text { Black American } & \text { Female } & 1 & \text { D } \\\hline \text { Johnson } & \text { Alaska Native } & \text { Male } & 2 & \text { E } \\\hline \text { Thompson } & \text { Asian American } & \text { Male } & 2 & \text { B } \\\hline \text { Martinez } & \text { Alaska Native } & \text { Male } & 3 & \text { A } \\\hline \text { Lewis } & \text { White American } & \text { Female } & 2 & \text { B } \\\hline \text { Lee } & \text { Black American } & \text { Male } & 2 & \text { A } \\\hline \text { Taylor } & \text { Asian American } & \text { Female } & 1 & \text { B } \\\hline \text { Carter } & \text { Asian American } & \text { Male } & 2 & \text { C } \\\hline \text { Edwards } & \text { Hispanic } & \text { Male } & 2 & \text { E } \\&\text { American }\\\hline \text { Bailey } & \text { White American } & \text { Male } & 2 & \text { B } \\\hline \text { Cooper } & \text { White American } & \text { Male } & 2 & \text { A } \\\hline \text { Bill } & \text { Alaska Native } & \text { Male } & 3 & \text { E } \\\hline \text { Cox } & \text { Asian American } & \text { Male } & 1 & \text { A } \\\hline \text { Perry } & \text { Hispanic } & \text { Female } & 2 & \text { C } \\&\text { American }\\\hline \text { Flores } & \text { Alaska Native } & \text { Female } & 2 & \text { B } \\\hline \text { Woods } & \text { White American } & \text { Male } & 3 & \text { E } \\\hline \text { Cole } & \text { Asian American } & \text { Female } & 1 & \text { A } \\\hline\end{array}$

-The Excel 2010 function computes the kth percentile of data in the range specified in the array field, where k is in the range 0 to 1, inclusive.

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

Question 23

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 can be used to quickly create cross-tabulations?

A) Frequency distribution
B) COUNTIF function
C) PivotTable
D) Sort & Filter

Question 24

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

Question 25

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: Percentages by Region:

Question 26

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 ?

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

Question 27

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.

Question 28

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.

Question 29

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.

Question 30

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

Question 31

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

Question 32

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?

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 33

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

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

Question 34

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 87th percentile of costs per order?

A) 75 SD104 screwdrivers for $183.00
B) 66 N103 nuts for $114.84
C) 73 B101 bolts for $1,200.12
D) 49 S101 screws for $1,001.56

Question 35

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?

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 36

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).
Construct a relative frequency distribution for items in the purchase order database and show the proportions of the frequencies visually using a pie chart.

Question 37

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?

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 38

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?

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 39

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)

Question 40

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).
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)

Question 41

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

Question 42

Fewer groups provide a "coarser" histogram.

Question 43

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

Question 44

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

Question 45

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

Question 46

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

Question 47

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

Question 48

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

Question 49

Explain with an example the filtering tool provided by Excel for simple criteria.

Question 50

How does Excel distinguish between vertical and horizontal bar charts?