Core statistical concepts with Excel : an interactive modular approach /: an interactive modular approach. (2018)

• Record Type: Book
• Further Information: Note: Gregory J. Privitera, Darryl J. Mayeaux.
• Authors: Privitera, Gregory J; Mayeaux, Darryl J
• Contents: Preface to the Instructor; To the Student; Orientation to Excel; About the Authors; SECTION I. CENTRAL TENDENCY AND VARIABILITY; Learning Unit 1. Mean, Median, and Mode; Excel Toolbox; Mean; Median; Mode; Choosing an Appropriate Measure of Central Tendency; Learning Unit 2. Variability; Excel Toolbox; Range; Quartiles and Interquartiles; Variance; Standard Deviation; Learning Unit 3. Shapes of Distributions; Excel Toolbox; Normal Distribution Created With Frequency Array Function; Normal Distribution Created With a PivotTable; Creating a Graph of a Frequency Distribution; Skewed Distribution Created With a PivotTable; SECTION II. PROBABILITY; Learning Unit 4. Probability and the Normal Distribution; Excel Toolbox; Calculating Probability; Expected Value and the Binomial Distribution; Relative Frequency and Probability; Normal Distribution; Learning Unit 5. The Standard Normal Distribution: z Scores; Excel Toolbox; The Standard Normal Distribution; The Unit Normal Table: A Brief Introduction; Learning Unit 6. Sampling Distributions; Excel Toolbox; Selecting Samples From Populations; Sampling Distributions: The Mean; Computing Characteristics of the Sample Mean Using Excel; Sampling Distributions: The Variance; Computing Characteristics of the Sample Variance Using Excel; SECTION III. EVALUATING THE NATURE OF EFFECTS; Learning Unit 7. Hypothesis Testing: Significance, Effect Size, and Confidence Intervals; Inferential Statistics and Hypothesis Testing; Four Steps to Hypothesis Testing; Making a Decision: Types of Error; Nondirectional and Directional Alternatives to the Null Hypothesis; Effect Size; Estimation and Confidence Intervals; Delineating Statistical Effects for Hypothesis Testing; Learning Unit 8. Power; Detecting “Effects”; Effect Size, Power, and Sample Size; SECTION IV. COMPARING MEANS: SIGNIFICANCE TESTING, EFFECT SIZE, AND CONFIDENCE INTERVALS; Learning Unit 9. t Tests: One-Sample, Two-Independent-Sample, and Related-Samples Designs; Excel Toolbox; Origins of the t Tests; Computing the One-Sample t Test; Computing the Two-Independent-Sample t Test; Computing the Related-Samples t Test; Learning Unit 10. One-Way Analysis of Variance: Between-Subjects and Repeated-Measures Designs; Excel Toolbox; An Introduction to Analysis of Variance (ANOVA); One-Way Between-Subjects ANOVA; One-Way Within-Subjects ANOVA; Post Hoc Test Using Tukey’s HSD; Learning Unit 11. Two-Way Analysis of Variance: Between-Subjects Factorial Design; Excel Toolbox; An Introduction to Factorial Design; Describing Variability: Main Effects and Interactions; Computing the Two-Way Between-Subjects ANOVA; Analyzing Main Effects and Interactions; Measuring Effect Size With Eta Squared; Computing the Two-Way Between-Subjects ANOVA Using the Analysis ToolPak; SECTION V. IDENTIFYING PATTERNS AND MAKING PREDICTIONS; Learning Unit 12. Correlation; Excel Toolbox; The Structure of Data Used for Identifying Patterns; Fundamentals of the Correlation; The Strength of a Correlation; The Pearson Correlation Coefficient; Effect Size: The Coefficient of Determination; Hypothesis Testing: Testing for Significance; Limitations in Interpretation: Causality, Outliers, and Restriction of Range; An Alternative to Pearson for Ranked Data: Spearman; An Overview of Other Alternatives to Pearson; Learning Unit 13. Linear Regression; Excel Toolbox; Fundamentals of Linear Regression; Using the Method of Least Squares to Find the Regression Line; Using Regression to Determine Significance; Computing the Analysis of Regression With the Analysis ToolPak; Appendix A: Core Statistical Concepts; A1: Normal and Skewed Distributions; A2: Scales of Measurement; A3: Outliers; A4: The Empirical Rule for Normal Distributions; A5: Chebyshev’s Theorem for Any Type of Distribution; A6: Expected Value as a Long-Term Mean; A7: The Informativeness of the Mean and Standard Deviation for Finding Probabilities; A8: Comparing Differences Between Two Groups; A9: Calculation and Interpretation of the Pooled Sample Variance; A10: Reducing Standard Error by Computing Difference Scores; A11: Categories of Related-Samples Designs; A12: Degrees of Freedom for Parametric Tests; Appendix B: Global Excel Skills; B1: Viewing in Cells the Functions or Formulas Versus the Results of Those Functions or Formulas; B2: Formatting Cells: Decimals, Alignment, Merge Cells, Fonts, Bold, Borders, Superscripts, Subscripts; B3: Freezing the Display of Some Rows and Columns; B4: Highlighting Portions of Spreadsheet, Pasting, or Filling; B5: Sorting Data in a Spreadsheet; B6: Anchoring Cell References; B7: Inserting (Creating) and Formatting a Chart (Graph of Data); B8: Inserting Equations; Appendix C: Statistical Tables; C1: The Unit Normal Table; C2: Critical Values for the t Distribution; C3: Critical Values for the F Distribution; C4: The Studentized Range Statistic (q); C5: Critical Values for the Pearson Correlation; C6: Critical Values for the Spearman Correlation; Glossary; References; Index;
• Edition: 1st
• Publisher Details: Los Angeles : SAGE
• Publication Date: 2018
• Extent: 1 online resource
• Subjects: 519.50285554; Electronic spreadsheets -- Computer programs
• Languages: English
• ISBNs: 9781544309057
• Notes: Note: Includes bibliographical references and index.; Note: Description based on CIP data; resource not viewed.
• Access Rights: Legal Deposit; Only available on premises controlled by the deposit library and to one user at any one time; The Legal Deposit Libraries (Non-Print Works) Regulations (UK).
• Access Usage: Restricted: Printing from this resource is governed by The Legal Deposit Libraries (Non-Print Works) Regulations (UK) and UK copyright law currently in force.