Regression Analysis: Understanding and Building Business and Economic Models Using Excel, Second Edition
- 2h 45m
- Barry P. Keating, J. Holton Wilson, Mary Beal
- Business Expert Press
- 2016
The technique of regression analysis is used so often in business and economics today that an understanding of its use is necessary for almost everyone engaged in the field. This book covers essential elements of building and understanding regression models in a business/economic context in an intuitive manner. The book provides a non-theoretical treatment that is accessible to readers with even a limited statistical background. This book describes exactly how regression models are developed and evaluated. The data used in the book are the kind of data managers are faced with in the real world. The book provides instructions and screen shots for using Microsoft Excel to build business/economic regression models. Upon completion, the reader will be able to interpret the output of the regression models and evaluate the models for accuracy and shortcomings.
About the Authors
Dr. J. Holton Wilson Professor Emeritus in Marketing at Central Michigan University was the initial recipient of the Jerry and Felicia Campbell Endowed Professorship in the College of Business at Central Michigan University. His undergraduate degrees (BA - economics , BS - chemistry) from Otterbein College, an MBA (Bowling Green State University) (statistics), and a doctorate (Kent State University) with majors in both marketing and economics.
Dr. Barry P. Keating is professor of business economics at the University of Notre Dame. He received a BBA (University of Notre Dame) an MA (Lehigh University), and PhD (University of Notre Dame). Professor Keating is a Heritage Foundation Fellow (1992-96), a Heartland Institute Research Fellow, Former President of the Economic Club of Michiana, former Chair of the Department of Finance at Notre Dame, is the winner of a Kaneb Teaching Award from Notre Dame, the MBA Professor of the Year Award, and is a fellow of the Kaneb Center.
Dr. Mary Beal earned her MS and PhD in economics from Florida State University following a BA in economics and a BA in physics from the University of Virginia. She is an instructor of economics at the University of North Florida in Jacksonville. Dr. Beal teaches applied business statistics and forecasting to more than 150 MBA students each year. She is an applied microeconomist with interests in real estate and property taxation, education, and labor. She uses regression analysis as her primary analytical tool.
In this Book
-
Background Issues for Regression Analysis
-
Introduction to Regression Analysis
-
The Ordinary Least Squares (OLS) Regression Model
-
Evaluation of Ordinary Least Squares (OLS) Regression Models
-
Point and Interval Estimates from a Regression Model
-
Multiple Linear Regression
-
A Market Share Multiple Regression Model
-
Qualitative Events and Seasonality in Multiple Regression Models
-
Nonlinear Regression Models
-
Abercrombie & Fitch And Jewelry Sales Regression Case Studies
-
The Formal Ordinary Least Squares (OLS) Regression Model
-
Appendix Some Statistical Background
