Search
Info
Warning
Danger

Study Resources (Business Management)

  52. Using the data given, apply hierarchical clustering with 10 clusters using LandValue ($), BuildingValue ($), Acres, Age, and Price ($) as variables. Be sure to Normalize input data in Step 2 of the XLMiner Hierarchical Clustering procedure. Use Ward’s method as the clustering method. a. Use a PivotTable on the data.
0 Views
View Answer
59. The owner of a grocery store is interested in providing better service to his customers with respect to the wait time at the billing counter. The data on 20 waiting customers are given below. Customer Number Wait Time (min) Purchase Amount ($) Customer Age Credit Score 1 2.3 518 42 694 2 2.8 592 33 879 3 3.2 598 38 531 4 3.4 845 40 509 5 3.4 648 29 869 6 4.2 695 46 777 7 3.2 844 42 470 8 1.4 470 40 714 9 6.4 488 24 517 10 7.8 527 37 794 11 6.5 843 52 551 12 9.8 704 43 673 13 5 824 56 846 14 1.8 570 35 735 15 6.1 503 39 816 16 3.4 483 44 516 17 7.8 707 33 729 18 2.8 796 42 591 19 1.2 485 46 866 20 9.5 727 50 879   a. Use XLMiner to create a scatter chart matrix for.
0 Views
View Answer
  48. The contingency table below represents employees of a communications company classified by age and field of expertise. Fill in the missing entries. ?    Under 35  35-44 45+ Total  Engineering  7,635  7,875  6,429  21,939  Business  13,195      38,814  Education  4,802  5,143      Liberal Arts  10,377  10,440  11,010 31,827  Total  36,009    37,313  110,405 ?       .
0 Views
View Answer
  48. Using the data given, apply hierarchical clustering with 5 clusters using Wait Time (min), Purchase Amount ($), Customer Age, and Customer Satisfaction Rating as variables. Be sure to Normalize input data in Step 2 of the XLMiner Hierarchical Clustering procedure. Use Ward’s method as the clustering method. a. Use a PivotTable on the.
0 Views
View Answer
53. Consider the following survey results regarding marital status by age. Age Category Never Married (%) Married (%) Divorced (%) 18-24 49 35 16 25-34 44 35 21 35-44 28 45 27 45-54 22 58 20   a. Construct a stacked-column chart to display the survey data on marital status. Use Age Category as the variable on the horizontal axis.b. Construct a clustered-column chart to display the survey data. Use Age Category as.
0 Views
View Answer
  52. A research was conducted on a sample of 1000 males and 1000 females to study the kind of movie most men and women prefer to watch. The results are shown in the table below. Movie Type Male Female Action 294 226 Comedy 264 276 Horror 237 200 Romance 205 298   a. Construct a clustered column chart with the type of movie as the horizontal variable.b. What.
0 Views
View Answer
  31. What is the total area under the normal distribution curve? ??  a. It depends upon the mean and standard deviation  b. It must be calculated  c. 1  d. 100 32. The triangular distribution is a good model for____________ distributions. ??  a. uniform  b. skewed  c. normal  d. normal 33. Fast food restaurants pride themselves in being able to fill orders quickly. A study was done at a local fast food restaurant to determine.
0 Views
View Answer
    51. Using the data given, apply k-means clustering with k = 10 using LandValue ($), BuildingValue ($), Acres, Age, and Price ($) as variables. Be sure to Normalize input data, and specify 50 iterations and 10 random starts in Step 2 of the XLMiner k-Means Clustering procedure. What is the smallest.
0 Views
View Answer
  21. When clustering only by dummy variables that represent categorical variables, the simplest measure of similarity between two observations is called the  a. ?matching coefficient.  b. Jaccard's coefficient.  c. Euclidean distance.  d. ?antecedent. 22. A method for modifying variables that reduces bias prior to cluster analysis is   a. ?standardization.  b. ?weighting.  c. ?removing outliers.  d. ?randomizing. 23. Euclidean distance can be used to measure the distance between________________ in cluster analysis.  a. objects  b. clusters  c. observations  d. ward 24. Average linkage.
0 Views
View Answer
  60. Sadie is constructing a bar chart to describe the average savings account balances for customers at her bank. If the minimum balance is $5.00 and the maximum balance is $18,700, would the following bar chart be a good representation of the data? If not, what would Sadie need to change? ? ?   .
0 Views
View Answer
47. The cross tabulation below classifies employees of a communications company by age and field of expertise. Use the given information to create a joint probability table. ?    Under 35  35-44 45+ Total  Engineering  8,399  8,663  7,072  24,134  Business  14,515  14,988  26,683  56,186  Education  6,738  5,657  8,669  21,064  Liberal Arts  11,415  11,484  12,111  35,010  Total  41,067  40,792  54,535  136,394 ?       .
0 Views
View Answer
56. ____________________ clustering method defines the similarity between two clusters as the similarity of the pair of observations (one from each cluster) that are the most different. 58. Platinum Gym has 10,000 gyms members out of which 1500 memberships included Unlimited Fitness Training and use of the tanning salon, and out of which.
0 Views
View Answer
  21. In a normal? distribution, which is? greater, the mean or the? median? ??  a. Mean  b. Median  c. Neither (they are equal)  d. Cannot be determined with the information provided 22. The center of a normal curve is  a. always equal to zero.  b. the mean of the distribution.  c. always a positive number.  d. equal to the standard deviation. 23. Which of the following is not a characteristic of the normal probability distribution?  a. The.
0 Views
View Answer
54. The regional manager of a company wishes to determine the time spent at each division in the car production process. A study was undertaken over a month that resulted in the following data related to the percentage of time spent at three divisions: Car body construction, Paint shop, and Assembly,.
0 Views
View Answer
  31. Complete linkage can be used to measure the distance between _________ in cluster analysis.?  a. ?objects  b. ?clusters  c. ?observations  d. ?wards 32. Complete linkage can be used to measure the distance between clusters that are the _________________ in cluster analysis.?  a. ?most similar  b. ?most different  c. ?farthest apart  d. ?closest 33. Single linkage can be used to measure the distance between clusters that are the _______________ in cluster.
0 Views
View Answer
  53. a. Using the data given, apply hierarchical clustering with 10 clusters using LandValue ($), BuildingValue ($), Acres, Age, and Price ($) as variables. Be sure to Normalize input data in Step 2 of the XLMiner Hierarchical Clustering procedure, and specify complete linkage as the clustering method. Analyze the resulting clusters by computing.
0 Views
View Answer
61. This Excel bar chart displays the demographics of a Business Analysis class. Approximately how many students  are in the class? ?   ?  a. ?15  b. ?50  c. 105  d. ?30 62. This bar chart displays the demographics of a Business Analysis class. How many males students are in the class? ?   ?  a. ?15  b. ?50  c. ?75  d. ?30 63. Natalie needs to compare the number of employees by job title for the last five.
0 Views
View Answer
55. A consumer electronics company, after three months of the launch of five new products in the market, arrived at the following results. Products Profit (%) Market share (%) Cost ($) A 19 18 4500 B 28 12 3000 C 15 25 8750 D 22 35 6250 E 16 10 2500   a. Create a bubble chart where the market share is along the horizontal axis, the profit is on the vertical axis, and the size of.
0 Views
View Answer
  69. Data are show below on the quality rating, volume, average wait time from pull-up to completion, average unit purchase, and revenue tier for franchises of a certain fast food restaurant in Area 6.  ? ? Area 6 Franchise Data Franchise Number Quality Rating Volume Category Wait Time (sec.) Average Unit Purchase ($) Revenue Tier 124 Above Average High 175 13.25 4 152 Acceptable Low 181 10.02 2 452 Above Average Low 179 13.56 4 462 Above Average Medium 175 12.12 3 485 Superior High 171 15.11 4 567 Acceptable High 178 9.78 2 568 Above Average Medium 177 12.54 4 584 Above Average Medium 176 11.54 3 625 Acceptable Medium 175 11.14 3 875 Acceptable Low 180 8.78 1   ? Using the table below, complete the.
0 Views
View Answer
  58. The data on the ranks assigned to a random sample of students in a competitive exam based on scores and three different veteran statuses are given below. Name Score Rank Status Steve 80 1 DV Joshua 75 2 DV John 95 3 V Alex 90 4 V Jeff 85 5 V Matt 80 6 NV Chris 75 7 NV   a. Create a parallel-coordinates plot using XLMiner for these data. Include vertical axes for the name, score, and rank. Color the lines by the.
0 Views
View Answer
  11. In the probability table below, which value is a marginal probability? ??   Completed Obstacle Course Level NoYesTotal Challenging 0.40.30.7 Easy 0.10.20.3 Total 0.50.51  a. 0.1  b. 1  c. 0.5  d. 0.4 12. A variable that can only take on specific numeric values is called a ??  a. categorical variable.  b. discrete random variable.  c. continuous random variable.  d. categorical variable. 13. An experiment consists of determining the speed of automobiles on a highway by the use of radar equipment. The random.
1 Views
View Answer
54. Participants at the state fair were given 8 rings to toss. The number x of rings tossed onto a stick can be approximated by the probability distribution in the table.  Use the probability distribution to find the mean and variance of the probability distribution.    ?  x  f(x)  0  0.010  1  0.030  2  0.070  3  0.070  4  0.100  5  0.210  6  0.320  7  0.130  8  0.060 ? ?       .
0 Views
View Answer
  41. To identify patterns across transactions, we can use   a. association rules.  b. ?complete linkage.  c. centroid linkage.  d. k-means. 42. The lift ratio of an association rule with a confidence value of 0.45 and in which the consequent occurs in 6 out of 10 cases is  a. 1.40.b. 0.54.  c. 1.00.d. 0.75. 43. Which statement is true of an association rule??  a. ?It is ultimately judged on how actionable it.
0 Views
View Answer
  51. The random variable X is known to be uniformly distributed between 2 and 12. Compute P(X = 3). ? 52. The random variable X is known to be uniformly distributed between 2 and 12. Compute P(X > 10). ? 53. For the standard normal probability distribution, what percent of the curve lies to the left of.
0 Views
View Answer
1. Probability is? the  a. number of successes divided by the number of failures.  b. numerical measure likelihood that an outcome occurs.  c. chance that an event will not happen.  d. number of successes divided by the standard deviation of the distribution. 2. A(n) ________________ is a description of how probabilities are distributed over the values of a random variable.?  a. ?probability distribution  b. ?mass.
3 Views
View Answer
  68. Data are shown below on the quality rating, volume, average wait time from pull-up to completion, average unit purchase, and revenue tier for franchises of a certain fast food restaurant in Area 6.  ?? Area 6 Franchise Data Franchise Number Quality Rating Volume Category Wait Time (sec.) Average Unit Purchase ($) Revenue Tier 124 Above Average High 175 13.25 4 152 Acceptable Low 181 10.02 2 452 Above Average Low 179 13.56 4 462 Above Average Medium 175 12.12 3 485 Superior High 171 15.11 4 567 Acceptable High 178 9.78 2 568 Above Average Medium 177 12.54 4 584 Above Average Medium 176 11.54 3 625 Acceptable Medium 175 11.14 3 875 Acceptable Low 180 8.78 1 ? Using the table below, complete the.
0 Views
View Answer
  66. Never use a ________ chart when a __________ chart will suffice. ??  a. 3-D; 2-D  b. ?2-D; 3-D  c. color; black and white  d. ?bar; pie 67. DJ needs to display data over time. Which of the following charts should DJ use? ??  a. scatter chart  b. pie chart  c. bar chart  d. ?line chart   .
0 Views
View Answer
55. In a binomial? experiment, what does it mean to say that each trial is independent of the other? trials? 56. What type of distribution models the number of occurrences of an event over a specified interval of time or space? ? 57. Let X be a random variable with a Uniform distribution between 8 and 20. Find.
0 Views
View Answer
49. ?a. Using the data given, apply hierarchical clustering with 5 clusters using Wait Time (min) and Customer Satisfaction Rating as variables. Be sure to Normalize input data in Step 2 of the XLMiner Hierarchical Clustering procedure, and specify single linkage as the clustering method. Analyze the resulting clusters by computing the cluster size..
0 Views
View Answer
  49. The contingency table below represents employees of a communications company classified by age and field of expertise. What is the probability that a randomly selected employee age 35-45 years old has business expertise?  ?    Under 35  35-44 45+ Total  Engineering  8,399  8,663  7,072  24,134  Business  14,515  14,988  26,683  56,186  Education  6,738  5,657  8,669  21,064  Liberal Arts  11,415  11,484  12,111  35,010  Total  41,067  40,792  54,535  136,394 ?       .
0 Views
View Answer
57. The following table shows the average monthly distance travelled (in Billion Miles) by vehicles on urban highways for five different years.   Urban Highways - Average Monthly Distance Travelled by Vehicles (Billion Miles) Years Jan Feb Mar Apr May Jun July Aug Sep Oct Nov Dec Year 1 4.22 5.32 5.21 5.12 4.92 4.49 4.55 4.49 4.44 4.39 4.37 4.35 Year 2 4.31 5.44 5.34 5.24 4.98 4.59 4.68 4.65 4.61 4.68 4.74 4.79 Year 3 4.38 5.51 5.41 5.36 4.98 4.63 4.71 4.78 4.82 4.88 4.85 4.89 Year 4 4.45 5.59 5.5 5.41 5.01 4.72 4.78 4.79 4.82 4.92 5.06 5.11 Year 5 4.51 5.65 5.62 5.49 5.12 4.8 4.88 4.82 4.95 5.12 5.22 5.44   a. Use Excel to create sparklines for the average monthly vehicle distance travelled each.
1 Views
View Answer
55.A retailer is interested in analyzing the shopping trend of men concerning the items: Shirts, pants, Jeans, t-shirts, Shoes, and Belts. A sample of 50 male customers is selected and the data are given below. ? ? a. Using a minimum support of 20 transactions and a minimum confidence of 50 percent, use.
0 Views
View Answer
56. The project lead in an MNC decides to assign every member of his team to a new project and monitors their performance on a customized scale of scores. The data on their performance over a period of six months are shown below.   Performance Scores Team members Jan Feb Mar Apr May Jun 1 4 5 2 3 -1 3 2 2 2 3 1 4 4 3 –1 4 4 4 5 1 4 5 1 4 2 5 3 5 2 2 1 5 4 4 6 4 1 2 1 –1 4 7 1 5 –1 2 5 1 8 1 2 5 5 4 2 9 4 5 3 4 2 2 10 4 5 2 2 –1 5 11 5 -1 5 1 2 2 12 3 2 –1 –1 1 2 13 –1 1 4 -1 4 5 14 2 3 3 2 –1 4 15 5 –1 5 5 1 1 16 5 2 1 5 2 –1 17 5 –1 4 –1 2 1 18 3 4 –1 5 2 4 19 2 3 5 1 3 1 20 4 4 3 1 –1 5 21 3 1 1 4 –1 4 22 3 1 5 5 4 2 23 2 2 –1 3 2 –1 24 1 2 4 4 4 3 25 3 5 –1 2 5 4   a. Create a heat map in Excel.
0 Views
View Answer
  50. The cross tabulation shown below shows employees of a communications company classified by age and field of expertise. What is the probability that a randomly selected engineer is under the age of 35?   ?    Under 35  35-44 45+ Total  Engineering  8,399  8,663  7,072  24,134  Business  14,515  14,988  26,683  56,186  Education  6,738  5,657  8,669  21,064  Liberal Arts  11,415  11,484  12,111  35,010  Total  41,067  40,792  54,535  136,394 ?       .
0 Views
View Answer
1. ?The goal of ___________________ is to use the variable values to identify relationships between observations.  a. ?unsupervised learning   b. ?data mining  c. ?McQuitty’s method  d. ?Ward's method 2. Which is NOT a primary option for addressing missing data?    a. ?To discard observations with any missing values  b. ?To discard any variable with missing values  c. ?To fill in missing entries with estimated values  d. ?To generate random data.
6 Views
View Answer