個案總覽

The purpose of this note is to illustrate the use of Microsoft Excel functions for generating descriptive statistics for continuous data. These functions are common when analyzing data to provide insights for decision making. The note includes practice exercises and their solutions, and a supporting Excel workbook for students.

The purpose of this note is to illustrate the use of Microsoft Excel's Goal Seek feature. The technical note includes practice exercises and their solutions, and a supporting Excel workbook for students.

In 2009, the owner of a Broadway theatre has to figure out whether to switch to a new show or continue with the current one, which is not generating the revenue expected. He already has a new show booked to begin in five weeks; each new show requires a week of set-up time during which its producers pay rent to the theatre but there are no ticket sales. Is it worth closing the current show and replacing it with an unknown show for a very limited run? Or should he just let the current show continue until the new, already contracted show is set to begin? A freelance analytics consultant helps him solve the problem by analyzing past data on the weekly box office performance of shows.