Questions from Spreadsheet Modeling

Q: When interest rates decline, Patriot Bank has found they get inundated

When interest rates decline, Patriot Bank has found they get inundated with requests to refinance home mortgages. To better plan its staffing needs in the mortgage processing area of its operations, P...

Q: Goldtone Chemical Company is developing a new stain-resistant liquid product

Goldtone Chemical Company is developing a new stain-resistant liquid product that can be applied to different types of fabric. The product can be manufactured in different ways that result in differen...

Q: Creative Confectioners is planning to introduce a new brownie. A small

Creative Confectioners is planning to introduce a new brownie. A small-scale “taste test” was conducted to assess consumer’s preferences (Y) with...

Q: Auto Reports is a consumer magazine that reports on the cost of

Auto Reports is a consumer magazine that reports on the cost of maintaining various types of automobiles. The magazine collected the data found in the file AutoReports.xlsx describing the annual maint...

Q: Duque Power Company wants to develop a regression model to help predict

Duque Power Company wants to develop a regression model to help predict its daily peak power demand. This prediction is useful in determining how much generating capacity needs to be available (or pur...

Q: In comparing two different regression models that were developed using the same

In comparing two different regression models that were developed using the same data, we might say that the model with the higher R2 value will provide the most accurate predictions. Is this true?...

Q: An appraiser collected the data found in file Appraiser.xlsx describing

An appraiser collected the data found in file Appraiser.xlsx describing the auction selling price, diameter (in inches), and item type of several pieces of early 20th century metal tableware manufactu...

Q: Chris Smith is a sports car enthusiast with a particular love for

Chris Smith is a sports car enthusiast with a particular love for Mini Coopers. He downloaded data from eBay on completed auctions of Mini Coopers and used it to create the data set in file MiniCooper...

Q: With Christmas coming, Ryan Bellison was searching for the perfect gift

With Christmas coming, Ryan Bellison was searching for the perfect gift for his wife. After several years of marriage, Ryan leaned back in his chair at the office and tried to think of the one thing h...

Q: Hydroxyethyl cellulose (HEC) is a gelling and thickening agent created

Hydroxyethyl cellulose (HEC) is a gelling and thickening agent created from a molecular combination of cellulose, ethylene oxide (EO), and nitric acid. It is designed to mix with a water-based solutio...