Questions from Analytics

Q: Construct a variable plot for all the variables in the

Construct a variable plot for all the variables in the Excel file Banking Data

Q: Compute the Euclidean distance between the following sets of points:

Compute the Euclidean distance between the following sets of points:a. (2,5) and (8,4)b. (2, -1, 3) and (8, 15, -5)

Q: In the Excel file Restaurant Sales, determine if the variance

In the Excel file Restaurant Sales, determine if the variance of weekday sales is the same as that of weekend sales for each of the three variables (lunch, dinner, and delivery)

Q: A sample of 20 international students attending an urban U.S.

A sample of 20 international students attending an urban U.S. university found that the average amount budgeted for expenses per month was $1612.50 with a standard deviation of $1179.64. Find a 95% co...

Q: For the Excel file Colleges and Universities, normalize each column

For the Excel file Colleges and Universities, 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 followin...

Q: For the four clusters identified in Example 10.6, find the

For the four clusters identified in Example 10.6, find the average and standard deviations of each numerical variable for the schools in each cluster and compare them with the averages and standard de...

Q: For the Colleges and Universities data, use XLMiner to find

For the Colleges and Universities data, use XLMiner to find four clusters using each of the other clustering methods (see Figure 10.13); compare the results with Example 10.6.Figure 10.13,,,

Q: A manager needs to identify some information from the Purchase

A manager needs to identify some information from the Purchase Orders Excel file but has only the order number. Modify the Excel file to use the VLOOKUP function to find the item description and cost...

Q: Develop a spreadsheet model for gasoline usage scenario, Problem 4

Develop a spreadsheet model for gasoline usage scenario, Problem 4 in Chapter 1, using the data provided. Apply the principles of spreadsheet engineering in developing your model.Problem 4 in Chapter...

Q: A stockbroker calls on potential clients from referrals. For each

A stockbroker calls on potential clients from referrals. For each call, there is a 10% chance that the client will decide to invest with the firm. Fifty-five percent of those interested are found not...