Learning Excel for Economics & Business: Statistics Topics

This text is for students studying statistics for advertising and for advertising managers and practitioners who want to learn how to use Excel to solve practical statistics problems in the workplace, whether or not they have taken a course in statistics. This book demonstrates: (1) writing formulas (e.g., confidence interval about the mean, one-group t-test, two-group t-test, correlation) and (2) using Excel's drop-down formula menus (e.g., simple linear regression, multiple correlation and multiple regression, and one-way ANOVA).

"The book is divided into three Parts: Part One has chapters that introduce data analysis and SPSS; Part Two contains eight chapters on descriptive statistics that begin with frequency tables and go through multiple regression; and Part Three includes six chapters on inferential statistics."

This book offers a comprehensive and readable introduction to modern business and data analytics. It is based on the use of Excel, a tool that virtually all students and professionals have access to. The explanations are focused on understanding the techniques and their proper application, and are supplemented by a wealth of in-chapter and end-of-chapter exercises. In addition to the general statistical methods, the book also includes Monte Carlo simulation and optimization.

This book is a step-by-step, exercise-driven guide for students and practitioners who need to master Excel to solve practical social science problems. If understanding statistics isn't your strongest suit, you are not especially mathematically inclined, or you are wary of computers, this is the right book for you. Excel, a widely available computer program for students and managers, is also an effective teaching and learning tool for quantitative analyses in social science courses. Its powerful computational ability and graphical functions make learning statistics much easier than in years past.

Includes a chapter on using Excel as for data analysis, along with chapters on other programs, such as Minitab, SPSS, SAS and R.