Test Bank for Statistics for Managers Using Microsoft Excel 7th Edition by David M. Levine – Ebook PDF Instand Download/DeliveryISBN: 0133557782, 9780133557787
Full dowload Statistics for Managers Using Microsoft Excel 7th after payment
Product details:
ISBN-10 : 0133557782
ISBN-13 : 9780133557787
Author: David M. Levine
Intended primarily for undergraduate courses in business statistics, this text also provides practical content to current and aspiring industry professionals. 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. 0133130800 / 9780133130805 Statistics for Managers Using Microsoft Excel Plus MyStatLab — Access Card Package Package consists of: 0133061817 / 9780133061819 Statistics for Managers Using Microsoft Excel 0133074382 / 9780133074383 MyStatLab — Standalone Access Card — for Statistics for Managers Using Microsoft Excel
Statistics for Managers Using Microsoft Excel 7th Table of contents:
Chapter 1 Defining and Collecting Data
Learning Objectives
1.1 Establishing the Variable Type
Learn More
1.2 Measurement Scales for Variables
Nominal and Ordinal Scales
Learn More
Interval and Ratio Scales
Learn More
Problems for Sections 1.1 and 1.2
Learning the Basics
Applying the Concepts
1.3 Collecting Data
Data Sources
Learn More
Populations and Samples
Data Cleaning
Recoded Variables
Problems for Section 1.3
Applying the Concepts
1.4 Types of Sampling Methods
Simple Random Sample
Learn More
Systematic Sample
Stratified Sample
Learn More
Cluster Sample
Problems for Section 1.4
Learning the Basics
Applying the Concepts
1.5 Types of Survey Errors
Coverage Error
Nonresponse Error
Sampling Error
Measurement Error
Ethical Issues About Surveys
Problems for Section 1.5
Applying the Concepts
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
Sample Digital Case
EG1.1 Establishing the Variable Type
EG1.2 Measurement Scales for Variables
EG1.3 Collecting Data
Recoded Variables
Key Technique
Example
In-Depth Excel
EG1.4 Types of Sampling Methods
Simple Random Sample
Key Technique
Example
In-Depth Excel
Analysis ToolPak
Example
PHStat
In-Depth Excel
EG1.5 Types of Survey Errors
Chapter 2 Organizing and Visualizing Data
Learning Objectives
How to Proceed with This Chapter
2.1 Organizing Categorical Data
The Summary Table
Example 2.1 Summary Table of Levels of Risk of Retirement Funds
Solution
The Contingency Table
Problems for Section 2.1
Learning the Basics
Applying the Concepts
2.2 Organizing Numerical Data
Stacked and Unstacked Data
The Ordered Array
The Frequency Distribution
Determining the Class Interval Width
Example 2.2 Frequency Distributions of the Three-Year Return Percentages for Growth and Value Funds
Solution
Classes and Excel Bins
The Relative Frequency Distribution and the Percentage Distribution
Computing the Proportion or Relative Frequency
Example 2.3 Relative Frequency Distributions and Percentage Distributions of the Three-Year Return Percentage for Growth and Value Funds
Solution
The Cumulative Distribution
Example 2.4 Cumulative Percentage Distributions of the Three-Year Return Percentage for Growth and Value Funds
Solution
Problems for Section 2.2
Learning the Basics
Applying the Concepts
2.3 Visualizing Categorical Data
The Bar Chart
Example 2.5 Bar Chart of Levels of Risk of Retirement Funds
Solution
The Pie Chart
Example 2.6 Pie Chart of Levels of Risk of Bond Retirement Funds
Solution
The Pareto Chart
Example 2.7 Pareto Chart of What Bosses Demand During Vacation Time
Solution
The Side-by-Side Bar Chart
Problems for Section 2.3
Applying the Concepts
2.4 Visualizing Numerical Data
The Stem-and-Leaf Display
Example 2.8 Stem-and-Leaf Display of the Three-Year Return Percentage for the Value Funds
Solution
The Histogram
Example 2.9 Histograms of the Three-Year Return Percentages for the Growth and Value Funds
Solution
The Percentage Polygon
Example 2.10 Percentage Polygons of the Three-Year Return Percentage for the Growth and Value Funds
Solution
The Cumulative Percentage Polygon (Ogive)
Example 2.11 Cumulative Percentage Polygons of the Three-Year Return Percentages for the Growth and Value Funds
Solution
Problems for Section 2.4
Learning the Basics
Applying the Concepts
2.5 Visualizing Two Numerical Variables
The Scatter Plot
Example 2.12 Scatter Plot for NBA Investment Analysis
Solution
Learn More
The Time-Series Plot
Example 2.13 Time-Series Plot for Movie Revenues
Solution
Problems for Section 2.5
Learning the Basics
Applying the Concepts
2.6 Challenges in Visualizing Data
Chartjunk
Guidelines for Developing Visualizations
Problems for Section 2.6
Applying the Concepts
2.7 Organizing and Visualizing Many Variables
Multidimensional Contingency Tables
Adding Numerical Variables
Drill-down
Problems for Section 2.7
Applying the Concepts
2.8 PivotTables and Business Analytics
Real-World Business Analytics and Microsoft Excel
Problems for Section 2.8
Applying the Concepts
Summary
References
Key Equations
Determining the Class Interval Width
Computing the Proportion or Relative Frequency
Key Terms
Checking Your Understanding
Chapter Review Problems
Report Writing Exercises
Cases for Chapter 2
Managing Ashland MultiComm Services
Digital Case
CardioGood Fitness
The Choice Is Yours Follow-up
Clear Mountain State Student Surveys
EG2.1 Organizing Categorical Data
The Summary Table
Key Technique
Example
PHStat
In-Depth Excel
In-Depth Excel
The Contingency Table
Key Technique
Example
PHStat
In-Depth Excel
In-Depth Excel
EG2.2 Organizing Numerical Data
Stacked and Unstacked Data
PHStat
The Ordered Array
In-Depth Excel
The Frequency Distribution
PHStat
In-Depth Excel
Analysis ToolPak
The Relative Frequency, Percentage, and Cumulative Distributions
PHStat
In-Depth Excel
Analysis ToolPak
EG2.3 Visualizing Categorical Data
The Bar Chart and the Pie Chart
PHStat
In-Depth Excel
The Pareto Chart
PHStat
In-Depth Excel
The Side-by-Side Chart
PHStat
In-Depth Excel
EG2.4 Visualizing Numerical Data
The Stem-and-Leaf Display
PHStat
In-Depth Excel
The Histogram
PHStat
In-Depth Excel
Analysis ToolPak
The Percentage Polygon and the Cumulative Percentage Polygon (Ogive)
PHStat
In-Depth Excel
EG2.5 Visualizing Two Numerical Variables
The Scatter Plot
PHStat
In-Depth Excel
The Time-Series Plot
In-Depth Excel
EG2.6 Challenges in Visualizing Data
EG2.7 Organizing and Visualizing Many Variables
Multidimensional Contingency Tables
In-Depth Excel
Adding Numerical Variables
Key Technique
Example
In-Depth Excel
EG2.8 PivotTables and Business Analytics
Chapter 3 Numerical Descriptive Measures
Learning Objectives
3.1 Central Tendency
The Mean
Sample Mean
Example 3.1 The Mean Calories in Cereals
Solution
The Median
Median
Example 3.2 Computing the Median from an Odd-Sized Sample
Solution
The Mode
Example 3.3 Determining the Mode
Solution
The Geometric Mean
Geometric Mean
Geometric Mean Rate of Return
Example 3.4 Computing the Geometric Mean Rate of Return
Solution
3.2 Variation and Shape
The Range
Range
Example 3.5 Computing the Range in the Calories in Cereals
Solution
The Variance and the Standard Deviation
Sample Variance
Sample Standard Deviation
Example 3.6 Computing the Variance and Standard Deviation of the Number of Calories in Cereals
Solution
The Coefficient of Variation
Learn More
Coefficient of Variation
Example 3.7 Comparing Two Coefficients of Variation When the Two Variables Have Different Units of Measurement
Solution
Z Scores
Z Score
Example 3.8 Computing the Z Scores of the Number of Calories in Cereals
Solution
Shape: Skewness and Kurtosis
Example 3.9 Descriptive Statistics for Growth and Value Funds
Solution
Problems for Sections 3.1 and 3.2
Learning the Basics
Applying the Concepts
3.3 Exploring Numerical Data
Quartiles
First Quartile, Q1
Third Quartile, Q3
Example 3.10 Computing the Quartiles
Solution
The Interquartile Range
Interquartile Range
Example 3.11 Computing the Interquartile Range for the Number of Calories in Cereals
Solution
The Five-Number Summary
Five-Number Summary
Example 3.12 Computing the Five-Number Summary of the Number of Calories in Cereals
Solution
The Boxplot
Example 3.13 Boxplots of the Three-Year Returns for the Growth and Value Funds
Solution
Problems for Section 3.3
Learning the Basics
Applying the Concepts
3.4 Numerical Descriptive Measures for a Population
The Population Mean
Population Mean
The Population Variance and Standard Deviation
Population Variance
Population Standard Deviation
The Empirical Rule
Example 3.14 Using the Empirical Rule
Solution
The Chebyshev Rule
Example 3.15 Using the Chebyshev Rule
Solution
Problems for Section 3.4
Learning the Basics
Applying the Concepts
3.5 The Covariance and the Coefficient of Correlation
The Covariance
Sample Covariance
Example 3.16 Computing the Sample Covariance
Solution
The Coefficient of Correlation
Sample Coefficient of Correlation
Example 3.17 Computing the Sample Coefficient of Correlation
Solution
Problems for Section 3.5
Learning the Basics
Applying the Concepts
3.6 Descriptive Statistics: Pitfalls and Ethical Issues
Using Statistics More Descriptive Choices, Revisited
Summary
References
Key Equations
Sample Mean
Median
Geometric Mean
Geometric Mean Rate of Return
Range
Sample Variance
Sample Standard Deviation
Coefficient of Variation
Z Score
First Quartile, Q1
Third Quartile, Q3
Interquartile Range
Population Mean
Population Variance
Population Standard Deviation
Sample Covariance
Sample Coefficient of Correlation
Key Terms
Checking Your Understanding
Chapter Review Problems
Cases for Chapter 3 Managing Ashland MultiComm Services
Digital Case Apply your knowledge about the proper use of numerical descriptive measures in this continuing Digital Case from Chapter 2.
CardioGood Fitness
More Descriptive Choices Follow-up
Clear Mountain State Student Surveys
EG3.1 Central Tendency
The Mean, Median, and Mode
Key Technique
Example
PHStat
In-Depth Excel
Analysis ToolPak
The Geometric Mean
Key Technique
Example
In-Depth Excel
EG3.2 Variation and Shape
The Range
Key Technique
Example
PHStat
In-Depth Excel
The Variance, Standard Deviation, Coefficient of Variation, and Z Scores
Key Technique
Example
PHStat
In-Depth Excel
Analysis ToolPak
Shape: Skewness and Kurtosis
Key Technique
Example
PHStat
In-Depth Excel
Analysis ToolPak
EG3.3 Exploring Numerical Data
Quartiles
Key Technique
Example
PHStat
In-Depth Excel
The Interquartile Range
Key Technique
Example
In-Depth Excel
The Five-Number Summary and the Boxplot
Key Technique
Example
PHStat
In-Depth Excel
EG3.4 Numerical Descriptive Measures for a Population
The Population Mean, Population Variance, and Population Standard Deviation
Key Technique
Example
In-Depth Excel
The Empirical Rule and the Chebyshev Rule
EG3.5 The Covariance and the Coefficient of Correlation
The Covariance
Key Technique
Example
In-Depth Excel
The Coefficient of Correlation
Key Technique
Example
In-Depth Excel
Chapter 4 Basic Probability
Learning Objectives
4.1 Basic Probability Concepts
Probability of Occurrence
Example 4.1 Finding A Priori Probabilities
Solution
Events and Sample Spaces
Example 4.2 Events and Sample Spaces
Solution
Contingency Tables
Simple Probability
Example 4.3 Computing the Probability That the Large-Screen HDTV Purchased Had a Faster Refresh Rate
Solution
Joint Probability
Example 4.4 Determining the Joint Probability That a Household Purchased a Large-Screen HDTV with a Faster Refresh Rate and Purchased a Streaming Media Box
Solution
Marginal Probability
Marginal Probability
General Addition Rule
General Addition Rule
Example 4.5 Using the General Addition Rule for the Households That Purchased Large-Screen HDTVs
Solution
Problems for Section 4.1
Learning the Basics
Applying the Concepts
4.2 Conditional Probability
Computing Conditional Probabilities
Conditional Probability
Example 4.6 Finding the Conditional Probability of Purchasing a Streaming Media Box
Solution
Decision Trees
Example 4.7 Constructing the Decision Tree for the Households That Purchased Large-Screen HDTVs
Solution
Independence
Independence
Example 4.8 Determining Independence
Solution
Multiplication Rules
General Multiplication Rule
Example 4.9 Using the General Multiplication Rule
Solution
Multiplication Rule for Independent Events
Marginal Probability Using the General Multiplication Rule
Marginal Probability Using the General Multiplication Rule
Problems for Section 4.2
Learning the Basics
Applying the Concepts
4.3 Bayes’ Theorem
Bayes’ Theorem
Example 4.10 Using Bayes’ Theorem in a Medical Diagnosis Problem
Solution
Problems for Section 4.3
Learning the Basics
Applying the Concepts
4.4 Ethical Issues and Probability
4.5 Counting Rules (online)
Learn More
Summary
References
Key Equations
Probability of Occurrence
Marginal Probability
General Addition Rule
Conditional Probability
Independence
General Multiplication Rule
Multiplication Rule for Independent Events
Marginal Probability Using the General Multiplication Rule
Bayes’ Theorem
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
EG4.1 Basic Probability Concepts
Simple and Joint Probability and the General Addition Rule
PHStat2
In-Depth Excel
EG4.2 Conditional Probability
EG4.3 Bayes’ Theorem
Chapter 5 Discrete Probability Distributions
Learning Objectives
5.1 The Probability Distribution for a Discrete Variable
Expected Value of a Discrete Variable
Expected Value, μ of a Discrete Variable
Variance and Standard Deviation of a Discrete Variable
Variance of a Discrete Variable
Standard Deviation of a Discrete Variable
Problems for Section 5.1
Learning the Basics
Applying the Concepts
5.2 Covariance of a Probability Distribution and Its Application in Finance
Covariance
Covariance
Expected Value, Variance, and Standard Deviation of the Sum of Two Variables
Portfolio Expected Return and Portfolio Risk
Portfolio Expected Return
Portfolio Risk
Example 5.1 Computing the Expected Return, the Standard Deviation of the Return, and the Covariance of Two Investment Strategies
Solution
Problems for Section 5.2
Learning the Basics
Applying the Concepts
5.3 Binomial Distribution
Properties of the Binomial Distribution
Combinations
Binomial Distribution
Example 5.2 Determining P(X = 3), Given n = 4 and π = 0.1
Solution
Example 5.3 Determining P(X ≥ 3 Given n = 4 and π = 0.1
Solution
Example 5.4 Determining P(X < 3), Given n = 4 and π = 0.1
Solution
Learn More
Mean of the Binomial Distribution
Standard Deviation of the Binomial Distribution
Example 5.5 Computing Binomial Probabilities for Service at a Fast-Food Restaurant
Solution
Problems for Section 5.3
Learning the Basics
Applying the Concepts
5.4 Poisson Distribution
Poisson Distribution
Learn More
Example 5.6 Computing Poisson Probabilities
Solution
Problems for Section 5.4
Learning the Basics
Applying the Concepts
5.5 Hypergeometric Distribution
Hypergeometric Distribution
Example 5.7 Computing Hypergeometric Probabilities
Solution
Problems for Section 5.5
Learning the Basics
Applying the Concepts
Summary
References
Key Equations
Expected Value, μ, of a Discrete Variable
Variance of a Discrete Variable
Standard Deviation of a Discrete Variable
Covariance
Expected Value of the Sum of Two Variables
Variance of the Sum of Two Variables
Standard Deviation of the Sum of Two Variables
Portfolio Expected Return
Portfolio Risk
Combinations
Binomial Distribution
Mean of the Binomial Distribution
Standard Deviation of the Binomial Distribution
Poisson Distribution
Hypergeometric Distribution
Mean of the Hypergeometric Distribution
Standard Deviation of the Hypergeometric Distribution
Key Terms
Checking Your Understanding
Chapter Review Problems
Cases for Chapter 5 Managing Ashland MultiComm Services
Digital Case
EG5.1 The Probability Distribution for a Discrete Variable
Key Technique
Example
In-Depth Excel
EG5.2 Covariance of a Probability Distribution and Its Application in Finance
Key Technique
Example
PHStat
In-Depth Excel
EG5.3 Binomial Distribution
Key Technique
Example
PHStat
In-Depth Excel
EG5.4 Poisson Distribution
Key Technique
Example
PHStat2
In-Depth Excel
EG5.5 Hypgeometric Distribution
Key Technique
Example
PHStat
In-Depth Excel
Chapter 6 The Normal Distribution and Other Continuous Distributions
People also search for Statistics for Managers Using Microsoft Excel 7th:
statistics test bank
test bank statement pdf
test bank macroeconomics
test bank definition
ap statistics test bank
Reviews
There are no reviews yet.