個案總覽

Based on articles published in both Healthcare Financial Management and the International Journal for Health Planning and Management, this note discusses the challenges facing healthcare organizations in the 21st century, and the nature of the strategic choices they must make.

The purpose of this note is to introduce students to the basic use and vocabulary of Microsoft Excel. Excel is commonly used to do quantitative analysis in business. Students will encounter Excel applications in just about every area of business, including finance, accounting, operations management, marketing, and analytics.

This teaching note provides step-by-step illustrations and practice problems to assist students in learning how to use basic mathematical functions in Microsoft Excel. These functions are the necessary building blocks for many spreadsheet models. This teaching note includes practice exercises, answers, and a supporting Excel workbook for students.

The purpose of this note is to illustrate how to use cell references in Microsoft Excel. References are necessary when using functions and building models. This teaching note provides students with practice exercises and a supporting Excel workbook.

The purpose of this note is to illustrate the use of good modeling practices in Microsoft Excel. An effective spreadsheet model can be a valuable decision-making tool for businesses wanting to improve or expand their operations. To do so, a model must provide information relevant to the decision maker.

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 students to the basic use and vocabulary of Microsoft Excel. Excel is commonly used to do quantitative analysis in business. Students will encounter Excel applications in just about every area of business, including finance, accounting, operations management, marketing, and analytics.

This teaching note provides step-by-step illustrations and practice problems to assist students in learning how to use basic mathematical functions in Microsoft Excel. These functions are the necessary building blocks for many spreadsheet models. This teaching note includes practice exercises, answers, and a supporting Excel workbook for students.

The purpose of this note is to illustrate how to use cell references in Microsoft Excel. References are necessary when using functions and building models. This teaching note provides students with practice exercises and a supporting Excel workbook.

The purpose of this note is to illustrate the use of good modelling practices in Microsoft Excel. An effective spreadsheet model can be a valuable decision-making tool for businesses wanting to improve or expand their operations. To do so, a model must provide information relevant to the decision maker.

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 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.

Histograms are graphs that provide a large amount of useful information for all types of data and display the frequency of observations in a data set. The purpose of this note is to introduce histograms for several types of data, provide examples of insights that can be gained and calculations that can be performed using histograms, and demonstrate how to build histograms in Microsoft Excel. In addition, this note reviews the Normal distribution, which can be used to approximate many empirical distributions. 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 illustrate the use of Data Tables in Microsoft Excel. Data Tables are commonly used for performing sensitivity analyses, sometimes called “What If?” analyses, and for preparing data for graphs. Data Tables can also be used to enable a Monte Carlo simulation in a spreadsheet in more advanced models. The technical 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.

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.

Economic growth in developed nations relies on solving the productivity puzzle: How do we increase the amount of economic output produced for every hour of labour? In practice, labour productivity is calculated as gross domestic product divided by aggregate hours worked. Economy-wide productivity gains often rely on technological innovation, which can straddle various categories, including product versus process, radical versus incremental, and disruptive versus sustaining. This technical note considers four of the most popular strategies to drive productivity growth: intellectual property protection; geographic clusters; investments in science, technology, engineering, and mathematics; and fostering an entrepreneurial spirit.

Economic growth in developed nations relies on solving the productivity puzzle: How do we increase the amount of economic output produced for every hour of labour? In practice, labour productivity is calculated as gross domestic product divided by aggregate hours worked. Economy-wide productivity gains often rely on technological innovation, which can straddle various categories, including product versus process, radical versus incremental, and disruptive versus sustaining. This technical note considers four of the most popular strategies to drive productivity growth: intellectual property protection; geographic clusters; investments in science, technology, engineering, and mathematics; and fostering an entrepreneurial spirit.