Using Statistics for Better Business Decisions

Justin Bateh, Bert G. Wachsmuth

• Verlag: Business Expert Press
• Jahr: 2015
• ISBN:
  9781631572739
• Thema: Economics
• Thema: Statistics for Business & Economics

More and more organizations around the globe are expecting that professionals will make data-driven decisions. Employees, team leaders, managers, and executives that can think quantitatively should be in high demand. The goal of this book is to increase ability to identify a problem, collect data, organize, and analyze data that will help aid in making more effective decisions. This book will provide you with a solid foundation for thinking quantitatively within your company. To help facilitate this objective, this book follows two fictitious companies that encounter a series of business problems, while demonstrating how managers would use the concepts in the book to solve these problems and determine the next course of action. This book is for beginners and does not require prior statistical training. All computations will be completed using Microsoft Excel.

Chapter 1

Statistics and Statistical Software

Preview: The study of statistics is vitally important, yet many people have only a vague understanding of it. Statistical analyses play a role in everything from politics and social science to studies of biological diversity, and individuals with a deep understanding of the science are always in high demand. Many people think they understand statistics, but the actual results of a statistical analysis can be counterintuitive. That is why it is so important to move beyond intuition and into the realm of science. It is important to realize that statistics is not an end in itself. Rather, it is a means for the identification and analysis of problems, and it is a useful tool to arrive at better decisions. The statistical method is used to make decisions with ramifications in the real world, and that makes the science a vital part of modern business. Simply put, statistics attempts to make sense of data. Descriptive statistics involves the collection and description of data. Once the data has been collected and described, the researcher is able to understand the context in which the results are presented. Inferential statistics collects data from a subset of the population and uses that information to draw conclusions about the population as a whole. The populations used in a statistical analysis can be anything from a group of water quality measurements in a river system to the heights of soldiers in the U.S. Army. The science behind the analysis is the same no matter where the data are drawn from. No matter what kind of data is being analyzed, the statistical analysis process uses the same steps: problem definition, data collection, data analysis, and reporting the final analysis. This process is designed to be rigorous and scientific, providing an impartial look at the data and an impartial analysis of the results.

Learning Objectives: At the conclusion of this chapter, you should be able to:

1. Set up Microsoft Excel to run statistical analyses
2. Understand the importance of random sampling
3. Demonstrate how to use Microsoft Excel to identify a random sample
4. Understand basic vocabulary in the statistics field
5. Explain the importance in using statistics for business decision making
6. Identify the sources and types of data used in business.

Introduction

Statistics is one of those strange entities that people describe as useful or even important without knowing precisely what it is; people seem to intuitively know about statistics (or think they know). For example, one of the first questions we ask when teaching a statistics course is (naturally): “What do you think statistics is?” Answers typically range from “statistics consists of compiling lots of numbers [...]” to “statistics deals with collecting and analyzing data”; indeed, most students have something to say. Even prolific writers such as Mark Twain have an opinion about statistics; he is reported to have said: “there are three kinds of lies: lies, damned lies, and statistics” (the exact origin of this phrase is unclear). Contrast that, for example, with what would happen if you ask people what “calculus” is and whether they think it might be useful for them: You most likely earn a majority of blank stares (and not even Mark Twain came up with any quips about calculus).

Thus, statistics as a mathematical topic has an advantage: You do not necessarily have to convince people it is useful; you merely have to ensure they know exactly what it is and how to use it (and how it can be abused). In addition, statistics has a lot to do with data analysis and everybody relies on data in one way or another:

• Corporate presidents decide company policy based on quarterly sales figures.
• Politicians decide on campaign strategy base...