| Description |
xv, 160 pages : illustrations ; 24 cm |
| Contents |
Contents note continued: 3.4.Example: Statistical Functions in Spreadsheets -- 3.5.Data Type and Descriptive Statistics -- 3.5.1.Data Types -- 3.5.2.Descriptive Statistics and Type of Data -- 4.The Normal Distribution -- 4.1.Characteristics of the Normal Distribution -- 4.2.Density Function and Distribution Function -- 4.3.Fractiles -- 4.4.Calculations in the Normal Distribution -- 4.5.The Normal Distribution and Spreadsheets -- 4.5.1.NORMDIST (X; Mean; Stdev; Cumulative) -- 4.5.2.NORMINV (Probability; Mean; Stdev) -- 4.5.3.Example -- 4.6.Testing for the Normal Distribution -- 4.6.1.Simple Methods -- 4.6.2.Skewness and Kurtosis -- 4.6.3.Normal Plot -- 4.7.Random Numbers -- 4.8.Confidence Intervals -- 4.8.1.Confidence Interval for the Mean -- 4.8.2.Confidence Interval for the Mean in Case of a Small Sample -- 4.8.3.Confidence Interval for the Standard Deviation -- 4.9.More About the Normal Distribution -- 5.Analysis of Qualitative Data -- 5.1.The Binomial Distribution -- |
|
Contents note continued: 5.1.1.Example -- 5.2.The Binomial Distribution and the Normal Distribution -- 5.3.The Binomial Distribution in Spreadsheets -- 5.3.1.Example -- 5.4.Statistical Uncertainty in Sample Surveys -- 5.4.1.Example -- 5.5.Is the Sample Representative? -- 5.6.Statistical Tests -- 5.6.1.Example -- 5.6.2.Approximation with the Normal Distribution -- 5.6.3.Significance Level -- 5.6.4.Statistical Test or Confidence Interval -- 5.7.Frequency Tables -- 5.7.1.Introduction to Chi-Squared Test -- 5.7.2.Confidence Interval for Difference Between Two Proportions -- 5.7.3.Several Rows and/or Columns -- 5.7.4.Calculations in Spreadsheets -- 5.7.5.Calculations by Calculator -- 6.Error Sources and Planning -- 6.1.Two Kinds of Errors -- 6.2.Random Error and Sample Size -- 6.2.1.A Qualitative Variable -- 6.2.2.A Quantitative Variable -- 6.3.Bias (Systematic Errors) -- 6.3.1.Errors in the Sampling (Sample Selection) -- 6.3.2.Errors in the Definition of the Sample -- |
|
Contents note continued: 6.3.3.What Is a Representative Sample? -- 6.4.Sampling (Sample Selection) -- 6.4.1.Simple Random Sampling -- 6.4.2.Stratified Sampling -- 6.4.3.Cluster Sampling -- 6.4.4.Systematic Sampling -- 6.4.5.Quota Sampling -- 6.4.6.Purposive Sampling -- 6.4.7.Convenience Sampling -- 7.Assessment of Relationship -- 7.1.Example -- 7.2.Linear Regression with Spreadsheets -- 7.3.Is There a Relationship? -- 7.3.1.Note -- 7.4.Multiple Linear Regression -- 7.5.Final Remarks -- 8.Comparing Two Groups -- 8.1.Matched Pairs: The Paired t-Test -- 8.1.1.Example -- 8.1.2.Description -- 8.1.3.Calculation -- 8.1.4.Spreadsheets -- 8.2.Comparing Two Groups Means -- 8.2.1.Example -- 8.2.2.Description -- 8.2.3.Calculation -- 8.2.4.Spreadsheets -- 8.2.5.Size of an Experiment -- 8.3.Other Statistical Tests for Two Groups -- 8.3.1.Test for the Same Variance in the Two Groups -- 8.3.2.Comparing Two Group Means: Two Samples with Equal Variances -- 8.4.Final Remarks -- 9.Appendices -- |
|
Contents note continued: 9.1.Probability Theory -- 9.1.1.Sample Space, Events, and Probability -- 9.1.2.Random Variables: the Binomial Distribution -- 9.1.3.Random Variables: Mean and Variance -- 9.1.4.Technical Note: The Binomial Coefficient -- 9.2.Summary of Statistical Methods -- 9.2.1.Quantitative Data -- 9.2.2.Qualitative Data -- 9.3.Statistical Functions in Spreadsheets -- 9.4.Statistical Tables -- 9.4.1.Fractiles in the Normal Distribution -- 9.4.2.Probabilities in the Normal Distribution -- 9.4.3.Table of the t-Distribution -- 9.4.4.Table of the Chi-Squared Distribution -- 9.4.5.Statistical Uncertainty in Sample Surveys -- 9.5.Fitness Club: Data from the Sample Survey -- 9.6.Where to Go from Here -- 9.6.1.Literature -- 9.6.2.Useful Links -- 9.6.3.Overview of Statistical Software -- 9.7.Glossary |
|
Machine generated contents note: 1.Data Collection -- 1.1.Sample Surveys -- 1.2.Fitness Club: Example of a Sample Survey -- 1.3.Experiments -- 1.4.Experiments: An Example -- 1.5.Data Collection -- 1.6.Registers -- 1.7.Questionnaire Surveys -- 1.7.1.Background Questions -- 1.7.2.Study Questions -- 1.8.Sources of Errors in Surveys -- 1.9.Comparing Methods of Data Collection -- 1.10.Example Continued -- 2.Presentation of Data -- 2.1.Bar Charts -- 2.2.Histograms -- 2.3.Pie Charts -- 2.4.Scatter Plots -- 2.5.Line Charts -- 2.6.Bubble Plots -- 2.7.Tables -- 2.7.1.The Ingredients of a Table -- 2.7.2.Percentages -- 3.Description of Data -- 3.1.Systematic and Random Variation -- 3.2.Measures of Location -- 3.2.1.Average -- 3.2.2.Median -- 3.2.3.Mode -- 3.2.4.Choosing a Measure of Location -- 3.3.Measures of Dispersion -- 3.3.1.Range -- 3.3.2.Variance and Standard Deviation -- 3.3.3.Interquartile Range -- 3.3.4.Choosing a Measure of Dispersion -- 3.3.5.Relative Spread (Dispersion) -- |
| Notes |
Includes index |
| Bibliography |
Includes index |
| Subject |
Statistics.
|
| ISBN |
3642176550 |
|
9783642176555 |
|
