Gateway to Business Analytics with Microsoft Excel®
No ratings
Humberto Barreto, DePauw University
Copyright Year:
Publisher: PALNI
Language: English
Formats Available
Conditions of Use
Attribution
CC BY
Table of Contents
- Publisher's Note
- Acknowledgments
- Dedication
- Preface
- User Guide
- Defining Business Analytics
- Optimization with Solver
- Monte Carlo Simulation
- Growth
- Unemployment
- Constrained Optimization
- Yield Curve
- National Income Accounting
- Introduction to VBA
- Demographics
- Afterword
- Contributors
About the Book
Business analytics is a new, expanding subfield with fuzzy edges that overlap into a variety of other established disciplines, including economics, econometrics, computer science, data science, finance, statistics, mathematics, and even psychology. Business analytics includes such traditional techniques as regression and data visualization, but also newer methods such as web scraping, big data, machine learning, and artificial intelligence. Its key distinguishing feature is using data to make and communicate business decisions. This textbook utilizes Microsoft Excel to present a mix of topics appropriate to an undergraduate level introduction to business analytics course with an engaging delivery style.
About the Contributors
Author
Humberto Barreto is interested in using computers (especially Microsoft Excel) to improve the teaching and learning of quantitative methods. He is Professor of Business Analytics at DePauw University and has published papers and books on pedagogy, including (with Frank M. Howland) Introductory Econometrics using Monte Carlo Simulation with Microsoft Excel (Cambridge University Press, 2006), Intermediate Microeconomics with Microsoft Excel (Cambridge University Press, 2009) — now freely open-access — and Teaching Macroeconomics with Microsoft Excel (Cambridge University Press, 2016). Prof. Barreto has been a Fulbright Scholar, won several teaching awards, and given presentations on teaching economics and quantitative methods at many colleges and universities around the world.
Ancillaries
Instructor Resources
- PALNI (by request)