個案總覽

Spreadsheet to accompany product 9B16E013.

Spreadsheet to accompany product 9B16E016.

The purpose of this note is to introduce the concept of logical statements in Microsoft Excel and to illustrate the use of Excel’s built-in logic functions. The note includes practice exercises and their solutions, and a supporting Excel workbook for students.

The purpose of this technical note is to introduce and illustrate the use of Microsoft Excel’s built-in advanced logic functions. Excel’s advanced logic functions add logical capabilities to normal descriptive statistics functions. The note includes practice exercises and their solutions, and a supporting Excel workbook for students.

The purpose of this note is to introduce the concept of logical statements in Microsoft Excel and to illustrate the use of Excel's built-in logic functions. The note includes practice exercises and their solutions, and a supporting Excel workbook for students.

Student spreadsheet for case W16409.

The purpose of this technical note is to introduce and illustrate the use of Microsoft Excel's built-in advanced logic functions. Excel's advanced logic functions add logical capabilities to normal descriptive statistics functions. The note includes practice exercises and their solutions, and a supporting Excel workbook for students.

Student spreadsheet for case W16415.

The head of Data Marketing Analytics and Mobile for Intel Asia-Pacific was reviewing the proposed media plan for the Catch & Win 2.0 campaign. The media purchase needed to be finalized quickly in order to be included in the current quarter’s budget, but he could not help feeling that the proposed spend across the markets and advertising types could be used more effectively. He thought that the key was to use the company’s own experience and data regarding social media engagement within their markets rather than to rely on the generalized industry metrics provided by the contracted media agency, and now he must improve the proposed media plan.

Excel spreadsheet for instructors.

The head of Data Marketing Analytics and Mobile for Intel Asia-Pacific was reviewing the proposed media plan for the Catch & Win 2.0 campaign. The media purchase needed to be finalized quickly in order to be included in the current quarter's budget, but he could not help feeling that the proposed spend across the markets and advertising types could be used more effectively. He thought that the key was to use the company's own experience and data regarding social media engagement within their markets rather than to rely on the generalized industry metrics provided by the contracted media agency, and now he must improve the proposed media plan.