Product Information
For a one- or two-term course in Business Statistics at the undergraduate or graduate level. Thoroughly integrating the use of Microsoft Excel, this streamlined text on business statistics uses an applied approach that focuses on the concepts and applications of statistics to the functional areas of business-accounting, marketing, management, and economics and finance. Revised to increase the emphasis on concepts and applications and to more seamlessly integrate coverage on Microsoft Excel, it offers detailed, step-by-step explanations on the use of Microsoft Excel to perform statistical analysis on every topic covered in the book and integrates numerous illustrations of Excel output and dialog boxes.Product Identifiers
PublisherPrentice Hall PTR
ISBN-100130203122
ISBN-139780130203120
eBay Product ID (ePID)391751
Product Key Features
Number of Pages1152 Pages
LanguageEnglish
Publication NameStatistics for Managers Using Microsoft Excel
Publication Year1999
SubjectDesktop Applications / Spreadsheets, Statistics
TypeTextbook
Subject AreaComputers, Business & Economics
AuthorDavid M. Levine, Mark L. Berenson, David Stephan
FormatCD-ROM / Trade Paperback
Dimensions
Item Height1.6 in
Item Weight79.7 Oz
Item Length10.2 in
Item Width8.3 in
Additional Product Features
Edition Number2
LCCN98-043644
Dewey Edition23
Target AudienceCollege Audience
IllustratedYes
Dewey Decimal519.50285/554
Table of Content1. Introduction and Data Collection. Why a Manager Needs to Know about Statistics. The Growth and Development of Modern Statistics. Statistical Thinking and Modern Management. Descriptive versus Inferential Statistics. Why Do We Need Data? Sources of Data. Types of Data. Types of Sampling Methods. Evaluating Survey Worthiness. Case Study A: Alumni Association Survey. Supplement Using Microsoft Excel for Statistical Analysis. Overview. Getting Familiar with the User Interface. Getting Started with Microsoft Excel. Using Microsoft Excel Wizards and Add-Ins. Summary. Key Terms. 2. Presenting Data in Tables and Charts. Organizing Numerical Data. Organizing Numerical Data Using Microsoft Excel. Tables and Charts for Categorical Data. Generating Tables and Charts for Categorical Data Using Microsoft Excel. Tabulating and Graphing Bivariate Categorical Data. Generating Tables and Charts for Bivariate Categorical Data Using Microsoft Excel. Graphical Excellence. Summary. Key Terms. Chapter Review Problems. Team Project. The Springville Herald Case. 3. Summarizing and Describing Numerical Data. Exploring Numerical Data and Their Properties. Measures of Central Tendency, Variation, and Shape. Generating Measures of Central Tendency, Variation, and Shape Using Microsoft Excel. Exploratory Data Analysis. Exploratory Data Analysis in Microsoft Excel. Obtaining Descriptive Summary Measures from a Population. Generating Descriptive Measures in a Population Using Microsoft Excel. Recognizing and Practicing Proper Descriptive Summarization and Exploring Ethical Issues. Summary. Key Terms. Chapter Review Problems. Team Project. Case Study B: State Alcoholic Beverages Oversight Board Study on Beers. Springville Herald Case. 4. Basic Probability and Discrete Probability Distributions. Basic Probability Concepts. Calculating Probabilities Using Microsoft Excel. Conditional Probability. Bayes' Theorem. The Probability Distribution for a Discrete Random Variable. Binomial Distribution. Calculating Binomial Probabilities Using Microsoft Excel. Poisson Distribution. Calculating Poisson Probabilities Using Microsoft Excel. Hypergeometric Distribution (Optional Topic.) Calculating Hypergeometric Probabilities Using Microsoft Excel. Covariance and its Application in Finance (Optional Topic). Calculating the Covariance Using Microsoft Excel. Ethical Issues and Probability. Summary. Key Terms. Chapter Review Problems. Springville Herald Case. 5. Decision Making. The Payoff Table and Decision Trees. Calculating Opportunity Loss Using Microsoft Excel. Criteria for Decision Making. Generating Criteria for Decision Making Using Microsoft Excel. Decision Making with Sample Information. Utility. Summary. Key Terms. Chapter Review Problems. 6. The Normal Distribution and Sampling Distributions. The Normal Distribution. Calculating Normal Probabilities Using Microsoft Excel. Assessing the Normality Assumption. Generating Exponential Probabilities Using Microsoft Excel. Introduction to Sampling Distributions. Sampling Distribution of the Mean. Simulating Sampling Distributions Using Microsoft Excel. Generating Random Samples Using Microsoft Excel. Sampling Distribution of the Proportion. Sampling from Finite Populations. Summary. Key Terms. Chapter Review Problems. Team Project. Springville Herald Case. 7. Confidence Interval Estimation. Confidence Interval Estimation for the Mean (s Known). Calculating the Confidence Interval Estimate for the Mean (s Known) Using Microsoft Excel. Confidence Interval Estimation for the Mean (s Unknown). Calculating the Confidence Interval Estimate for the Mean (s Unknown) Us