Basics of Statistics and Statistical Application with Excel（统计学基础及Excel统计应用） 下载 pdf 百度网盘 epub 免费 2025 电子版 mobi 在线

The edition of Basics of Statistics and Statistical Application with Excel emphasizes concepts of statistics,statistical methods are carefully presented with a focus on understanding both the suitability of the method and the meaning of the result.Statistical methods and measurements are developed in the context of applications.The text also introduces the application of statistical knowledge with Excel,which solving practical problems is intended for anyone looking to learn the basics of applying Excel’s powerful statistical tools to their business courses or work activities.

This book clearly and methodically shows and explains how to create and use these statistical tests to solve practical problems in business.Excel is an easily available computer program for students, instructors,and managers.It is also an effective teaching and learning tool for quantitative analyses in business courese.

Part Ⅰ Introduction of Basic Statistics1

1.1The Nature of Statistics1

1.1.1What Is Statistics?1

1.1.2Population and sample2

1.1.3Descriptive and Inferential Statistics3

1.1.4Parameters and Statistics4

1.1.5Statistical Data Analysis5

1.2Variables and Organization of the Data5

1.2.1Variables5

1.2.2Organization of the Data7

1.3Describe data by Tables and Graphs7

1.3.1Qualitative Variable7

1.3.2Quantitative Variable9

1.3.3Samples and Population Distributions14

1.4Measures of Center15

1.4.1The Mode15

1.4.2The Median17

1.4.3The Mean18

1.4.4Which Measure to Choose?19

1.5Measures of Variation19

1.5.1Range19

1.5.2Interquartile Range20

1.5.3Standard Deviation22

1.5.4Sample Statistics and Population Parameters24

1.6Probability Distributions and Normal Distributions25

1.6.1Probability Distributions25

1.6.2Mean and Standard Deviation of Random Variables28

1.6.3Normal Distributions29

1.7Sampling Distributions and Sample Means31

1.7.1Sampling Distributions31

1.7.2Sampling Distributions of Sample Means32

1.8Estimation35

1.8.1Point Estimation35

1.8.2Confidence Interval36

1.9Hypothesis Testing39

1.9.1Hypotheses39

1.9.2Significance Test for a Population Mean μ41

1.10Summarization of Bivariate Data44

1.10.1Qualitative Variables44

1.10.2Qualitative Variables and Quantitative Variables48

1.10.3Quantitative Variables52

1.11Scatterplot and Correlation Coefficient53

1.11.1Scatterplot53

1.11.2Correlation Coefficient54

Part Ⅱ Statistical Application with Excel58

2.1Sample Size,Mean,Standard Deviation,and Standard Error of the Mean58

2.1.1Mean58

2.1.2Standard Deviation59

2.1.3Standard Error of the Mean59

2.1.4Sample Size,Mean,Standard Deviation,and Standard Error of the Mean60

2.1.5Saving a Spreadsheet66

2.1.6Printing a Spreadsheet67

2.1.7Formatting Numbers in Currency Format（2 Decimal Places）68

2.1.8Formatting Numbers in Number Format（3 Decimal Places）69

2.1.9End-of-chapter Practice Problems69

2.2Random Number Generator71

2.2.1Creating Frame Numbers for Generating Random Numbers71

2.2.2Creating Random Numbers in an Excel Worksheet73

2.2.3Sorting Frame Numbers into a Random Sequence74

2.2.4Printing an Excel File So That All of the Information Fits onto One Page77

2.2.5End-of-chapter Practice Problems79

2.3Confidence Interval about the Mean by Using the TINV Function and Hypothesis Testing81

2.3.1Confidence Interval about the Mean81

2.3.2Hypothesis Testing90

2.3.3Alternative Ways to Summarize the Result of a Hypothesis Test100

2.3.4End-of-chapter Practice Problems101

2.4One-group t-test for the Mean105

2.4.1The 7 Steps for Hypothesis-testing by Using the One-group t-test105

2.4.2One-group t-test for the Mean109

2.4.3Can You Use Either the 95 Percent Confidence Interval about the Mean or the One-group t-test When Testing Hypothesis?112

2.4.4End-of-chapter Practice Problems113

2.5Two-group t-test of the Difference of the Means for Independent Groups116

2.5.1The 9 Steps for Hypothesis-testing by Using the Two-group t-test117

2.5.2Formula #1: Both Groups Have More Than 30 People in Them123

2.5.3Formula #2：One or Both Groups Have Fewer than 30 People in Them128

2.5.4End-of-chapter Practice Problems132

2.6Correlation and Simple Linear Regression135

2.6.1What Is a “Correlation”?135

2.6.2Using Excel to Compute a Correlation Between Two Variables141

2.6.3Creating a Chart and Drawing the Regression Line onto the Chart143

2.6.4Printing a Spreadsheet So That the Table and Chart Fit onto One Page150

2.6.5Finding the Regression Equation151

2.6.6Adding the Regression Equation to the Chart160

2.6.7How to Recognize Negative Correlations in the Summary Output Table161

2.6.8Printing Only Part of a Spreadsheet Instead of the Entire Spreadsheet162

2.6.9End-of-chapter Practice Problems165

2.7Multiple Correlation and Multiple Regression169

2.7.1Multiple Regression Equation169

2.7.2Finding the Multiple Correlation and the Multiple Regression Equation171

2.7.3Using the Regression Equation to Predict Annual Sales174

2.7.4Using Excel to Create a Correlation Matrix in Multiple Regression175

2.7.5End-of-chapter Practice Problems178

2.8One-way Analysis of Variance（ANOVA）183

2.8.1Using Excel to Perform a One-way Analysis of Variance（ANOVA）185

2.8.2How to Interpret the ANOVA Table Correctly?187

2.8.3Using the Decision Rule for the ANOVA F-test187

2.8.4Testing the Difference Between Two Groups by Using the ANOVA t-test188

2.8.5End-of-chapter Practice Problems193

Appendix199

TABLE 1 Table of Random Numbers199

TABLE 2 The Cumulative Standardized Normal Distribution202

TABLE 3 Critical Values of t205

TABLE 4 Critical Values of χ2208

TABLE 5Critical Values of F209

Reserences217

黎明，湖北工业大学，副教授，长期从事经营类统计学教学工作，本研究开始于2013年，湖北工业大学针对来华留学生（经管类）开设了统计学教学，针对留学生数学基础较弱的特点，教材的选取侧重了描述统计学部分，并加强了实际操作的练习。

暂无出版社相关信息，正在全力查找中！

暂无相关书籍摘录，正在全力查找中！

在线阅读地址：Basics of Statistics and Statistical Application with Excel（统计学基础及Excel统计应用）在线阅读

在线听书地址：Basics of Statistics and Statistical Application with Excel（统计学基础及Excel统计应用）在线收听

在线购买地址：Basics of Statistics and Statistical Application with Excel（统计学基础及Excel统计应用）在线购买

暂无原文赏析，正在全力查找中！

编辑推荐

《Basics of Statistics and Statistical Application with Excel》先讲理论，后讲统计学在excel中的应用，理论以必需够用为原则，具体应用介绍清晰、细致，实战技巧详实，理论实践结合，有利于读者掌握统计学以及excel中的相关知识。

前言

Welcome to the exciting world of statistics! We have written this book to make statistics accessible to everyone, including those with a limited mathematics background.Statistics affects all aspects of our lives.Whether we are testing new medical devices of determining what will entertain us, applications of statistics are so numerous that, in a sense, we are limited only by our own imagination in discovering new uses for statistics.

The edition of Basics of Statistics and Statistical Application with Excel continues to emphasize concepts of statistics.Statistical methods are carefully presented with a focus on understanding both the suitability of the method and the meaning of the result.Statistical methods and measurements are developed in the context of applications.

We have retained and expanded features that made the teaching materials used in Hubei University of Technology very readable.New procedure displays summarize steps for analyzing data.Examples, exercises, and problems touch on applications appropriate to a broad range of interests.Technology-based components give both students and researchers additional resources.

The book,which helps to solve practical problems, also introduces the application of statistical knowledge of Excel, and is intended for anyone reading it to learn the basics and apply Excel’s powerful statistical tools to their business courses or work activities.If understanding statistics isn’t your strongest suit, you are not especially mathematically-inclined, or if you are wary of computers, then this is the right book for you.

You will learn how to use key statistical tests using Excel without being overpowered by the underlying statistical theory.This book clearly and methodically shows and explains how to create and use these statistical tests to solve practical problems in business.Excel is an easily available computer program for students, instructors, and managers.It is also an effective teaching and learning tool for quantitative analyses in business courses.The powerful nume-rical computational ability and the graphical functions available in Excel make learning statistics much easier than in years past.

However, this is the first book to introduce the basics of statistics and the Excel application.We hope the Excel’s capabilities will be more effective to teach business statistics; it also focuses exclusively on this topic in an effort to render the subject matter not only applicable and practical, but also easy to comprehend and apply.

Ming Li

2019.12