Exam 17: Business Analytics

You can compute any of the numerical descriptive statistics for the variables of the new worksheet that a drill-down in a PivotTable creates.

SCENARIO 17-3 The tree diagram below shows the results of the classification tree model that has been constructed to predict the probability of a cable company's customers who will switch ("Yes" or "No")into its bundled program offering based on the price ($30, $40, $50, $60)and whether the customer spends more than 5 hours a day watching TV ("Yes" or "No")using the data set of 100 customers collected from a survey. -Referring to Scenario 17-3, what is the highest rate of switching into the bundled offering?

SCENARIO 17-2 The treemap below shows the amounts (size)measured in billions of US dollars and percentage changes from prior year (color)of business-to-consumer e-commerce sales last year for North America, Asia Pacific, Western Europe, Central & Eastern Europe, Latin America, and Middle East & Africa. -Referring to Scenario 17-2, which region has the slowest growth in business-to-consumer ecommerce sales last year?

Treemaps that use color to represent the value of a second variable, thereby increasing the data density of the displays, is an example of chartjunk.

SCENARIO 17-7 The output below shows the results of cluster analysis on the different regions of the world (North America, Asia Pacific, Western Europe, Central & Eastern Europe, Latin America, and Middle East & Africa)based on the amounts (in billions of US dollars)and the percentage changes from prior year of business-to-consumer e-commerce sales last year. -Referring to Scenario 17-7, what are the first group of countries that cluster together?

In multidimensional scaling, the stress statistic is used to measure the goodness of fit of the results to the data.

Which of the following investigates what should occur and suggest the best course of action for the future?

Some business analytics involve starting with many variables, followed by filtering the data by exploring specific combinations of categorical values or numerical range.In Excel, this approach is mimicked by using a drill-down.

Successful implementation of a classification tree requires rules for splitting the data at each node based on an independent variable.

In k-means clustering, observations that are assigned to a cluster may never be reassigned to a different cluster later in the process.

Complete linkage can be used to measure the distance between objects in cluster analysis.

Which of the following is NOT among the predictive analytics methods covered in the book?

SCENARIO 17-2 The treemap below shows the amounts (size)measured in billions of US dollars and percentage changes from prior year (color)of business-to-consumer e-commerce sales last year for North America, Asia Pacific, Western Europe, Central & Eastern Europe, Latin America, and Middle East & Africa. -Referring to Scenario 17-2, the Asia Pacific region has the largest amount of business-to-consumer ecommerce sales last year.

In multidimensional scaling, the general rule is to increase the number of dimensions as long as the stress statistic decreases substantially.

SCENARIO 17-7 The output below shows the results of cluster analysis on the different regions of the world (North America, Asia Pacific, Western Europe, Central & Eastern Europe, Latin America, and Middle East & Africa)based on the amounts (in billions of US dollars)and the percentage changes from prior year of business-to-consumer e-commerce sales last year. -Referring to Scenario 17-7, the "complete" method is used to measure the maximum distance between objects within a cluster.