Background Note | HBS Case Collection | 2011 (Revised from original 2010 version)

Using Regression Analysis to Estimate Time Equations

by Francisco de Asis Martinez-Jerez and Ariel Andres Blumenkranc

Abstract

This note presents a simple way to estimate time equations using regression analysis in Excel. The note quickly outlines regression analysis, then presents a real-life case example from the natural gas industry that students can use to gain experience developing and interpreting the results of time equations.

Keywords: Accounting; Activity Based Costing and Management; Mathematical Methods;

Citation:

Martinez-Jerez, Francisco de Asis, and Ariel Andres Blumenkranc. "Using Regression Analysis to Estimate Time Equations." Harvard Business School Background Note 111-001, January 2011. (Revised from original September 2010 version.)