Introduction to Statistics Using Excel

著者名：縄田和満【著】

朝倉書店（2026/02発売）

• ISBN：9784254122626

内容説明

1996年の刊行より版を重ねる学部初級向け統計学テキスト『Excelによる統計入門』第4版をもとに完全英文化。Excel操作の初歩から，記述統計，推定・検定，回帰分析など統計学の基礎へ展開。留学生教育，講義の英語化に待望の書。

目次

1. Introduction to Excel
　1.1 How to Use Excel
　1.2 Input Data into Excel
　1.3 New Folders, Passwords, and Cloud
　1.4 Data Input Exercises

2. Spreadsheet Work in Excel
　2.1 Calculation of Sums of a Table
　2.2 Calculation of Ratios and Absolute Cell Address
　2.3 Drawing Ruled Lines
　2.4 Copying the Values of Cells
　2.5 Printing the Selected Range
　2.6 Exercise: Calculation of Portions of Regional Population and Population Growth Rates

3. Making Graphs
　3.1 Bar Chart
　3.2 Inserting a New Worksheet
　3.3 Pie Chart and Line Graph
　3.5 Exercises Using World Population Data

4. Inputting a Large Dataset
　4.1 Inputting Population Data of Countries
　4.2 Exercises on Calculating Population Densities and Population Growth Rates

5. Sorting the Data and Obtaining the Data Matching Criteria
　5.1 Sorting the Data
　5.2 Obtaining Data Matching the Criteria
　5.3 Summarizing the Data Matching Criteria Using Database Functions
　5.4 Exercises on Sorting and Obtaining Matched Data Using the Population Data

6 Analyzing the Data of One Variable Using the Frequency Table
　6.1 Frequency Table and Histogram
　6.2 Making a Frequency Table and Histogram Using the Population Data
　6.3 Exercises Using the Population Data of Countries

7. Locations and Scatter Scales of the Distribution of the Variable
　7.1 Locations of the Distribution
　7.2 Scatter Scales
　7.3 Calculation of Locations and Scatter Scales from the Frequency Table
　7.4 Calculation of Locations and Scatter Scales Using the Population Data
　7.5 Exercises Using the Population Data

8. Analysis of Two-Dimensional Data
　8.1 Scatter Diagram and Contingency Table
　8.2 Making a Scatter Diagram and Contingency Table from the Population Data
　8.3 Summarizing the Data with the PivotTablem
　8.4 Calculation of Correlation Coefficient
　8.5 Exercises Using the Countries’ Population Data

9. Macros and User-Defined Functions
　9.1 Making Macro and Running It
　9.2 User-Defined Functions
　9.3 Exercises on Making Macros and User-Defined Functions

10. Probability and Random Numbers
　10.1 Random Variables and Probability Distributions
　10.2 Law of Large Numbers and Central Limit Theorem
　10.3 Making Graphs of the Functions
　10.4 Simulations Using Random Numbers
　10.5 Exercises on Probability Distributions and Simulations Using Random Numbers

11. Estimation and Testing of the Normal Population
　11.1 Point Estimation and Interval Estimation
　11.2 Hypothesis Testing
　11.3 Test of Identity of Two Different Normal Populations (Two-Sample Test)
　11.4 Exercises Using the Population Data

12. Tests of Relationships between Two Variables in Two-Dimensional Data
　12.1 Test of Independence Using the χ2-Test of Goodness of Fit
　12.2 One-Way Layout ANOVA
　12.3 Tests Using the Correlation Coefficient
　12.4 Exercises Using the Population Data

13. Regression Analysis
　13.1 Simple Regression Analysis
　13.2 Least Squares Method
　13.3 Sample Distributions of Regression Coefficients and Hypothesis Testing
　13.4 Simple Regression Analysis Using the Population Data
　13.5 Multiple Regression Analysis
　13.6 Dummy Variables
　13.7 Multiple Regression Analysis Using the Population Data
　13.8 Exercises Using the Population Data

Referenses
Index