Questions from Business Analytics

Q: Identify the leading and lagging measures for the variables provided in the

Identify the leading and lagging measures for the variables provided in the Excel file Eraser. Find the correlation matrix and propose a cause-and-effect model using the strongest correlations.

Q: Use INDEX and MATCH functions to fill in a table that extracts

Use INDEX and MATCH functions to fill in a table that extracts the amounts shipped between each pair of cities in the Excel file General Appliance Corporation, which shows the solution to an optimizat...

Q: For the Excel file Pharmaceuticals, normalize each column of the numerical

For the Excel file Pharmaceuticals, normalize each column of the numerical data (i.e., compute a Z-score for each of the values) and then compute the Euclidean distances between the following pharmace...

Q: For the three clusters identified in Table 10.3, find

For the three clusters identified in Table 10.3, find the average and standard deviations of each numerical variable for the schools in each cluster and compare them with the average and standard devi...

Q: For the Excel file Total Population, find a normalized distance matrix

For the Excel file Total Population, find a normalized distance matrix between Arkansas, Delaware, South Carolina, and South Dakota states. Apply single linkage clustering to these states and draw a d...

Q: Using only Credit Score, Years of Credit History, Revolving Balance

Using only Credit Score, Years of Credit History, Revolving Balance, and Revolving Utilization, apply single linkage cluster analysis to the first six records in the Excel file Credit Approval Decisio...

Q: Apply single linkage cluster analysis to the first five records in the

Apply single linkage cluster analysis to the first five records in the Excel file Sales Data, using the variables Percent Gross Profit, Industry Code, and Competitive Rating, and draw a dendogram illu...

Q: Using the approach described, classify first record in the worksheet Records

Using the approach described, classify first record in the worksheet Records to Classify in the Excel file Train Journey Decisions by using the k-NN algorithm for k = 1 to 5.

Q: Use discriminant analysis to classify the new records in the Excel file

Use discriminant analysis to classify the new records in the Excel file Train Journey Decisions using only hourly passenger and adult rate as input variables.

Q: A manufacturer of kitchen appliances is preparing to set the price on

A manufacturer of kitchen appliances is preparing to set the price on a new blender. Demand is thought to depend on the price and is represented by the model D = 2,900 - 2P The accounting department e...