QAC 171
Spring 2018 not offered
|
Broadly speaking, this course is about evidence-based decision-making. It is intended for students with a background in Excel and VBA who want to learn how to use spreadsheets to develop business and financial models and communicate the results. Model building is different from the usual Excel skills as it focuses more on the analytical/mathematical aspects than on data wrangling and requires some basic familiarity with economic/financial models and data analysis tools. We will start with problems where the inputs are deterministic and we must decide on optimal allocation of resources. We will then advance to problems with stochastic inputs and explore solutions either through simulation or through optimization of goal functions. Through this work we will develop the appropriate programming skills (e.g., VBA) and learn to effectively use Excel to implement our models and display the results of our analyses. |
|
| Credit: .25 |
Gen Ed Area Dept:
NSM QAC, SBS QAC |
| Course Format: Laboratory | Grading Mode: Student Option |
| Level: UGRD |
Prerequisites: QAC151 AND ECON300 |
|
Fulfills a Requirement for: None |
|
|