Supplement | HBS Case Collection | September 2010

Using Regression Analysis to Estimate Time Equations (CW)

by Francisco de Asis Martinez-Jerez

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: History; Management Practices and Processes; Activity Based Costing and Management; Learning; Outcome or Result; Financial Statements; Experience and Expertise; Adoption; Communication Technology; Knowledge Acquisition; Management Skills;

Citation:

Martinez-Jerez, Francisco de Asis. "Using Regression Analysis to Estimate Time Equations (CW)." Harvard Business School Spreadsheet Supplement 111-702, September 2010.