Engineering Economy Module

Graph of value against time for original price data, fitted curve from trendline, and reconstructed curve from regression.

Graphical result of computing average growth rate and volatility for Google stocks, based on original stock price data. See the Session 3 lecture and spreadsheets in the Lecture Notes section. (Figure by MIT OpenCourseWare.)


MIT Course Number

ESD.70J / 1.145J

As Taught In

Fall 2009



Cite This Course

Course Features

Course Description

This intensive micro-subject provides the necessary skills in Microsoft® Excel spreadsheet modeling for ESD.71 Engineering Systems Analysis for Design. Its purpose is to bring entering students up to speed on some of the advanced techniques that we routinely use in analysis. It is motivated by our experience that many students only have an introductory knowledge of Excel, and thus waste a lot of time thrashing about unproductively. Many people think they know Excel, but overlook many efficient tools, such as Data Table and Goal Seek. It is also useful for a variety of other subjects.

Other OCW Versions

Archived versions: Question_avt logo

Michel-Alexandre Cardin, and Richard de Neufville. ESD.70J Engineering Economy Module, Fall 2009. (Massachusetts Institute of Technology: MIT OpenCourseWare), (Accessed). License: Creative Commons BY-NC-SA

For more information about using these materials and the Creative Commons license, see our Terms of Use.