Statistical Analysis with Excel For Dummies - Joseph Schmuller

. .

Auteur(s) : Joseph Schmuller

Editeur : Wiley John + Sons

Langue : Anglais

Parution : 01/03/2022

Format : Moyen, de 350g à 1kg

Nombre de pages : 562

Expédition : 1030

Dimensions : 23.3 x 18.8 x 3.4

ISBN : 1119844541

Résumé :

Become a?stats superstar?by?using?Excel?to?reveal?the?powerful secrets?of?statistics?

Microsoft Excel?offers?numerous?possibilities for statistical analysis-and you don't have to be a?math wizard to unlock them. In?Statistical Analysis with Excel For Dummies, fully updated for the 2021?version of Excel,?you'll?hit the ground running with?straightforward techniques?and?practical?guidance?to?unlock the power of statistics in Excel.

Bypass?unnecessary jargon and skip right to?mastering formulas, functions, charts,?probabilities, distributions, and correlations.?Written for?professionals and students?without?a?background in?statistics or math, you'll?learn to?create, interpret, and translate statistics-and have fun doing it!?

In this book?you'll find out how to:?

• Understand, describe,?and?summarize?any kind of?data, from sports stats to sales figures?
• Confidently draw?conclusions from your analyses, make?accurate?predictions, and?calculate?correlations?
• Model the probabilities of future outcomes based on past data?
• Perform statistical analysis on any platform: Windows, Mac,?or iPad?
• Access additional resources and practice templates through Dummies.com?

For anyone?who's?ever wanted?to unleash?the full potential of?statistical analysis in?Excel-and impress?your?colleagues or classmates along the way-Statistical Analysis with Excel For Dummies?walks you through?the?foundational concepts?of analyzing statistics?and the step-by-step?methods you?use to apply them.? ?

...

Biographie:

Joseph Schmuller works on the Digital & Enterprise Architecture Team at Availity. He has taught statistics at the undergraduate and graduate levels. He has created and delivered courses for LinkedIn Learning, and he is the author of all previous editions of Statistical Analysis with Excel For Dummies.

Sommaire:

Introduction 1

About This Book 2

What's New in This Edition 2

What's New in Excel (Microsoft 365) 3

Foolish Assumptions 3

Icons Used in This Book 4

Where to Go from Here 5

Beyond This Book 5

Part 1: Getting Started With Statistical Analysis With Excel: A Marriage Made In Heaven 7

Chapter 1: Evaluating Data in the Real World 9

The Statistical (and Related) Notions You Just Have to Know 9

Samples and populations 10

Variables: Dependent and independent 11

Types of data 12

A little probability 13

Inferential Statistics: Testing Hypotheses 14

Null and alternative hypotheses 15

Two types of error 16

Some Excel Fundamentals 18

Autofilling cells 22

Referencing cells 25

Chapter 2: Understanding Excel's Statistical Capabilities 29

Getting Started 30

Setting Up for Statistics 32

Worksheet functions 32

Quickly accessing statistical functions 36

Array functions 38

What's in a name? An array of possibilities 41

Creating Your Own Array Formulas 50

Using data analysis tools 51

Additional data analysis tool packages 56

Accessing Commonly Used Functions 58

The New Analyze Data Tool 59

Data from Pictures! 60

Part 2: Describing Data 63

Chapter 3: Show-and-Tell: Graphing Data 65

Why Use Graphs? 65

Examining Some Fundamentals 67

Gauging Excel's Graphics (Chartics?) Capabilities 68

Becoming a Columnist 69

Stacking the Columns 73

Slicing the Pie 74

A word from the wise 76

Drawing the Line 77

Adding a Spark 80

Passing the Bar 82

The Plot Thickens 84

Finding Another Use for the Scatter Chart 88

Chapter 4: Finding Your Center 91

Means: The Lore of Averages 91

Calculating the mean 92

AVERAGE and AVERAGEA 93

AVERAGEIF and AVERAGEIFS 95

TRIMMEAN 99

Other means to an end 100

Medians: Caught in the Middle 102

Finding the median 102

MEDIAN 103

Statistics ? la Mode 104

Finding the mode 104

MODE.SNGL and MODE.MULT 104

Chapter 5: Deviating from the Average 107

Measuring Variation 108

Averaging squared deviations: Variance and how to calculate it 108

VAR.P and VARPA 111

Sample variance 113

VAR.S and VARA 114

Back to the Roots: Standard Deviation 114

Population standard deviation 115

STDEV.P and STDEVPA 115

Sample standard deviation 116

STDEV.S and STDEVA 116

The missing functions: STDEVIF and STDEVIFS 117

Related Functions 121

DEVSQ 121

Average deviation 122

AVEDEV 123

Chapter 6: Meeting Standards and Standings 125

Catching Some Z's 126

Characteristics of z-scores 126

Bonds versus the Bambino 127

Exam scores 128

STANDARDIZE 128

Where Do You Stand? 131

RANK.EQ and RANK.AVG 131

LARGE and SMALL 133

PERCENTILE.INC and PERCENTILE.EXC 134

PERCENTRANK.INC and PERCENTRANK.EXC 137

Data analysis tool: Rank and Percentile 138

Chapter 7: Summarizing It All 141

Counting Out 141

COUNT, COUNTA, COUNTBLANK, COUNTIF, COUNTIFS 141

The Long and Short of It 144

MAX, MAXA, MIN, and MINA 144

Getting Esoteric 145

SKEW and SKEW.P 146

KURT 148

Tuning In the Frequency 150

FREQUENCY 150

Data analysis tool: Histogram 152

Can You Give Me a Description? 154

Data analysi...