Questions from Spreadsheet Modeling


Q: The IRS wants to develop a method for detecting whether or not

The IRS wants to develop a method for detecting whether or not individuals have overstated their deductions for charitable contributions on their tax returns. To assist in this effort, the IRS supplie...

See Answer

Q: Roger Gallagher owns a used car lot that deals solely in used

Roger Gallagher owns a used car lot that deals solely in used Corvettes. He wants to develop a regression model to help predict the price he can expect to receive for the cars he owns. He collected th...

See Answer

Q: Prepare scatter plots of the values of X1 and X2 against Y

Prepare scatter plots of the values of X1 and X2 against Y. a. Do these relationships seem to be linear or nonlinear? b. Determine the parameter estimates for the regression function represented by:...

See Answer

Q: Explain the purpose of the training, validation, and test data

Explain the purpose of the training, validation, and test data sets in data mining.

See Answer

Q: Home Basics is a home improvement retail store selling all manner of

Home Basics is a home improvement retail store selling all manner of products that are needed by home owners to repair, remodel, and redecorate their homes. The management of Home Basics is analyzing...

See Answer

Q: Colleges and universities are often interested in identifying their peer institutions.

Colleges and universities are often interested in identifying their peer institutions. The file named Colleges.xlsm that accompanies this book contains a number of (artificial) metrics for 307 higher...

See Answer

Q: What is a centroid?

What is a centroid?

See Answer

Q: It can be argued that regression analysis and discriminate analysis both use

It can be argued that regression analysis and discriminate analysis both use a set of independent variables to predict the value of a dependent variable. What, then, is the difference between regressi...

See Answer

Q: What would a lift chart look like for a classification technique with

What would a lift chart look like for a classification technique with 100% accuracy?

See Answer

Q: Consider the file named EmployeeData.xlsx that accompanies this book.

Consider the file named EmployeeData.xlsx that accompanies this book. What errors (or potential errors) can you find in this data set?

See Answer