Exam 3: Visualizing and Exploring Data

Use the data given below to answer the following question(s). Following is an extract from the Employee Payroll Database of HFR Informatics Inc. -A graphical depiction of a frequency distribution for numerical data in the form of a column chart is called a ________.

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 quartiles?

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

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. -If a data set has 'c' number of observations, the relative frequency of category 'l' is computed as ________.

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

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

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 PivotChart to visualize the purchase order total units for steel forks and ceramic bowls within each region.

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)

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 is a frequency distribution calculated for categorical and numerical data?

Use the data given below to answer the following question(s). Following is an extract from the Employee Payroll Database of HFR Informatics Inc. -The Excel 2010 function ________ computes the kᵗʰ percentile of data in the range specified in the array field, where k is in the range 0 to 1, inclusive.