Exam 14: Business Analytics

SCENARIO 14-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 ecommerce sales last year for North America, Asia Pacific, Western Europe, Central & Eastern Europe, Latin America, and Middle East & Africa. -Referring to SCENARIO 14-2, the North America region has the fastest growth in business-to-consumer ecommerce sales last year.

SMED establishes ways to eliminate unnecessary housekeeping aspects of a work environment.

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

Which of the following situations suggests a process that appears to be operating in a state of statistical control?

SCENARIO 15-8 Recently, a university switched to a new type of computer-based registration.The registrar is concerned with the amount of time (hours) students are spending on the computer registering under the new system.She decides to randomly select 8 students on each of the 12 days of the registration and determine the time each spends on the computer registering.The range, mean, and standard deviation of the times required to register are in the table that follows. 1 10 5.250 3.4949 2 31 15.250 10.3060 3 13 20.375 4.9262 4 21 22.875 8.3911 5 35 8.500 11.3767 6 18 7.875 6.9372 7 25 11.250 8.5815 8 30 7.875 9.5235 9 17 10.250 6.3640 10 22 9.500 7.8740 11 27 7.875 8.7086 12 26 12.875 9.3723 -Referring to SCENARIO 15-8, an R chart is to be constructed for the time required to register.One way to create the lower control limit involves multiplying the mean of the sample ranges byD3.For this data set, the value of D3 is .

SCENARIO 15-5 A manufacturer of computer disks took samples of 240 disks on 15 consecutive days.The number of disks with bad sectors was determined for each of these samples.The results are in the table that follows. \% 1 9 0.037500 2 7 0.029167 3 4 0.016667 4 6 0.025000 5 8 0.033333 6 3 0.012500 7 6 0.025000 8 10 0.041667 9 16 0.066667 10 24 0.100000 11 15 0.062500 12 9 0.037500 13 4 0.016667 14 8 0.033333 15 6 0.025000 -Referring to SCENARIO 15-5, a p control chart is to be made for these data.The upper control limit is _, and the lower control limit is _.

SCENARIO 14-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 ecommerce sales last year for North America, Asia Pacific, Western Europe, Central & Eastern Europe, Latin America, and Middle East & Africa. -Referring to SCENARIO 14-2, the Western Europe region has the largest amount of business-to-consumer ecommerce sales last year.

The Akaike information criteria (AIC) or the corrected Akaike information criteria(AICc) can be used to compare alternative models chosen by the classification tree.

Data mining is used mostly in the mining industry.

SS method focuses on preventing the causes of defects.

The Akaike information criteria (AIC) or the corrected Akaike information criteria(AICc) is a measure of the probability that can be attributed to the response that has occurred.

SCENARIO 14-1 The table below contains the sparklines for the rates of return (in percentage) for three different stocks from 2007 to 2013. -Referring to SCENARIO 14-1, the sparklines enable you to predict that the rates of return of the stock market in 2014 will be higher than in 2013.

Determining the root causes of why defects can occur along with the variables in the process that cause these defects to occur involves which part of the DMAIC process?

Mistake Proofing devices focus on methods that enable participants to reduce setup time for equipment and resources and materials needed for changeover.

SCENARIO 15-3 A quality control analyst for a light bulb manufacturer is concerned that the time it takes to produce a batch of light bulbs is too erratic.Accordingly, the analyst randomly surveys 10 production periods each day for 14 days and records the sample mean and range for each day. 1 58.5 5.1 2 47.6 7.8 3 64.3 6.1 4 60.6 5.7 5 63.7 6.2 6 57.5 6.0 7 55.0 5.4 8 54.9 6.1 9 55.0 5.9 10 62.7 5.0 11 61.9 7.1 12 60.0 6.5 13 58.3 5.9 14 52.0 5.2 -Referring to SCENARIO 15-3, suppose the sample mean and range data were based on 11 observations per day instead of 10.How would this change affect the lower and upper control limits of the R chart?

Which of the following is NOT among the three broad categories of analytic methods?

SCENARIO 15-1 A local newspaper has 10 delivery boys who each deliver the morning paper to 50 customers every day.The owner decides to record the number of papers delivered on time for a 10-day period for one of the delivery boys and construct a p chart to see whether the percentage is too erratic. Day Number of Papers DeliveredonTime 1 46 2 45 3 46 4 45 5 43 6 48 7 46 8 49 9 48 10 47 -Referring to SCENARIO 15-1, what is the numerical value of the lower control limit for the pchart?

SCENARIO 14-1 The table below contains the sparklines for the rates of return (in percentage) for three different stocks from 2007 to 2013. -Referring to SCENARIO 14-1, the sparklines enable you to predict that the rates of return of the stock market in 2014 will be about the same as in 2013.

The control chart

SCENARIO 15-9 The manufacturer of canned food constructed control charts and analyzed several quality characteristics.One characteristic of interest is the weight of the filled cans.The lower specification limit for weight is 2.95 pounds.The table below provides the range and mean of the weights of five cans tested every fifteen minutes during a day's production. Number XBar Range Number XBar Range 1 3.05072 0.0215 16 3.04646 0.073 2 3.01228 0.087 17 3.03868 0.0696 3 3.03558 0.0851 18 3.03338 0.0329 4 3.01014 0.0674 19 3.03322 0.0455 5 3.00858 0.0983 20 3.05078 0.0215 6 3.02704 0.0527 21 3.04808 0.0396 7 3.04268 0.0508 22 3.05348 0.0581 8 3.01052 0.0791 23 3.05516 0.0682 9 3.03464 0.0663 24 3.03426 0.0325 10 3.02034 0.0538 25 3.0516 0.0641 11 3.03764 0.0584 26 3.05562 0.0809 12 3.0409 0.0434 27 3.04402 0.0374 13 3.0519 0.0762 28 3.06458 0.0284 14 3.03994 0.0833 29 3.0544 0.0738 15 3.03788 0.0601 -Referring to SCENARIO 15-9, an R chart is to be constructed for the weight.One way to create the lower control limit involves multiplying the mean of the sample ranges by D3.For this dataset, the value of D3 is .