Exam 3: Visualizing and Exploring Data

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?

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

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

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). -AutoFilter creates filtering criteria based on the type of data being filtered.

Use the data given below to answer the following question(s). Following is an extract from the Employee Payroll Database of HFR Informatics Inc. -While constructing a histogram, how is group width calculated?

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 constructing PivotTables?

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 Ranks 1 and 2?

Use the data given below to answer the following question(s). Following is the purchase order database of 'The Chef Says So', a restaurant in New York, over the last quarter (April-June). -Explain statistics as defined by David Hand.What are the two ways in which Microsoft Excel supports statistical analysis?

The sort buttons in Excel can be found under:

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 earned from sales of all denim items to Prioland

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). -Specifying a Bin Range will allow Excel to automatically determine bin values for the frequency distribution and histogram.

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 will give the value for the third quartile?

Use the data given below to answer the following question(s). Following is an extract from the Cost per Order Database of Grogtes LLC. -What is the rank of the 42ⁿᵈ percentile of the costs per order ?

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

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:

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). -Changes to the type of chart, data included in the chart, and chart layout and styles can be made from the Layout tab.

Use the data given below to answer the following question(s). Following is an extract from the Employee Payroll Database of HFR Informatics Inc. -Which of the following represents the proportion of the total number of observations that fall at or below the upper limit of each group?

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

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). -While constructing frequency distributions for numerical data, SUMIF is used to count the frequencies of each discrete value.

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 third quartile?