Waubonsee Community College

Statistics for people who (think they) hate statistics, Using excel 2016, Neil J. Salkind

eng

index present

non fiction

Statistics for people who (think they) hate statistics

921166011

Neil J. Salkind

Using excel 2016

Machine-generated contents note:, 1., Statistics or Sadistics? It's Up to You, Why Statistics?, And Why Excel?, A 5-Minute History of Statistics, Statistics: What It Is (and Isn't), What Are Descriptive Statistics?, What Are Inferential Statistics?, In Other Words, Tooling Around With the Data Analysis Tools, What Am I Doing in a Statistics Class?, Ten Ways to Use This Book (and Learn Statistics at the Same Time!), + Icons, Key to Difficulty Icons, Key to "How Much Excel" Icons, Glossary, Summary, Time to Practice, Little Chapter 1a. All You Need to Know About Formulas and Functions, What's a Formula?, Creating a Formula, Operator, Operator -- Get Me a Formula!, Beware the Parentheses, What's a Function?, Using a Function, Using Functions in Formulas, We're Taking Names: Naming Ranges, Using Ranges, Real-World Statistics, Summary, Time to Practice, Little Chapter 1b. All You Need to Know About Using the Amazing Data Analysis Tools, A Look at the Data Analysis Tools, Don't Have It? (Installation Again!), Little Chapter 1c. For Mac Lovers Who Are Still Using Version 2011: Rejoice! And, for Mac Lovers Who Are New to Version 2016, Rejoice More!, A Mac Alternative to the Data Analysis Tools, Getting Started With StatPlus, Computing Descriptive Statistics, Options and Preferences, What StatPlus Can Do, 2., Computing and Understanding Averages: Means to an End, Computing the Mean, And Now... Using Excel's AVERAGE Function, Computing a Weighted Mean, Computing the Median, And Now... Using Excel's MEDIAN Function, Computing the Mode, And Now... Using Excel's MODE.SNGL Function, Apple Pie a la Bimodal, And Now... Using Excel's MODE.MULT Function, Using the Amazing Data Analysis Tools to Compute Descriptive Statistics, Make the Data Analysis Tools Output Pretty, When to Use What, Real-World Statistics, Summary, Time to Practice, 3., Vive la Difference: Understanding Variability, Why Understanding Variability Is Important, Computing the Range, Computing the Standard Deviation, And Now... Using Excel's STDEV.S Function, Why n -- 1? What's Wrong With Just n?, What's the Big Deal?, Computing the Variance, And Now... Using Excel's VAR.S Function, The Standard Deviation Versus the Variance, Using the Amazing Data Analysis Tools (Again!), Real-World Statistics, Summary, Time to Practice, 4., A Picture Really Is Worth a Thousand Words, Why Illustrate Data?, Ten Ways to a Great Figure (Eat Less and Exercise More?), First Things First: Creating a Frequency Distribution, The Classiest of Intervals, The Plot Thickens: Creating a Histogram, The Tally-Ho Method, Using the Amazing Data Analysis Tools to Create a Histogram, The Next Step: A Frequency Polygon, Cumulating Frequencies, Fat and Skinny Frequency Distributions, Average Value, Variability, Skewness, Kurtosis, Excel-lent Charts, Your First Excel Chart: A Moment to Remember (Sigh), Excel-lent Charts Part Deux: Making Charts Pretty, Other Cool Charts, Bar Charts, Line Charts, Pie Charts, Real-World Statistics, Summary, Time to Practice, 5., Ice Cream and Crime: Computing Correlation Coefficients, What Are Correlations All About?, Types of Correlation Coefficients: Flavour 1 and Flavour 2, Computing a Simple Correlation Coefficient, And Now... Using Excel's CORREL Function, A Visual Picture of a Correlation: The Scatterplot, Using Excel to Create a Scatterplot, Bunches of Correlations: The Correlation Matrix, More Excel -- Bunches of Correlations a la Excel, Using the Amazing Data Analysis Tools to Compute Correlations, Understanding What the Correlation Coefficient Means, Using-Your-Thumb Rule, A Determined Effort: Squaring the Correlation Coefficient, As More Ice Cream Is Eaten,the Crime Rate Goes Up (or Association Versus Causality), Other Cool Correlations, Real-World Statistics, Summary, Time to Practice, 6., Just the Truth: An Introduction to Understanding Reliability and Validity, An Introduction to Reliability and Validity, What's Up With This Measurement Stuff?, All About Measurement Scales, A Rose by Any Other Name: The Nominal Level of Measurement, Any Order Is Fine With Me: The Ordinal Level of Measurement, 1 + 1 = 2: The Interval Level of Measurement, Can Anyone Have Nothing of Anything? The Ratio Level of Measurement, In Sum..., Reliability -- Doing It Again Until You Get It Right, Test Scores -- Truth or Dare, Observed Score = True Score + Error Score, Different Types of Reliability, How Big Is Big? Interpreting Reliability Coefficients, And If You Can't Establish Reliability... Then What?, Just One More Big Thing, Validity -- Whoa! What Is the Truth?, Different Types of Validity, And If You Can't Establish Validity... Then What?, A Last, Friendly Word, Validity and Reliability: Really Close Cousins, Real-World Statistics, Summary, Time to Practice, 7., Hypotheticals and You: Testing Your Questions, So You Want to Be a Scientist..., Samples and Populations, The Null Hypothesis, The Purposes of the Null Hypothesis, The Research Hypothesis, The Non-directional Research Hypothesis, The Directional Research Hypothesis, Some Differences Between the Null Hypothesis and the Research Hypothesis, What Makes a Good Hypothesis?, Real-World Statistics, Summary, Time to Practice, 8., Are Your Curves Normal? Probability and Why It Counts, Why Probability?, The Normal Curve (aka the Bell-Shaped Curve), Hey, That's Not Normal!, The Central Limit Theorem, More Normal Curve 101, Our Favourite Standard Score: The z Score, Using Excel to Compute z Scores, What z Scores Represent, What z Scores Really Represent, Hypothesis Testing and z Scores: The First Step, Real-World Statistics, Summary, Time to Practice, 9., Significantly Significant: What It Means for You and Me, The Concept of Significance, If Only We Were Perfect, The World's Most Important Table (for This Semester Only), More About Table 9.1, Back to Type I Errors, Significance Versus Meaningfulness, An Introduction to Inferential Statistics, How Inference Works, How to Select What Test to Use, Here's How to Use the Chart, An Introduction to Tests of Significance, How a Test of Significance Works: The Plan, Here's the Picture That's Worth a Thousand Words, Confidence Intervals -- Be Even More Confident, Real-World Statistics, Summary, Time to Practice, 10., Only the Lonely: The One-Sample Z-Test, Introduction to the One-Sample Z-Test, The Path to Wisdom and Knowledge, Computing the Test Statistic, Time for an Example, So How Do I Interpret z = 2.38, p < .05?, Using the Excel Z.TEST Function to Compute the z Value, Real-World Statistics, Summary, Time to Practice, 11., t(ea) for Two: Tests Between the Means of Different Groups, Introduction to the t-Test for Independent Samples, The Path to Wisdom and Knowledge, Computing the Test Statistic, Time for an Example, So How Do I Interpret t(58) = 0.14, p > .05?, And Now... Using Excel's T.TEST Function, Using the Amazing Data Analysis Tools to Compute the t Value, Results, Special Effects: Are Those Differences for Real?, Computing and Understanding the Effect Size, A Very Cool Effect Size Calculator, Real-World Statistics, Summary, Time to Practice, 12., t(ea) for Two (Again): Tests Between the Means of Related Groups, Introduction to the t-Test for Dependent Samples, The Path to Wisdom and Knowledge, Computing the Test Statistic, So How Do I Interpret t(24) = 2.45, p < .05?, And Now..Note continued:, And Now... Using Excel's SLOPE Function, And Now... Using Excel's INTERCEPT Function, Using the Amazing Data Analysis Tools to Compute the Regression Equation, How Good Is Our Prediction?, The More Predictors, the Better? Maybe, The Big Rule When It Comes to Using Multiple Predictor Variables, Real-World Statistics, Summary, Time to Practice, 17., What to Do When You're Not Normal: Chi-Square and Some Other Non-parametric Tests, Introduction to Non-parametric Statistics, Introduction to One-Sample Chi-Square, Computing the Chi-Square Test Statistic, So How Do I Interpret x2 = 20.6, p < .05?, And Now... Using Excel's CHISQ.TEST Function, Other Non-parametric Tests You Should Know About, Real-World Statistics, Summary, Time to Practice, 18., Some Other (Important) Statistical Procedures You Should Know About, Post Hoc Comparisons, Multivariate Analysis of Variance, Repeated Measures Analysis of Variance, Analysis of Covariance, Multiple Regression, Logistic Regression, Factor Analysis, Data Mining, Path Analysis, Structural Equation Modelling, Summary, 19., A Statistical Software Sampler, Selecting the Perfect Statistics Software, What's Out There, The Free Stuff and Open Source Stuff, Time to Pay, Summary, 20., (Mini) Data Mining: A Introduction to Getting the Most Out of Your BIG Data, Our Sample Data Set -- Who Doesn't Love Babies?, Some Excel Data-Exploring Functions, The DAVERAGE Function, What DAVERAGE Does, What DAVERAGE Looks Like, Using the DAVERAGE Function, The COUNTIF Function, What COUNTIF Does, What COUNTIF Looks Like, Using the COUNTIF Function, Pivot Tables and Cross-Tabulation: Finding Hidden Patterns, Creating a Pivot Table, Modifying a Pivot Table, Summary, Time to Practice, 21., The Ten (or More) Best (and Most Fun) Internet Sites for Statistics Stuff, How About Studying Statistics in Stockholm?, Calculators Galore!, Who's Who and What's Happened, It's All Here, HyperStat, Data? You Want Data?, More and More Resources, Online Statistical Teaching Materials, And, of Course, YouTube, 22., The Ten Commandments of Data Collection