统计学基础及Excel统计应用(英文版) 化学工业出版社 下载 pdf 百度网盘 epub 免费 2025 电子版 mobi 在线

本书首先介绍了统计学基本理论和方法，在此基础上重点讲解了使用计算机通用软件Excel进行统计分析的方法、步骤以及操作技巧。本书英文叙述原汁原味，是针对在我国留学的外国留学生编写的英文教材。书中主要介绍了应用Excel软件进行数据统计分析的基本操作方法以及操作技巧。

Part Ⅰ Introduction of Basic Statistics

1.1 The Nature of Statistics

1.1.1 What Is Statistics?

1.1.2 Population and sample

1.1.3 Deive and Inferential Statistics

1.1.4 Parameters and Statistics

1.1.5 Statistical Data Analysis

1.2 Variables and Organization of the Data

1.2.1 Variables

1.2.2 Organization of the Data

1.3 Describe data by Tables and Graphs

1.3.1 Qualitative Variable

1.3.2 Quantitative Variable

1.3.3 Samples and Population Distributions

1.4 Measures of Center

1.4.1 The Mode

1.4.2 The Median

1.4.3 The Mean

1.4.4 Which Measure to Choose?

1.5 Measures of Variation

1.5.1 Range

1.5.2 Interquartile Range

1.5.3 Standard Deviation

1.5.4 Sample Statistics and Population Parameters

1.6 Probability Distributions and Normal Distributions

1.6.1 Probability Distributions

1.6.2 Mean and Standard Deviation of Random Variables

1.6.3 Normal Distributions

1.7 Sampling Distributions and Sample Means

1.7.1 Sampling Distributions

1.7.2 Sampling Distributions of Sample Means

1.8 Estimation

1.8.1 Point Estimation

1.8.2 Confidence Interval

1.9 Hypothesis Testing

1.9.1 Hypotheses

1.9.2 Significance Test for a Population Mean μ

1.10 Summarization of Bivariate Data

1.10.1 Qualitative Variables

1.10.2 Qualitative Variables and Quantitative Variables

1.10.3 Quantitative Variables

1.11 Scatterplot and Correlation Coefficient

1.11.1 Scatterplot

1.11.2 Correlation Coefficient

Part Ⅱ Statistical Application with Excel

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

2.1.1 Mean

2.1.2 Standard Deviation

2.1.3 Standard Error of the Mean

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

2.1.5 Saving a Spreadsheet

2.1.6 Printing a Spreadsheet

2.1.7 Formatting Numbers in Currency Format (2 Decimal Places)

2.1.8 Formatting Numbers in Number Format (3 Decimal Places)

2.1.9 End-of-chapter Practice Problems

2.2 Random Number Generator

2.2.1 Creating Frame Numbers for Generating Random Numbers

2.2.2 Creating Random Numbers in an Excel Worksheet

2.2.3 Sorting Frame Numbers into a Random Sequence

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

2.2.5 End-of-chapter Practice Problems

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

2.3.1 Confidence Interval about the Mean

2.3.2 Hypothesis Testing

2.3.3 Alternative Ways to Summarize the Result of a Hypothesis Test

2.3.4 End-of-chapter Practice Problems

2.4 One-group t-test for the Mean

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

2.4.2 One-group t-test for the Mean

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

2.4.4 End-of-chapter Practice Problems

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

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

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

2.5.3 Formula #2: One or Both Groups Have Fewer than 30 People in Them

2.5.4 End-of-chapter Practice Problems

2.6 Correlation and Simple Linear Regression

2.6.1 What Is a "Correlation"?

2.6.2 Using Excel to Compute a Correlation Between Two Variables

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

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

2.6.5 Finding the Regression Equation

2.6.6 Adding the Regression Equation to the Chart

2.6.7 How to Recognize Negative Correlations in the Summary Output Table

2.6.8 Printing Only Part

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

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

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

在线阅读地址：统计学基础及Excel统计应用(英文版) 化学工业出版社在线阅读

在线听书地址：统计学基础及Excel统计应用(英文版) 化学工业出版社在线收听

在线购买地址：统计学基础及Excel统计应用(英文版) 化学工业出版社在线购买

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

编辑推荐

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

媒体评论

暂无