Select Collections, Inc. Student Spreadsheet

Select Collections sounds like the name of a fancy dress shop. Actually, in this case, it's a collection agency whose credit manager has asked a summer intern to apply her knowledge of regression analysis to forecast the amount the company will collect from 3,570 delinquent accounts. The intern must submit her forecasts in a contest with other interns to see whose model works the best. The case provides students with a modeling experience on a large data set. Instructors can form student teams and conduct their own forecasting contests.