Statistics for managers using Microsoft Excel

Statistics for managers using Microsoft Excel

For one-semester courses in Introduction to Business Statistics. The gold standard in learning Microsoft Excelfor business statistics Statistics for Managers Using Microsoft® Excel®, 9th Edition, Global Edition helps students develop the knowledge of Excel needed in future careers. The authors prese...

Full description

Bibliographic Details
Main Author: David M. Levine (-)
Other Authors: Levine, David M., 1946- author (author), Stephan, David, author, Szabat, Kathryn A., author
Format: eBook
Language:Inglés
Published: Harlow, England : Pearson [2021]
Edition:Ninth, global edition
Subjects:
Microsoft Excel (Computer file)
Gestión > Métodos estadísticos.
Estadísticas comerciales.
Hojas de cálculo electrónicas.
Gestión > Métodos estadísticos > Programas informáticos.
Estadísticas comerciales > Programas informáticos.
Management > Statistical methods.
Commercial statistics.
Electronic spreadsheets.
Management > Statistical methods > Computer programs.
Commercial statistics > Computer programs.
Libros electrónicos.
See on Biblioteca Universitat Ramon Llull:https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009667025806719
Table of Contents:
  • Cover
  • A Roadmap for Selectinga Statistical Method
  • Title Page
  • Copyright Page
  • About the Authors
  • Brief Contents
  • Contents
  • Preface
  • Resources for Success
  • First Things First
  • USING STATISTICS: "The Price of Admission"
  • FTF.1 Think Differently About Statistics
  • Statistics: A Way of Thinking
  • Statistics: An Important Part of Your Business Education
  • FTF.2 Business Analytics: The Changing Face of Statistics
  • "Big Data"
  • FTF.3 Starting Point for Learning Statistics
  • Statistic
  • Can Statistics ( pl., statistic) Lie?
  • FTF.4 Starting Point for Using Software
  • Using Software Properly
  • FTF.5 Starting Point for Using Microsoft Excel
  • More About the Excel Guide Workbooks
  • Excel Skills That Readers Need
  • REFERENCES
  • KEY TERMS
  • EXCEL GUIDE
  • EG.1 Getting Started with Excel
  • EG.2 Entering Data
  • EG.3 Open or Save a Workbook
  • EG.4 Working with a Workbook
  • EG.5 Print a Worksheet
  • EG.6 Reviewing Worksheets
  • EG.7 If You Use the Workbook Instructions
  • TABLEAU GUIDE
  • TG.1 Getting Started with Tableau
  • TG.2 Entering Data
  • TG.3 Open or Save a Workbook
  • TG.4 Working with Data
  • TG.5 Print a Workbook
  • 1 Defining and Collecting Data
  • USING STATISTICS: Defining Moments
  • 1.1 Defining Variables
  • Classifying Variables by Type
  • Measurement Scales
  • 1.2 Collecting Data
  • Populations and Samples
  • Data Sources
  • 1.3 Types of Sampling Methods
  • Simple Random Sample
  • Systematic Sample
  • Stratified Sample
  • Cluster Sample
  • 1.4 Data Cleaning
  • Invalid Variable Values
  • Coding Errors
  • Data Integration Errors
  • Missing Values
  • Algorithmic Cleaning of Extreme Numerical Values
  • 1.5 Other Data Preprocessing Tasks
  • Data Formatting
  • Stacking and Unstacking Data
  • Recoding Variables
  • 1.6 Types of Survey Errors
  • Coverage Error
  • Nonresponse Error
  • Sampling Error.
  • Measurement Error
  • Ethical Issues About Surveys
  • CONSIDER THIS: New Media Surveys/Old Survey Errors
  • USING STATISTICS: Defining Moments, 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 Survey
  • Learning With the Digital Cases
  • Chapter 1 EXCEL GUIDE
  • EG1.1 Defining Variables
  • EG1.2 Types of Sampling Methods
  • EG1.3 Data Cleaning
  • EG1.4 Other Data Preprocessing
  • Chapter 1 TABLEAU GUIDE
  • TG1.1 Defining Variables
  • TG1.2 Data Cleaning
  • 2 Organizing and Visualizing Variables
  • USING STATISTICS: "The Choice Is Yours"
  • 2.1 Organizing Categorical Variables
  • The Summary Table
  • The Contingency Table
  • 2.2 Organizing Numerical Variables
  • The Frequency Distribution
  • The Relative Frequency Distribution and the Percentage Distribution
  • The Cumulative Distribution
  • 2.3 Visualizing Categorical Variables
  • The Bar Chart
  • The Pie Chart and the Doughnut Chart
  • The Pareto Chart
  • Visualizing Two Categorical Variables
  • 2.4 Visualizing Numerical Variables
  • The Stem-and-Leaf Display
  • The Histogram
  • The Percentage Polygon
  • The Cumulative Percentage Polygon (Ogive)
  • 2.5 Visualizing Two Numerical Variables
  • The Scatter Plot
  • The Time-Series Plot
  • 2.6 Organizing a Mix of Variables
  • Drill-Down
  • 2.7 Visualizing a Mix of Variables
  • Colored Scatter Plot (Tableau)
  • Bubble Chart
  • PivotChart
  • Treemap
  • Sparklines
  • 2.8 Filtering and Querying Data
  • Excel Slicers
  • 2.9 Pitfalls in Organizing and Visualizing Variables
  • Obscuring Data
  • Creating False Impressions
  • Chartjunk
  • 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 Survey
  • Chapter 2 EXCEL GUIDE
  • EG2.1 Organizing Categorical Variables
  • EG2.2 Organizing Numerical Variables
  • EG2.3 Visualizing Categorical Variables
  • EG2.4 Visualizing Numerical Variables
  • EG2.5 Visualizing Two Numerical Variables
  • EG2.6 Organizing a Mix of Variables
  • EG2.7 Visualizing a Mix of Variables
  • EG2.8 Filtering and Querying Data
  • Chapter 2 TABLEAU GUIDE
  • TG2.1 Organizing Categorical Variables
  • TG2.2 Organizing Numerical Variables
  • TG2.3 Visualizing Categorical Variables
  • TG2.4 Visualizing Numerical Variables
  • TG2.5 Visualizing Two Numerical Variables
  • TG2.6 Organizing a Mix of Variables
  • TG2.7 Visualizing a Mix of Variables
  • 3 Numerical Descriptive Measures
  • USING STATISTICS: More Descriptive Choices
  • 3.1 Measures of Central Tendency
  • The Mean
  • The Median
  • The Mode
  • The Geometric Mean
  • 3.2 Measures of Variation and Shape
  • The Range
  • The Variance and the Standard Deviation
  • The Coefficient of Variation
  • Z Scores
  • Shape: Skewness
  • Shape: Kurtosis
  • 3.3 Exploring Numerical Variables
  • Quartiles
  • The Interquartile Range
  • The Five-Number Summary
  • The Boxplot
  • 3.4 Numerical Descriptive Measures for a Population
  • The Population Mean
  • The Population Variance and Standard Deviation
  • The Empirical Rule
  • Chebyshev's Theorem
  • 3.5 The Covariance and the Coefficient of Correlation
  • The Covariance
  • The Coefficient of Correlation
  • 3.6 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 Survey
  • Chapter 3 EXCEL GUIDE
  • EG3.1 Measures of Central Tendency
  • EG3.2 Measures of Variation and Shape
  • EG3.3 Exploring Numerical Variables
  • EG3.4 Numerical Descriptive Measures for a Population
  • EG3.5 The Covariance and the Coefficient of Correlation
  • Chapter 3 TABLEAU GUIDE
  • TG3.1 Exploring Numerical Variables
  • 4 Basic Probability
  • USING STATISTICS: Probable Outcomes at Fredco Warehouse Club
  • 4.1 Basic Probability Concepts
  • Events and Sample Spaces
  • Types of Probability
  • Summarizing Sample Spaces
  • Simple Probability
  • Joint Probability
  • Marginal Probability
  • General Addition Rule
  • 4.2 Conditional Probability
  • Calculating Conditional Probabilities
  • Decision Trees
  • Independence
  • Multiplication Rules
  • Marginal Probability Using the General Multiplication Rule
  • 4.3 Ethical Issues and Probability
  • 4.4 Bayes' Theorem
  • CONSIDER THIS: Divine Providence and Spam
  • 4.5 Counting Rules
  • USING STATISTICS: Probable Outcomes at Fredco Warehouse Club, 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 Survey
  • Chapter 4 EXCEL GUIDE
  • EG4.1 Basic Probability Concepts
  • EG4.2 Bayes' Theorem
  • 5 Discrete Probability Distributions
  • USING STATISTICS: Events of Interest at Ricknel Home Centers
  • 5.1 The Probability Distribution for a Discrete Variable
  • Expected Value of a Discrete Variable
  • Variance and Standard Deviation of a Discrete Variable
  • 5.2 Binomial Distribution
  • Histograms for Discrete Variables
  • Summary Measures for the Binomial Distribution.
  • 5.3 Poisson Distribution
  • 5.4 Covariance of a Probability Distribution and its Application in Finance
  • 5.5 Hypergeometric Distribution
  • USING STATISTICS: Events of Interest ..., 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 Binomial Distribution
  • EG5.3 Poisson Distribution
  • 6 The Normal Distribution and Other Continuous Distributions
  • USING STATISTICS: Normal Load Times at MyTVLab
  • 6.1 Continuous Probability Distributions
  • 6.2 The Normal Distribution
  • Role of the Mean and the Standard Deviation
  • Calculating Normal Probabilities
  • VISUAL EXPLORATIONS: Exploring the Normal Distribution
  • Finding X Values
  • CONSIDER THIS: What Is Normal?
  • 6.3 Evaluating Normality
  • Comparing Data Characteristics to Theoretical Properties
  • Constructing the Normal Probability Plot
  • 6.4 The Uniform Distribution
  • 6.5 The Exponential Distribution
  • 6.6 The Normal Approximation to the Binomial Distribution
  • USING STATISTICS: Normal Load Times ..., Revisited
  • SUMMARY
  • REFERENCES
  • KEY EQUATIONS
  • KEY TERMS
  • CHECKING YOUR UNDERSTANDING
  • CHAPTER REVIEW PROBLEMS
  • CASES FOR CHAPTER 6
  • Managing Ashland MultiComm Services
  • CardioGood Fitness
  • More Descriptive Choices Follow-Up
  • Clear Mountain State Student Survey
  • Digital Case
  • Chapter 6 EXCEL GUIDE
  • EG6.1 The Normal Distribution
  • EG6.2 Evaluating Normality
  • 7 Sampling Distributions
  • USING STATISTICS: Sampling Oxford Cereals
  • 7.1 Sampling Distributions
  • 7.2 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.

Similar Items