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