Regression Analysis: Understanding and Building Business and Economic Models Using Excel

J. Holton Wilson, Barry Keating

ISBN 10: 1606494341 / ISBN 13: 9781606494349

Edité par Business Expert Press, US, 2012

A propos de cet article

This book covers essential elements of building and understanding regression models within the context of business and economics. It is a nonmathematical treatment that is accessible, even to readers with limited statistical backgrounds. It is useful for business professionals, MBA students and others who seek to understand regression analysis without having to work through tedious mathematical and statistical theory. The importance of using regression models in modern business and economic analysis can hardly be overstated. In this book we describe exactly how such models can be developed and evaluated. The data used is real data with real world business applications, not data that has been contrived to demonstrate some purely academic point. These data are likely to be encountered and used in the actual world of business. In an appendix using screen shots and step by step instructions, we include how to do use Excel to perform regression analysis. When readers have completed this book they will understand how to build basic mathematical models illustrating business/economic relationships using regression analysis. In addition, they will know how to interpret and evaluate regression models using a five step process (which includes evaluating the model; identifying its statistical significance; determining its explanatory power; for time-series applications, identifying how the error terms are distributed; and understanding the concept of multicollinearity). Readers will understand what is possible and what to look for in evaluating regression models. It is unlikely that most readers will build such models in the course of carrying out their own professional responsibilities, but it is very likely that they will, at some point in their careers, be exposed to such models. This book will help such readers understand models that someone else has developed.

N° de réf. du vendeur LU-9781606494349

Détails bibliographiques

• Titre: Regression Analysis: Understanding and Building Business and Economic Models Using Excel
• Éditeur: Business Expert Press, US
• Date de parution: 2012
• Langue: anglais
• ISBN à 10 chiffres: 1606494341
• ISBN à 13 chiffres: 9781606494349
• Reliure: Paperback
• État de l'article: New

A propos de ce titre

Synopsis

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 will teach you the essential elements of building and understanding regression models in a business/economic context in an intuitive manner. The authors take a non-theoretical treatment that is accessible even if you have a limited statistical background. It is specifically designed to teach the correct use of regression, while advising you of its limitations and teaching about common pitfalls. This book describes exactly how regression models are developed and evaluated -where real data is used, instead of contrived textbook-like problems. Completing this book will allow you to understand and build basic business/economic models using regression analysis. You will be able to interpret the output of those models and you will be able to evaluate the models for accuracy and shortcomings. Even if you never build a model yourself, at some point in your career it is likely that you will find it necessary to interpret one; this book will make that possible. Included are instructions for using Microsoft Excel to build business/economic models using regression analysis with an appendix using screen shots and step-by-step instructions.

À propos de l?auteur

Dr. J. Holton Wilson is professor emeritus in Marketing at Central Michigan University. He has a BA in both economics and chemistry from Otterbein College, an MBA from Bowling Green State University (statistics), and a PhD from Kent State University (majors in both marketing and economics).