Exam 3: Visualizing and Exploring Data

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. -To construct a frequency distribution for categorical data, the

(Multiple Choice)

4.9/5

(79)

Question 21

Use the data given below to answer the following question(s). Following is an extract from the Cost per Order Database of Grogtes LLC. -Which of the following observations is closest to the 87th percentile of costs per order?

(Multiple Choice)

4.9/5

(80)

Question 22

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

(Multiple Choice)

4.7/5

(77)

Question 23

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). -Elaborate on the use of geographic data mapping in business analytics.

(Essay)

4.7/5

(76)

Question 24

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.

(Essay)

4.8/5

(83)

Question 25

Use the data given below to answer the following question(s). Following is an extract from the Employee Payroll Database of HFR Informatics Inc. -What is the relative frequency of Grade 3 employees?

(Multiple Choice)

4.8/5

(77)

Question 26

Use the data given below to answer the following question(s). Following is an extract from the Employee Payroll Database of HFR Informatics Inc. -What is the relative frequency of Female employees?

(Multiple Choice)

5.0/5

(83)

Question 27

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.

(Essay)

4.8/5

(84)

Question 28

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

(Multiple Choice)

4.8/5

(77)

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. -Which of the following is true about cross-tabulation?

(Multiple Choice)

4.8/5

(90)

Question 30

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. -Use Excel to calculate the total $ amount of sales made to Quintasia.Include the sale of fur, jute, and leather.

(Multiple Choice)

4.9/5

(66)

Question 31

Use the data given below to answer the following question(s). Following is an extract from the Cost per Order Database of Grogtes LLC. -After choosing the PivotTable, the PivotChart can be found on the ________ tab.

(Multiple Choice)

4.9/5

(61)

Question 32

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). -Fewer groups provide a "coarse" histogram.

(True/False)

4.8/5

(81)

Question 33

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

(Multiple Choice)

4.8/5

(73)

Question 34

Which of the following charts shows three-dimensional data?

(Multiple Choice)

4.9/5

(78)

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

(Multiple Choice)

4.8/5

(78)

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). $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 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 cylindrical chart. Counts: \begin{array}{r|r|r|r} \text { Region } & \begin{array}{r} \text { Glass } \\ \text { Bottle } \end{array} & \begin{array}{r} \text { Silver } \\ \text { Spoon } \end{array} & \begin{array}{r} \text { Grand } \\ \text { Total } \end{array} \\ \hline \text { Almeco } & 6 & 79 & 85 \\ \hline \text { Antasia } & 0 & 184 & 184 \\ \hline \text { Puitoria } & 13 & 30 & 43 \end{array} Percentages by Region: \begin{array}{|r|r|r|r} \text { Region } & \begin{array}{r} \text { Glass } \\ \text { Bottle } \end{array} & \begin{array}{r} \text { Silver } \\ \text { Spoon } \end{array} & \begin{array}{r} \text { Grand } \\ \text { Total } \end{array} \\ \hline \text { Almeco } & 7 \% & 93 \% & 100 \% \\ \hline \text { Antasia } & 0 \% & 100 \% & 100 \% \\ \hline \text { Puitoria } & 30 \% & 70 \% & 100 \% \end{array}$ -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 cylindrical chart. Counts: Region Glass Bottle Silver Spoon Grand Total Almeco 6 79 85 Antasia 0 184 184 Puitoria 13 30 43 Percentages by Region: Region Glass Bottle Silver Spoon Grand Total Almeco 7\% 93\% 100\% Antasia 0\% 100\% 100\% Puitoria 30\% 70\% 100\%

(Essay)

4.8/5

(83)

Question 37

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

(Multiple Choice)

4.9/5

(72)

Question 38

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). -Explain with an example the filtering tool provided by Excel for simple criteria.

(Essay)

4.9/5

(83)

Question 39

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). -How does Excel distinguish between vertical and horizontal bar charts?

(Essay)

4.8/5

(97)

Question 40

Showing 21 - 40 of 50

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. -To construct a frequency distribution for categorical data, the

Use the data given below to answer the following question(s). Following is an extract from the Cost per Order Database of Grogtes LLC. -Which of the following observations is closest to the 87th percentile of costs per order?

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

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). -Elaborate on the use of geographic data mapping in business analytics.

Use the data given below to answer the following question(s). Following is an extract from the Employee Payroll Database of HFR Informatics Inc. -What is the relative frequency of Grade 3 employees?

Use the data given below to answer the following question(s). Following is an extract from the Employee Payroll Database of HFR Informatics Inc. -What is the relative frequency of Female employees?

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

Use the data given below to answer the following question(s). Following is an extract from the Cost per Order Database of Grogtes LLC. -Which of the following is true about cross-tabulation?

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. -Use Excel to calculate the total $ amount of sales made to Quintasia.Include the sale of fur, jute, and leather.

Use the data given below to answer the following question(s). Following is an extract from the Cost per Order Database of Grogtes LLC. -After choosing the PivotTable, the PivotChart can be found on the ________ tab.

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). -Fewer groups provide a "coarse" histogram.

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

Which of the following charts shows three-dimensional data?

Use the data given below to answer the following question(s). Following is an extract from the Cost per Order Database of Grogtes LLC. -Which of the following does the second quartile of the costs per order indicate?

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

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). -Explain with an example the filtering tool provided by Excel for simple criteria.

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). -How does Excel distinguish between vertical and horizontal bar charts?

Introduction to Business Analytics

Analytics on Spreadsheets

Descriptive Statistical Measures

Probability Distributions and Data Modeling

Sampling and Estimation

Statistical Inference

Predictive Modeling and Analysis

Regression Analysis

Forecasting Techniques

Simulation and Risk Analysis

Introduction to Data Mining

Linear Optimization

Applications of Linear Optimization

Integer Optimization

Nonlinear and Non-Smooth Optimization

Optimization Models with Uncertainty

Decision Analysis

Filters