Statistics for managers using Microsoft excel / / David M. Levine, David F. Stephan, Kathryn A. Szabat

• Autore: Levine David M. <1946->
• Pubblicazione: Boston : , : Pearson, , [2014]; ©2014
• Edizione: Seventh, global edition.
• Descrizione fisica: 1 online resource (792 pages) : color illustrations, photographs
• Disciplina: 005.369
• Persona (resp. second.): StephanDavid; SzabatKathryn A.
• Note generali: Includes index.
• Nota di bibliografia: Includes bibliographical references and index.
• Nota di contenuto: Cover -- Statistics for Managers -- About the Authors -- Brief Contents -- Contents -- Preface -- Let's Get Started: Big Things to Learn First -- Using Statistics: "You Cannot Escape from Data" -- LGS.1 A Way of Thinking -- LGS.2 Define Your Terms! -- LGS.3 Business Analytics: the Changing Face of Statistics -- "Big Data" -- Statistics: An Important Part of Your Business Education -- LGS.4 How to Use This Book -- References -- Key Terms -- Excel Guide -- EG.1. What Is Microsoft Excel? -- EG2. How Can I Use Excel with This Book? -- EG3. What Excel Skills Does This Book Require? -- EG4. Getting Ready to Use Excel with This Book -- EG5. Entering Data -- EG6. Opening and Saving Workbooks -- EG7. Creating and Copying Worksheets -- EG8. Printing Worksheets -- Defining and Collecting Data -- Using Statistics: Beginning of the End ... Or the End of the Beginning? -- Establishing the Variable Type -- Measurement Scales for Variables -- Nominal and Ordinal Scales -- Interval and Ratio Scales -- Collecting Data -- Data Sources -- Populations and Samples -- Data Cleaning -- Recoded Variables -- Types of Sampling Methods -- Simple Random Sample -- Systematic Sample -- Stratified Sample -- Cluster Sample -- Types of Survey Errors -- Coverage Error -- Nonresponse Error -- Sampling Error -- Measurement Error -- Ethical Issues About Surveys -- Think About This: New Media Surveys/Old Sampling Problems -- Using Statistics: Beginning ... Revisited -- Summary -- References -- Key Terms -- Checking Your Understanding -- Chapter Review Problems -- Cases for Chapter 1 -- Managing Ashland MultiComm Services -- CardioGood Fitness -- Clear Mountain State Student Surveys -- Learning with the Digital Cases -- Chapter 1 Excel Guide -- EG1.1 Establishing the Variable Type -- EG1.2 Measurement Scales for Variables -- EG1.3 Collecting Data -- EG1.4 Types of Sampling Methods. ; EG1.5 Types of Survey Errors -- Organizing and Visualizing Data -- Using Statistics: The Choice Is Yours -- How to Proceed with This Chapter -- Organizing Categorical Data -- The Summary Table -- The Contingency Table -- Organizing Numerical Data -- Stacked and Unstacked Data -- The Ordered Array -- The Frequency Distribution -- Classes and Excel Bins -- The Relative Frequency Distribution and the Percentage Distribution -- The Cumulative Distribution -- Visualizing Categorical Data -- The Bar Chart -- The Pie Chart -- The Pareto Chart -- The Side-by-Side Bar Chart -- Visualizing Numerical Data -- The Stem-and-Leaf Display -- The Histogram -- The Percentage Polygon -- The Cumulative Percentage Polygon (Ogive) -- Visualizing Two Numerical Variables -- The Scatter Plot -- The Time-Series Plot -- Challenges in Visualizing Data -- Chartjunk -- Guidelines for Developing Visualizations -- Organizing and Visualizing Many Variables -- Multidimensional Contingency Tables -- Adding Numerical Variables -- Drill-down -- PivotTables and Business Analytics -- Real-World Business Analytics and Microsoft Excel -- Using Statistics: The Choice Is Yours, Revisited -- Summary -- References -- Key Equations -- Key Terms -- Checking Your Understanding -- Chapter Review Problems -- Cases for Chapter 2 -- Managing Ashland MultiComm Services -- Digital Case -- CardioGood Fitness -- The Choice Is Yours Follow-up -- Clear Mountain State Student Surveys -- Chapter 2 Excel Guide -- EG2.1 Organizing Categorical Data -- EG2.2 Organizing Numerical Data -- EG2.3 Visualizing Categorical Data -- EG2.4 Visualizing Numerical Data -- EG2.5 Visualizing Two Numerical Variables -- EG2.6 Challenges in Visualizing Data -- EG2.7 Organizing and Visualizing Many Variables -- EG2.8 PivotTables and Business Analytics -- Numerical Descriptive Measures -- Using Statistics: More Descriptive Choices. ; Central Tendency -- The Mean -- The Median -- The Mode -- The Geometric Mean -- Variation and Shape -- The Range -- The Variance and the Standard Deviation -- The Coefficient of Variation -- Z Scores -- Shape: Skewness and Kurtosis -- Visual Explorations: Exploring Descriptive Statistics -- Exploring Numerical Data -- Quartiles -- The Interquartile Range -- The Five-Number Summary -- The Boxplot -- Numerical Descriptive Measures for a Population -- The Population Mean -- The Population Variance and Standard Deviation -- The Empirical Rule -- The Chebyshev Rule -- The Covariance and the Coefficient of Correlation -- The Covariance -- The Coefficient of Correlation -- Descriptive Statistics: Pitfalls and Ethical Issues -- Using Statistics: More Descriptive Choices, Revisited -- Summary -- References -- Key Equations -- Key Terms -- Checking Your Understanding -- Chapter Review Problems -- Cases for Chapter 3 -- Managing Ashland MultiComm Services -- Digital Case -- CardioGood Fitness -- More Descriptive Choices Follow-up -- Clear Mountain State Student Surveys -- Chapter 3 Excel Guide -- EG3.1 Central Tendency -- EG3.2 Variation and Shape -- EG3.3 Exploring Numerical Data -- EG3.4 Numerical Descriptive Measures for a Population -- EG3.5 The Covariance and the Coefficient of Correlation -- Basic Probability -- Using Statistics: Possibilities at M&R Electronics World -- Basic Probability Concepts -- Events and Sample Spaces -- Contingency Tables -- Simple Probability -- Joint Probability -- Marginal Probability -- General Addition Rule -- Conditional Probability -- Computing Conditional Probabilities -- Decision Trees -- Independence -- Multiplication Rules -- Marginal Probability Using the General Multiplication Rule -- Bayes' Theorem -- Think About This: Divine Providence and Spam -- Ethical Issues and Probability -- Counting Rules (online). ; Using Statistics: Possibilities at M&R Electronics World, Revisited -- Summary -- References -- Key Equations -- Key Terms -- Checking Your Understanding -- Chapter Review Problems -- Cases for Chapter 4 -- Digital Case -- CardioGood Fitness -- The Choice Is Yours Follow-up -- Clear Mountain State Student Surveys -- Chapter 4 Excel Guide -- EG4.1 Basic Probability Concepts -- EG4.2 Conditional Probability -- EG4.3 Bayes' Theorem -- Discrete Probability Distributions -- Using Statistics: Events of Interest at Ricknel Home Centers -- The Probability Distribution for a Discrete Variable -- Expected Value of a Discrete Variable -- Variance and Standard Deviation of a Discrete Variable -- Covariance of a Probability Distribution and Its Application in Finance -- Covariance -- Expected Value, Variance, and Standard Deviation of the Sum of Two Variables -- Portfolio Expected Return and Portfolio Risk -- Binomial Distribution -- Poisson Distribution -- Hypergeometric Distribution -- Using Statistics: Events of Interest at Ricknel Home Centers, Revisited -- Summary -- References -- Key Equations -- Key Terms -- Checking Your Understanding -- Chapter Review Problems -- Cases for Chapter 5 -- Managing Ashland MultiComm Services -- Digital Case -- Chapter 5 Excel Guide -- EG5.1 The Probability Distribution for a Discrete Variable -- EG5.2 Covariance of a Probability Distribution and Its Application in Finance -- EG5.3 Binomial Distribution -- EG5.4 Poisson Distribution -- EG5.5 Hypergeometric Distribution -- The Normal Distribution and Other Continuous Distributions -- Using Statistics: Normal Downloading at MyTVLab -- Continuous Probability Distributions -- The Normal Distribution -- Computing Normal Probabilities -- Finding X Values -- Visual Explorations: Exploring the Normal Distribution -- Think About This: What Is Normal? -- Evaluating Normality. ; Comparing Data Characteristics to Theoretical Properties -- Constructing the Normal Probability Plot -- The Uniform Distribution -- The Exponential Distribution -- The Normal Approximation to the Binomial Distribution (online) -- Using Statistics: Normal Downloading at MyTVLab, Revisited -- Summary -- References -- Key Equations -- Key Terms -- Checking Your Understanding -- Chapter Review Problems -- Cases for Chapter 6 -- Managing Ashland MultiComm Services -- Digital Case -- CardioGood Fitness -- More Descriptive Choices Follow-up -- Clear Mountain State Student Surveys -- Chapter 6 Excel Guide -- EG6.1 Continuous Probability Distributions -- EG6.2 The Normal Distribution -- EG6.3 Evaluating Normality -- EG6.4 The Uniform Distribution -- EG6.5 The Exponential Distribution -- Sampling Distributions -- Using Statistics: Sampling Oxford Cereals -- Sampling Distributions -- Sampling Distribution of the Mean -- The Unbiased Property of the Sample Mean -- Standard Error of the Mean -- Sampling from Normally Distributed Populations -- Sampling from Non-normally Distributed Populations-The Central Limit Theorem -- Visual Explorations: Exploring Sampling Distributions -- Sampling Distribution of the Proportion -- Sampling from Finite Populations (online) -- Using Statistics: Sampling Oxford Cereals, Revisited -- Summary -- References -- Key Equations -- Key Terms -- Checking Your Understanding -- Chapter Review Problems -- Cases for Chapter 7 -- Managing Ashland MultiComm Services -- Digital Case -- Chapter 7 Excel Guide -- EG7.1 Sampling Distributions -- EG7.2 Sampling Distribution of the Mean -- EG7.3 Sampling Distribution of the Proportion -- Confidence Interval Estimation -- Using Statistics: Getting Estimates at Ricknel Home Centers -- Confidence Interval Estimate for the Mean (σ Known) -- Can You Ever Know the Population Standard Deviation?. ; Confidence Interval Estimate for the Mean (σ Known).
• Sommario/riassunto: For undergraduate Business Statistics Courses. This Global Edition has been edited to include enhancements making it more relevant to students outside the United States Analyze the data, see the business relevance. Reducing the emphasis on doing computations, this practical text thoroughly integrates Microsoft® Excel as a tool for analysis and presents statistical concepts in the context of the functional areas of business.
• Titolo autorizzato: Statistics for managers using Microsoft Excel
• ISBN: 0-273-78774-8
• Formato: Materiale a stampa
• Livello bibliografico: Monografia
• Lingua di pubblicazione: Inglese
• Record Nr.: 9910150211203321
• Lo trovi qui: Univ. Federico II
• Serie: Always learning.