Straightforward Statistics with Excel
Autor Chieh-Chen Bowenen Limba Engleză Paperback – 8 oct 2021
Destinată nivelului de licență în științele sociale și comportamentale, Straightforward Statistics with Excel de Chieh-Chen Bowen reprezintă o resursă didactică axată pe construirea progresivă a competențelor cantitative. Suntem de părere că forța acestui volum rezidă în abordarea sa pedagogică blândă, care transformă statistica dintr-o disciplină abstractă într-un instrument de lucru accesibil prin intermediul software-ului Microsoft Excel. Această a doua ediție aduce îmbunătățiri structurale semnificative: autorul a ales să separe prezentarea măsurilor tendinței centrale de cele ale variabilității pentru a clarifica distincțiile conceptuale, oferind totodată o tratare mai detaliată a testelor t pentru eșantioane dependente și independente. Subliniem eficiența structurii cumulative a textului. Fiecare capitol este conceput ca o extensie logică a celui precedent, facilitând o tranziție lină de la concepte de bază, precum scalele de măsurare și eșantionarea aleatorie, către analize mai complexe. Volumul include numeroase elemente de sprijin, de la casete de reamintire a punctelor cheie până la teste rapide de autoevaluare. Comparativ cu Excel 2013 for Social Sciences Statistics de Thomas J. Quirk, care se concentrează masiv pe exerciții aplicate pentru utilizatorii reticenți la matematică, lucrarea lui Bowen menține un echilibru mai pronunțat între fundamentarea teoretică și aplicabilitatea practică, fiind mai potrivită pentru un curs universitar structurat. În timp ce seria lui Quirk este adesea un ghid tehnic pas-cu-pas, Straightforward Statistics with Excel pune accentul pe înțelegerea fenomenului statistic în contextul cercetării sociale, pregătind studenții pentru cursuri avansate de analiză a datelor.
Preț: 703.73 lei
Preț vechi: 913.93 lei
-23%
Carte disponibilă
Livrare economică 05-19 mai
Specificații
ISBN-10: 1544361963
Pagini: 520
Dimensiuni: 185 x 231 x 28 mm
Greutate: 0.89 kg
Ediția:2nd edition
Editura: SAGE Publications
Locul publicării:Thousand Oaks, United States
De ce să citești această carte
Recomandăm această carte studenților de la facultățile de sociologie, psihologie sau asistență socială care doresc să stăpânească statistica fără a fi copleșiți de formule matematice complexe. Cititorul câștigă abilități practice de operare în Excel, esențiale în piața muncii, și o înțelegere clară a modului în care datele pot descrie realitatea socială. Este ghidul ideal pentru cei care preferă un ritm de învățare logic și bine structurat.
Despre autor
Chieh-Chen Bowen este un cadru didactic cu experiență în predarea metodelor de cercetare și a statisticii aplicate în domeniul științelor sociale. Expertiza sa se concentrează pe simplificarea conceptelor cantitative complexe pentru studenții care nu au un fundament matematic extensiv. Prin publicarea acestei a doua ediții a Straightforward Statistics with Excel la editura SAGE Publications, Bowen își continuă misiunea de a democratiza accesul la analiza datelor, punând accent pe utilizarea instrumentelor software accesibile precum Excel în cercetarea academică și profesională.
Descriere scurtă
The new edition features a reorganized presentation of material, starting with measures of central tendency, separating this from measures of variability so students better understand the differences. A more thorough presentation of one-sample and dependent samples t-tests gives students a stronger foundation in these crucial tests in statistics. New examples and studies complete the update, with a focus on simplicity. Throughout, the book makes use of Excel instructions and screenshots so students can take statistics with them through research projects and into the world beyond academia.
Cuprins
Acknowledgments
About the Author
Chapter 1. Introduction to Statistics
What Is Statistics?
Random Sampling Methods
Scales of Measurement
Variable Classifications
Required Mathematical Skills for This Course
Exercise Problems
Chapter Resources
What You Learned
Key Words
Learning Assessment
Chapter 2. Summarizing, Organizing Data, and Measures of Central Tendency
What You Know and What Is New
Frequency Distribution Table
Graphs
Common Distribution Shapes
Measures of Central Tendency
Excel Step-by-Step Instruction for Calculating SX From a Frequency Table and Constructing a Bar Graph and a Histogram
Exercise Problems
Chapter Resources
What You Learned
Key Words
Learning Assessment
Chapter 3. Measures of Variability
What You Know and What Is New
Measures of Variability
Discover the Hidden Functions in Excel: Analysis Toolpak Installation Instructions
Exercise Problems
Chapter Resources
What You Learned
Key Words
Learning Assessment
Chapter 4. Standard Z Scores
What You Know
What Is New
Standard Z Scores
Empirical Rule for Variables With a Normal Distribution
Exercise Problems
Chapter Resources
What You Learned
Key Words
Learning Assessment
Chapter 5. Basic Principles of Probability
What You Know and What Is New
Basic Terms and Mathematical Operations in Probability
Linkage Between Probability and Z Score in a Normal Distribution
Probabilities, Z Scores, and Raw Scores
Exercise Problems
Chapter Resources
What You Learned
Key Words
Learning Assessment
Chapter 6. The Central Limit Theorem
What You Know and What Is New
Sampling Error
Sampling Distribution of the Sample Means and the Central Limit Theorem
Relationships Between Sample Means and the Population Mean
The Law of Large Numbers
Exercise Problems
Chapter Resources
What You Learned
Key Words
Learning Assessment
Chapter 7. Hypothesis Testing
What You Know and What Is New
Type I Error and Type II Error
The Four-Step Procedure to Conduct a Hypothesis Test
Further Discussions on Directional Versus Nondirectional Hypothesis Tests
Exercise Problems
Chapter Resources
What You Learned
Key Words
Learning Assessment
Chapter 8. One-Sample t Test and Dependent-Sample t Test
What You Know and What Is New
The Unknown s and Conducting the One-Sample t Test
The t Distribution With a Specific Curve for Every Degree of Freedom
The Four-Step Hypothesis Test in One-Sample t Tests
Confidence Intervals in One-Sample t Tests
Introducing Dependent-Sample t Tests
Calculations and the Hypothesis Testing Process in Dependent-Sample t Tests
Exercise Problems
Chapter Resources
What You Learned
Key Words
Learning Assessment
Chapter 9. Independent-Samples t Tests
What You Know and What Is New
Introducing Independent Samples and the Decision Rules on Equal Variances
Decision Rules for Equal Variances Assumed Versus Equal Variances Not Assumed
Confidence Intervals of the Mean Differences
Effect Sizes
Exercise Problems
Chapter Resources
What You Learned
Key Words
Learning Assessment
Chapter 10. Correlation
What You Know and What Is New
Pearson’s Correlation
Hypothesis Testing for Pearson’s Correlation
Interpretations and Assumptions of Pearson’s Correlation
Partial Correlation
Excel Step-by-Step Instruction for Constructing a Scatterplot
Excel Step-by-Step Instruction for Calculating Pearson’s r
Exercise Problems
Chapter Resources
What You Learned
Key Words
Learning Assessment
Chapter 11. Simple Regression
What You Know and What Is New
Y-Intercept and Slope
Hypothesis Testing for Simple Regression
Statistical Assumptions for Simple Regression
Step-by-Step Instructions of Simple Regression in Excel
Exercise Problems
Chapter Resources
What You Learned
Key Words
Learning Assessment
Chapter 12. One-Way Analysis of Variance
What You Know and What Is New
Introducing One-Way ANOVA
Between-Group Variance and Within-Group Variance
Hypothesis Testing for One-Way ANOVA
Effect Size for One-Way ANOVA
Step-by-Step Instructions for Using Excel to Run an ANOVA
Exercise Problems
Chapter Resources
What You Learned
Key Words
Learning Assessment
Chapter 13. Chi-Square Tests for Goodness of Fit and Independence
What You Know and What Is New
The Chi-Square
Expected Frequency
Goodness-of-Fit Tests
Chi-Square for Independence Test
Exercise Problems
Chapter Resources
What You Learned
Key Words
Learning Assessment
Appendix A. The Standard Normal Distribution Table (Z Table)
Appendix B. The t-Distribution Table (t Table)
Appendix C. The F Table
Appendix D. The Critical Values of Pearson’s Correlation Table (r Table)
Appendix E. The Critical Values for the Chi-Square Tests (?2 Table)
Answers to the Learning Assessments
Glossary
References
Index