Exploring Economic Models Using Excel

Cahill, Miles; Kosicki, George

doi:10.1002/j.2325-8012.2000.tb00288.x

Cited by 3 publications

(1 citation statement)

References 13 publications

Supporting

Mentioning

Contrasting

Order By: Relevance

“…Moreover, Excel is used extensively outside of the classroom, and an understanding of the software is a useful skill for students to develop. The pedagogical benefits of using Excel in the economics classroom are now broadly established (see Cahill & Kosicki, 2000). Wight (1999) discusses some general benefits of using spreadsheets beyond numerical simulation, while Briand and Hill (2013) consider the use of Excel for econometrics, for example.…”

Section: Introductionmentioning

confidence: 99%

Building and using nonlinear simulations in Excel with an application to the specific factors model

Gilbert

Koska

Oladi

2023

Southern Economic Journal

View full text Add to dashboard Cite

Excel simulation models have become increasingly common in the economics classroom, as their ability to combine numerical and graphical information has proved a useful support to traditional teaching methods. Recent efforts have tended to embed the solution within the Excel sheet, avoiding the need to use the Solver add‐in and allowing changes in the exogenous characteristics of the model to be instantly reflected in the numerical solutions and any associated geometry. While this is quite simple in small‐scale linear models, it is less straightforward in larger nonlinear models such as those that dominate the theory of international trade. We discuss various methods that can be used in building Excel simulations when it is not possible to solve the underlying model explicitly. We illustrate the ideas and describe our experiences along with a new simulation of the specific factors model.

show abstract

Section: Introductionmentioning

confidence: 99%

Building and using nonlinear simulations in Excel with an application to the specific factors model

Gilbert

Koska

Oladi

2023

Southern Economic Journal

View full text Add to dashboard Cite

show abstract

Demonstrating Cournot and Collusive equilibria using computer spreadsheets

Hegji

2000

Manage Decis Econ

View full text Add to dashboard Cite

show abstract

Estimating accounting and finance models with Microsoft Excel

2009

View full text Add to dashboard Cite

PurposeThe purpose of this paper is to propose a way to introduce regression analysis into courses with minimal start‐up time. Doing so makes it less likely that introducing both the software and the estimation technique will create discontinuity in the flow of the material being covered.Design/methodology/approachThis paper discusses an Excel workbook that reduces the amount of time students must use to become adept at estimating model parameters.FindingsThe workbook provides a set of macros that guides students through the implementation of ordinary least squares (OLS) estimation and provides them with information that is not part of standard Excel output. It also conducts high‐low analysis.Originality/valueUsing this program can reduce the difficulties encountered in having students conduct the valuable exercise of model estimation.

show abstract

Exploring Economic Models Using Excel

Cited by 3 publications

References 13 publications

Building and using nonlinear simulations in Excel with an application to the specific factors model

Building and using nonlinear simulations in Excel with an application to the specific factors model

Demonstrating Cournot and Collusive equilibria using computer spreadsheets

Estimating accounting and finance models with Microsoft Excel

Contact Info

Product

Resources

About