应用统计分析 使用EXCEL 英文版2025|PDF|Epub|mobi|kindle电子书版本百度云盘下载

应用统计分析 使用EXCEL 英文版PDF格式电子书版下载

注意：本站所有压缩包均有解压码： 点击下载压缩包解压工具

1 WHAT IS STATISTICS?1

1.1 Introduction2

1.2 Key Statistical Concepts6

1.3 Statistics and the Computer7

1.4 World Wide Web and Learning Center7

APPENDIX 1.A:Introduction to Microsoft Excel10

2 GRAPHICAL DESCRIPTIVE TECHNIQUES15

2.1 Introduction16

2.2 Types of Data16

2.3 Graphically Describing Interval Data:Frequency Distributions and Histograms20

2.4 Graphically Describing Nominal Data:Bar and Pie Charts33

2.5 Describing Time-Series Data:Line Charts38

2.6 Describing the Relationship between Two Interval Variables:Scatter Diagrams42

2.7 Summary49

3 NUMERICAL DESCRIPTIVE TECHNIQUES FOR INTERVAL DATA52

3.1 Introduction53

3.2 Measures of Central Location54

3.3 Measures of Variability60

3.4 Other Measures of Shape(Optional)70

3.5 Measures of Relative Standing and Box Plots71

3.6 Measures of Linear Relationship76

3.7 General Guidelines for Exploring Data84

3.8 Summary85

4 PROBABILITY89

4.1 Introduction90

4.2 Assigning Probability to Events90

4.3 Joint,Marginal,and Conditional Probability95

4.4 Probability Rules and Trees103

4.5 Summary113

CASE 4.1 Let's Make a Deal116

CASE 4.2 To Bunt or Not to Bunt,That Is the Question116

5 RANDOM VARIABLES AND DISCRETE PROBABILITY DISTRIBUTIONS118

5.1 Introduction119

5.2 Random Variables and Probability Distributions119

5.3 Describing the Population/Probability Distribution124

5.4 Binomial Distribution128

5.5 Poisson Distribution136

5.6 Summary141

CASE 5.1 To Bunt or Not to Bunt,That Is the Question,Part Ⅱ145

6 CONTINUOUS PROBABILITY DISTRIBUTIONS146

6.1 Introduction147

6.2 Probability Density Functions147

6.3 Normal Distribution153

6.4 Other Continuous Distributions170

6.5 Summary187

7 SAMPLING AND SAMPLING PLANS188

7.1 Introduction189

7.2 Sampling189

7.3 Sampling Plans191

7.4 Errors Involved in Sampling196

7.5 Summary198

8 SAMPLING DISTRIBUTIONS199

8.1 Introduction200

8.2 Sampling Distribution of the Mean200

8.3 Creating the Sampling Distribution by Computer Simulation(Optional)212

8.4 Sampling Distribution of a Proportion215

8.5 Sampling Distribution of the Difference between Two Means220

8.6 From Here to Inference223

8.7 Summary224

9 INTRODUCTION TO ESTIMATION227

9.1 Introduction228

9.2 Concepts of Estimation228

9.3 Estimating the Population Mean when the Population Standard Deviation Is Known232

9.4 Selecting the Sample Size245

9.5 Simulation Experiments(Optional)247

9.6 Summary250

10 INTRODUCTION TO HYPOTHESIS TESTING253

10.1 Introduction254

10.2 Concepts of Hypothesis Testing255

10.3 Testing the Population Mean when the Population Standard Deviation Is Known257

10.4 Calculating the Probability of a Type Ⅱ Error279

10.5 The Road Ahead288

10.6 Summary291

11 INFERENCE ABOUT A SINGLE POPULATION293

11.1 Introduction294

11.2 Inference about a Population Mean when the Standard Deviation Is Unknown295

11.3 Inference about a Population Variance305

11.4 Inference about a Population Proportion311

11.5 Summary323

CASE 11.1 Pepsi's Exclusivity Agreement with a University327

CASE 11.2 Pepsi's Exclusivity Agreement with a University:The Coke Side of the Equation328

CASE 11.3 Number of Uninsured Motorists328

12 INFERENCE ABOUT TWO POPULATIONS330

12.1 Introduction331

12.2 Inference about the Difference between Two Means:Independent Samples332

12.3 Observational and Experimental Data348

12.4 Inference about the Difference between Two Means:Matched Pairs Experiment349

12.5 Inference about the Ratio of Two Variances361

12.6 Inference about the Difference between Two Population Proportions367

12.7 Summary378

CASE 12.1 Bonanza International386

CASE 12.2 Accounting Course Exemptions387

13 STATISTICAL INFERENCE:REVIEW OF CHAPTERS 11 AND 12388

13.1 Introduction389

13.2 Guide to Identifying the Correct Technique:Chapters 11 and 12389

CASE 13.1 Quebec Separation:Oui ou non?403

CASE 13.2 Host Selling and Announcer Commercials403

14 ANALYSIS OF VARIANCE405

14.1 Introduction406

14.2 Single-Factor(One-Way) Analysis of Variance:Independent Samples407

14.3 Analysis of Variance Experimental Designs423

14.4 Single-Factor Analysis of Variance:Randomized Blocks425

14.5 Two-Factor Analysis of Variance:Independent Samples434

14.6 Multiple Comparisons449

14.7 Bartlett's Test455

14.8 Summary457

15 CHI-SQUARED TESTS464

15.1 Introduction465

15.2 Chi-Squared Goodness-of-Fit Test465

15.3 Chi-Squared Test of a Contingency Table472

15.4 Summary of Tests on Nominal Data482

15.5 Chi-Squared Test for Normality484

15.6 Summary489

CASE 15.1 Predicting the Outcomes of Basketball,Baseball,Football,and Hockey Games from Intermediate Results493

CASE 15.2 Can Exposure to a Code of Professional Ethics Help Make Managers More Ethical?494

16 NONPARAMETRIC STATISTICAL TECHNIQUES496

16.1 Introduction497

16.2 Wilcoxon Rank Sum Test499

16.3 Sign Test and Wilcoxon Signed Rank Sum Test511

16.4 Kruskal-WallisTest524

16.5 Friedman Test529

16.6 Summary535

17 SIMPLE LINEAR REGRESSION AND CORRELATION542

17.1 Introduction543

17.2 Model544

17.3 Estimating the Coefficients546

17.4 Error Variable:Required Conditions552

17.5 Assessing the Model555

17.6 Using the Regression Equation564

17.7 Coefficients of Correlation568

17.8 Regression Diagnostics Ⅰ574

17.9 Summary580

CASE 17.1 Predicting University Grades from High School Grades585

CASE 17.2 Insurance Compensation for Lost Revenues586

18 MULTIPLE REGRESSION588

18.1 Introduction589

18.2 Model and Required Conditions589

18.3 Estimating the Coefficients and Assessing the Model590

18.4 Regression Diagnostics Ⅱ605

18.5 Regression Diagnostics Ⅲ (Time Series)612

18.6 Nominal IndependentVariables623

18.7 Summary630

CASE 18.1 Quebec Referendum Vote:Was There Electoral Fraud?634

CASE 18.2 Quebec Referendum Vote:The Rebuttal635

19 STATISTICAL INFERENCE:CONCLUSION636

19.1 Introduction637

19.2 Identifying the Correct Technique:Summary of Statistical Inference637

CASE 19.1 Do Banks Discriminate against Women Business Owners? Ⅰ644

CASE 19.2 Do Banks Discriminate against Women Business Owners? Ⅱ647

19.3 The Last Word653

CASE 19.3 Ambulance and Fire Department Response Interval Study665

CASE 19.4 PC Magazine Survey666

CASE 19.5 WLU Graduate Survey667

CASE 19.6 Evaluation of a New Antidepressant Drug668

CASE 19.7 Nutrition Education Programs669

CASE 19.8 Do Banks Discriminate against Women Business Owners? Ⅲ670