9781461473800-t1 - Contents Preface xiii Acknowledgements xiv Chapter 1 1.1 1.2 1.3 1.4 Chapter 2 2.1 2.2 2.3 2.4 2.5 2.6 2.7 2.8 2.9 2.10 Excel 2.1

9781461473800-t1 - Contents Preface xiii Acknowledgements...

This preview shows page 1 - 3 out of 8 pages.

v Contents Preface ......................................................................................................................................... xiii Acknowledgements .................................................................................................................... xiv Chapter 1 Statistics for Decision Making and Competitive Advantage ............................... 1 1.1 Statistical Competences Translate into Competitive Advantages ......................................... 1 1.3 Use Excel for Competitive Advantage ................................................................................. 2 1.4 Statistical Competence Is Powerful and Yours ..................................................................... 3 Chapter 2 escribing Your Data ............................................................................................. 5 D 2.1 Describe Data with Summary Statistics and Histograms ...................................................... 5 2.2 Round Descriptive Statistics ................................................................................................. 9 2.3 Share the Story that Your Graphics Illustrate ....................................................................... 9 2.4 Data Is Measured with Quantitative or Categorical Scales ................................................... 9 2.5 Continuous Data Are Sometimes Normal ........................................................................... 11 2.6 The Empirical Rule Simplifies Description ........................................................................ 11 2.7 Outliers Can Distort the Picture .......................................................................................... 13 2.8 Central Tendency, Dispersion and Skewness Describe Data .............................................. 14 2.9 Describe Categorical Variables Graphically: Column and PivotCharts ............................. 14 2.10 Descriptive Statistics Depend on the Data and Rely on Your Packaging ........................... 15 Excel 2.1 Produce Descriptive Statistics ............................................................................................. 17 Excel 2.2 Sort to Produce Descriptives Without Outliers ................................................................... 19 Excel 2.3 Make a Histogram ............................................................................................................... 21 Excel 2.4 Use a PivotTable to Plot the Distribution ........................................................................... 23 Excel 2.5 Plot a Cumulative Distribution ........................................................................................... 26 Excel 2.6 Produce a Column Chart of a Nominal Variable ................................................................ 28 Excel Shortcuts at Your Fingertips ..................................................................................... 31 Significant Digits Guidelines .............................................................................................. 34 Lab 2 Descriptive Statistics ................................................................................................ 35 Assignment 2-1 Procter & Gamble’s Global Advertising .................................................. 37 Assignment 2-2 Best Practices Survey ............................................................................... 37 Assignment 2-3 Shortcut Challenge ................................................................................... 38 CASE 2-1 VW Backgrounds .............................................................................................. 38 1.2 The Path Toward Statistical Competence and Competitive Advantage ............................... 2
Image of page 1
Chapter 3 Hypothesis Tests, Confidence Intervals to Infer Population Characteristics and Differences ........................................................................... 39 3.1 Sample Means Are Random Variables ............................................................................... 39 3.2 Infer Whether a Population Mean Exceeds a Target .......................................................... 43 3.3 Critical t Provides a Benchmark ......................................................................................... 45 3.4 Confidence Intervals Estimate the Population Mean .......................................................... 46 3.5 Calculate Approximate Confidence Intervals with Mental Math ....................................... 48 3.6 Margin of Error Is Inversely Proportional to Sample Size ................................................. 48 3.7 Determine Whether Two Segments Differ with Student t .................................................. 49 3.8 Estimate the Extent of Difference Between Two Segments ............................................... 53 3.9 Estimate a Population Proportion from a Sample Proportion ............................................. 54 3.10 Conditions for Assuming Approximate Normality ............................................................. 56 3.11 Conservative Confidence Intervals for a Proportion ........................................................... 56 3.12 Assess the Difference Between Alternate Scenarios or Pairs ............................................. 58 3.13 Inference from Sample to Population ................................................................................. 61 Excel 3.1 Test the Level of a Population Mean with a One Sample t test .......................................... 63 Excel 3.2 Make a Confidence Interval for a Population Mean ........................................................... 63 Excel 3.3 Illustrate Confidence Intervals with Column Charts ........................................................... 64 Excel 3.4 Test Difference Between Two Segment Means with a Two Sample t test ......................... 67 Excel 3.5 Construct a Confidence Interval for the Difference Between Two Segments .................... 67 Excel 3.6 Illustrate the Difference Between Two Segment Means with Column Chart .................... 68 Excel 3.7 Construct a Pie Chart of Shares .......................................................................................... 69 Excel 3.8 Test the Difference in Between Alternate Scenarios or Pairs with a Paired t test .............. 72 Excel 3.9 Construct a Confidence Interval for the Difference Between Alternate Scenarios or Pairs ............................................................................................................... 72 Lab Practice 3 Inference ..................................................................................................... 75 Cingular’s Position in the Cell Phone Service Market . ...................................................... 75 Value of a Nationals Uniform ............................................................................................. 75
Image of page 2
Image of page 3

You've reached the end of your free preview.

Want to read all 8 pages?

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture