Statistical Analysis with Excel For Dummies / (Record no. 19302)
[ view plain ]
| 000 -LEADER | |
|---|---|
| fixed length control field | 13719nam a22003255i 4500 |
| 001 - CONTROL NUMBER | |
| control field | 22304757 |
| 003 - CONTROL NUMBER IDENTIFIER | |
| control field | OSt |
| 005 - DATE AND TIME OF LATEST TRANSACTION | |
| control field | 20230131153423.0 |
| 008 - FIXED-LENGTH DATA ELEMENTS--GENERAL INFORMATION | |
| fixed length control field | 211109s2021 inu 000 0 eng |
| 010 ## - LIBRARY OF CONGRESS CONTROL NUMBER | |
| LC control number | 2021950426 |
| 020 ## - INTERNATIONAL STANDARD BOOK NUMBER | |
| International Standard Book Number | 9781119844549 |
| Qualifying information | (paperback) |
| 040 ## - CATALOGING SOURCE | |
| Original cataloging agency | DLC |
| Language of cataloging | eng |
| Description conventions | rda |
| Transcribing agency | DLC |
| 042 ## - AUTHENTICATION CODE | |
| Authentication code | pcc |
| 082 ## - DEWEY DECIMAL CLASSIFICATION NUMBER | |
| Classification number | 005.54 SCH |
| 100 1# - MAIN ENTRY--PERSONAL NAME | |
| Personal name | Schmuller, Joseph, |
| Relator term | author. |
| 245 10 - TITLE STATEMENT | |
| Title | Statistical Analysis with Excel For Dummies / |
| Statement of responsibility, etc. | Joseph Schmuller. |
| 250 ## - EDITION STATEMENT | |
| Edition statement | 5th edition. |
| 263 ## - PROJECTED PUBLICATION DATE | |
| Projected publication date | 2112 |
| 264 #1 - PRODUCTION, PUBLICATION, DISTRIBUTION, MANUFACTURE, AND COPYRIGHT NOTICE | |
| Place of production, publication, distribution, manufacture | Indianapolis : |
| Name of producer, publisher, distributor, manufacturer | John Wiley & Sons Inc., |
| Date of production, publication, distribution, manufacture, or copyright notice | 2021. |
| 300 ## - PHYSICAL DESCRIPTION | |
| Extent | 562 pages |
| 336 ## - CONTENT TYPE | |
| Content type term | text |
| Content type code | txt |
| Source | rdacontent |
| 337 ## - MEDIA TYPE | |
| Media type term | unmediated |
| Media type code | n |
| Source | rdamedia |
| 338 ## - CARRIER TYPE | |
| Carrier type term | volume |
| Carrier type code | nc |
| Source | rdacarrier |
| 505 ## - FORMATTED CONTENTS NOTE | |
| Formatted contents note | Introduction 1<br/><br/>About This Book 2<br/><br/>What's New in This Edition 2<br/><br/>What's New in Excel (Microsoft 365) 3<br/><br/>Foolish Assumptions 3<br/><br/>Icons Used in This Book 4<br/><br/>Where to Go from Here 5<br/><br/>Beyond This Book 5<br/><br/>Part 1: Getting Started With Statistical Analysis With Excel: A Marriage Made In Heaven 7<br/><br/>Chapter 1: Evaluating Data in the Real World 9<br/><br/>The Statistical (and Related) Notions You Just Have to Know 9<br/><br/>Samples and populations 10<br/><br/>Variables: Dependent and independent 11<br/><br/>Types of data 12<br/><br/>A little probability 13<br/><br/>Inferential Statistics: Testing Hypotheses 14<br/><br/>Null and alternative hypotheses 15<br/><br/>Two types of error 16<br/><br/>Some Excel Fundamentals 18<br/><br/>Autofilling cells 22<br/><br/>Referencing cells 25<br/><br/>Chapter 2: Understanding Excel's Statistical Capabilities 29<br/><br/>Getting Started 30<br/><br/>Setting Up for Statistics 32<br/><br/>Worksheet functions 32<br/><br/>Quickly accessing statistical functions 36<br/><br/>Array functions 38<br/><br/>What's in a name? An array of possibilities 41<br/><br/>Creating Your Own Array Formulas 50<br/><br/>Using data analysis tools 51<br/><br/>Additional data analysis tool packages 56<br/><br/>Accessing Commonly Used Functions 58<br/><br/>The New Analyze Data Tool 59<br/><br/>Data from Pictures! 60<br/><br/>Part 2: Describing Data 63<br/><br/>Chapter 3: Show-and-Tell: Graphing Data 65<br/><br/>Why Use Graphs? 65<br/><br/>Examining Some Fundamentals 67<br/><br/>Gauging Excel's Graphics (Chartics?) Capabilities 68<br/><br/>Becoming a Columnist 69<br/><br/>Stacking the Columns 73<br/><br/>Slicing the Pie 74<br/><br/>A word from the wise 76<br/><br/>Drawing the Line 77<br/><br/>Adding a Spark 80<br/><br/>Passing the Bar 82<br/><br/>The Plot Thickens 84<br/><br/>Finding Another Use for the Scatter Chart 88<br/><br/>Chapter 4: Finding Your Center 91<br/><br/>Means: The Lore of Averages 91<br/><br/>Calculating the mean 92<br/><br/>AVERAGE and AVERAGEA 93<br/><br/>AVERAGEIF and AVERAGEIFS 95<br/><br/>TRIMMEAN 99<br/><br/>Other means to an end 100<br/><br/>Medians: Caught in the Middle 102<br/><br/>Finding the median 102<br/><br/>MEDIAN 103<br/><br/>Statistics a la Mode 104<br/><br/>Finding the mode 104<br/><br/>MODE.SNGL and MODE.MULT 104<br/><br/>Chapter 5: Deviating from the Average 107<br/><br/>Measuring Variation 108<br/><br/>Averaging squared deviations: Variance and how to calculate it 108<br/><br/>VAR.P and VARPA 111<br/><br/>Sample variance 113<br/><br/>VAR.S and VARA 114<br/><br/>Back to the Roots: Standard Deviation 114<br/><br/>Population standard deviation 115<br/><br/>STDEV.P and STDEVPA 115<br/><br/>Sample standard deviation 116<br/><br/>STDEV.S and STDEVA 116<br/><br/>The missing functions: STDEVIF and STDEVIFS 117<br/><br/>Related Functions 121<br/><br/>DEVSQ 121<br/><br/>Average deviation 122<br/><br/>AVEDEV 123<br/><br/>Chapter 6: Meeting Standards and Standings 125<br/><br/>Catching Some Z's 126<br/><br/>Characteristics of z-scores 126<br/><br/>Bonds versus the Bambino 127<br/><br/>Exam scores 128<br/><br/>STANDARDIZE 128<br/><br/>Where Do You Stand? 131<br/><br/>RANK.EQ and RANK.AVG 131<br/><br/>LARGE and SMALL 133<br/><br/>PERCENTILE.INC and PERCENTILE.EXC 134<br/><br/>PERCENTRANK.INC and PERCENTRANK.EXC 137<br/><br/>Data analysis tool: Rank and Percentile 138<br/><br/>Chapter 7: Summarizing It All 141<br/><br/>Counting Out 141<br/><br/>COUNT, COUNTA, COUNTBLANK, COUNTIF, COUNTIFS 141<br/><br/>The Long and Short of It 144<br/><br/>MAX, MAXA, MIN, and MINA 144<br/><br/>Getting Esoteric 145<br/><br/>SKEW and SKEW.P 146<br/><br/>KURT 148<br/><br/>Tuning In the Frequency 150<br/><br/>FREQUENCY 150<br/><br/>Data analysis tool: Histogram 152<br/><br/>Can You Give Me a Description? 154<br/><br/>Data analysis tool: Descriptive Statistics 154<br/><br/>Be Quick About It! 156<br/><br/>Instant Statistics 159<br/><br/>Chapter 8: What's Normal? 161<br/><br/>Hitting the Curve 161<br/><br/>Digging deeper 162<br/><br/>Parameters of a normal distribution 163<br/><br/>NORM.DIST 165<br/><br/>NORM.INV 167<br/><br/>A Distinguished Member of the Family 168<br/><br/>NORM.S.DIST 169<br/><br/>NORM.S.INV 170<br/><br/>PHI and GAUSS 170<br/><br/>Graphing a Standard Normal Distribution 171<br/><br/>Part 3: Drawing Conclusions From Data 173<br/><br/>Chapter 9: The Confidence Game: Estimation 175<br/><br/>Understanding Sampling Distributions 176<br/><br/>An EXTREMELY Important Idea: The Central Limit Theorem 177<br/><br/>(Approximately) simulating the Central Limit Theorem 178<br/><br/>The Limits of Confidence 183<br/><br/>Finding confidence limits for a mean 183<br/><br/>CONFIDENCE.NORM 186<br/><br/>Fit to a t 187<br/><br/>CONFIDENCE.T 188<br/><br/>Chapter 10: One-Sample Hypothesis Testing 189<br/><br/>Hypotheses, Tests, and Errors 190<br/><br/>Hypothesis Tests and Sampling Distributions 191<br/><br/>Catching Some Z's Again 193<br/><br/>Z.TEST 196<br/><br/>t for One 197<br/><br/>T.DIST, T.DIST.RT, and T.DIST.2T 198<br/><br/>T.INV and T.INV.2T 200<br/><br/>Visualizing a t-Distribution 201<br/><br/>Testing a Variance 203<br/><br/>CHISQ.DIST and CHISQ.DIST.RT 205<br/><br/>CHISQ.INV and CHISQ.INV.RT 206<br/><br/>Visualizing a Chi-Square Distribution 208<br/><br/>Chapter 11: Two-Sample Hypothesis Testing 211<br/><br/>Hypotheses Built for Two 211<br/><br/>Sampling Distributions Revisited 212<br/><br/>Applying the Central Limit Theorem 213<br/><br/>Z's once more 215<br/><br/>Data analysis tool: z-Test: Two Sample for Means 216<br/><br/>t for Two 219<br/><br/>Like peas in a pod: Equal variances 220<br/><br/>Like p's and q's: Unequal variances 221<br/><br/>T.TEST 222<br/><br/>Data analysis tool: t-Test: Two Sample 223<br/><br/>A Matched Set: Hypothesis Testing for Paired Samples 227<br/><br/>T.TEST for matched samples 228<br/><br/>Data analysis tool: t-Test: Paired Two Sample for Means 230<br/><br/>t-tests on the iPad with StatPlus 232<br/><br/>Testing Two Variances 235<br/><br/>Using F in conjunction with t 237<br/><br/>F.TEST 238<br/><br/>F.DIST and F.DIST.RT 240<br/><br/>F.INV and F.INV.RT 241<br/><br/>Data analysis tool: F-test: Two Sample for Variances 242<br/><br/>Visualizing the F-Distribution 244<br/><br/>Chapter 12: Testing More Than Two Samples 247<br/><br/>Testing More than Two 247<br/><br/>A thorny problem 248<br/><br/>A solution 249<br/><br/>Meaningful relationships 253<br/><br/>After the F-test 254<br/><br/>Data analysis tool: Anova: Single Factor 258<br/><br/>Comparing the means 260<br/><br/>Another Kind of Hypothesis, Another Kind of Test 262<br/><br/>Working with repeated measures ANOVA 262<br/><br/>Getting trendy 264<br/><br/>Data analysis tool: Anova: Two-Factor Without Replication 268<br/><br/>Analyzing trend 271<br/><br/>ANOVA on the iPad 272<br/><br/>ANOVA on the iPad: Another Way 274<br/><br/>Repeated Measures ANOVA on the iPad 277<br/><br/>Chapter 13: Slightly More Complicated Testing 281<br/><br/>Cracking the Combinations 281<br/><br/>Breaking down the variances 282<br/><br/>Data analysis tool: Anova: Two-Factor Without Replication 284<br/><br/>Cracking the Combinations Again 286<br/><br/>Rows and columns 286<br/><br/>Interactions 287<br/><br/>The analysis 288<br/><br/>Data analysis tool: Anova: Two-Factor With Replication 289<br/><br/>Two Kinds of Variables - at Once 292<br/><br/>Using Excel with a Mixed Design 293<br/><br/>Graphing the Results 298<br/><br/>After the ANOVA 300<br/><br/>Two-Factor ANOVA on the iPad 300<br/><br/>Chapter 14: Regression: Linear and Multiple 303<br/><br/>The Plot of Scatter 303<br/><br/>Graphing a line 305<br/><br/>Regression: What a Line! 307<br/><br/>Using regression for forecasting 309<br/><br/>Variation around the regression line 309<br/><br/>Testing hypotheses about regression 311<br/><br/>Worksheet Functions for Regression 317<br/><br/>SLOPE, INTERCEPT, STEYX 318<br/><br/>FORECAST.LINEAR 319<br/><br/>Array function: TREND 319<br/><br/>Array function: LINEST 323<br/><br/>Data Analysis Tool: Regression 325<br/><br/>Working with tabled output 327<br/><br/>Opting for graphical output 329<br/><br/>Juggling Many Relationships at Once: Multiple Regression 330<br/><br/>Excel Tools for Multiple Regression 331<br/><br/>TREND revisited 331<br/><br/>LINEST revisited 333<br/><br/>Regression data analysis tool revisited 336<br/><br/>Regression Analysis on the iPad 338<br/><br/>Chapter 15: Correlation: The Rise and Fall of Relationships 341<br/><br/>Scatterplots Again 341<br/><br/>Understanding Correlation 342<br/><br/>Correlation and Regression 345<br/><br/>Testing Hypotheses about Correlation 347<br/><br/>Is a correlation coefficient greater than zero? 348<br/><br/>Do two correlation coefficients differ? 349<br/><br/>Worksheet Functions for Correlation 350<br/><br/>CORREL and PEARSON 350<br/><br/>RSQ 351<br/><br/>COVARIANCE.P and COVARIANCE.S 352<br/><br/>Data Analysis Tool: Correlation 353<br/><br/>Tabled output 354<br/><br/>Multiple correlation 355<br/><br/>Partial correlation 356<br/><br/>Semipartial correlation 357<br/><br/>Data Analysis Tool: Covariance 358<br/><br/>Using Excel to Test Hypotheses about Correlation 358<br/><br/>Worksheet functions: FISHER, FISHERINV 359<br/><br/>Correlation Analysis on the iPad 360<br/><br/>Chapter 16: It's About Time 363<br/><br/>A Series and Its Components 363<br/><br/>A Moving Experience 364<br/><br/>Lining up the trend 365<br/><br/>Data analysis tool: Moving Average 365<br/><br/>How to Be a Smoothie, Exponentially 368<br/><br/>One-Click Forecasting 369<br/><br/>Working with Time Series on the iPad 374<br/><br/>Chapter 17: Nonparametric Statistics 379<br/><br/>Independent Samples 380<br/><br/>Two samples: Mann-Whitney U test 380<br/><br/>More than two samples: Kruskal-Wallis one-way ANOVA 382<br/><br/>Matched Samples 383<br/><br/>Two samples: Wilcoxon matched-pairs signed ranks 384<br/><br/>More than two samples: Friedman two-way ANOVA 386<br/><br/>More than two samples: Cochran's Q 387<br/><br/>Correlation: Spearman's rS 389<br/><br/>A Heads-Up 391<br/><br/>Part 4: Probability 393<br/><br/>Chapter 18: Introducing Probability 395<br/><br/>What Is Probability? 395<br/><br/>Experiments, trials, events, and sample spaces 396<br/><br/>Sample spaces and probability 396<br/><br/>Compound Events 397<br/><br/>Union and intersection 397<br/><br/>Intersection, again 398<br/><br/>Conditional Probability 399<br/><br/>Working with the probabilities 400<br/><br/>The foundation of hypothesis testing 400<br/><br/>Large Sample Spaces 400<br/><br/>Permutations 401<br/><br/>Combinations 402<br/><br/>Worksheet Functions 403<br/><br/>FACT 403<br/><br/>PERMUT and PERMUTIONA 403<br/><br/>COMBIN and COMBINA 404<br/><br/>Random Variables: Discrete and Continuous 405<br/><br/>Probability Distributions and Density Functions 405<br/><br/>The Binomial Distribution 407<br/><br/>Worksheet Functions 409<br/><br/>BINOM.DIST and BINOM.DIST.RANGE 409<br/><br/>NEGBINOM.DIST 411<br/><br/>Hypothesis Testing with the Binomial Distribution 412<br/><br/>BINOM.INV 413<br/><br/>More on hypothesis testing 414<br/><br/>The Hypergeometric Distribution 415<br/><br/>HYPGEOM.DIST 416<br/><br/>Chapter 19: More on Probability 419<br/><br/>Discovering Beta 419<br/><br/>BETA.DIST 421<br/><br/>BETA.INV 423<br/><br/>Poisson 424<br/><br/>POISSON.DIST 425<br/><br/>Working with Gamma 427<br/><br/>The gamma function and GAMMA 427<br/><br/>The gamma distribution and GAMMA.DIST 428<br/><br/>GAMMA.INV 430<br/><br/>Exponential 431<br/><br/>EXPON.DIST 431<br/><br/>Chapter 20: Using Probability: Modeling and Simulation 433<br/><br/>Modeling a Distribution 434<br/><br/>Plunging into the Poisson distribution 434<br/><br/>Visualizing the Poisson distribution 435<br/><br/>Working with the Poisson distribution 436<br/><br/>Using POISSON.DIST again 437<br/><br/>Testing the model's fit 437<br/><br/>A word about CHISQ.TEST 440<br/><br/>Playing ball with a model 441<br/><br/>A Simulating Discussion 444<br/><br/>Taking a chance: The Monte Carlo method 444<br/><br/>Loading the dice 444<br/><br/>Data analysis tool: Random Number Generation 445<br/><br/>Simulating the Central limit Theorem 448<br/><br/>Simulating a business 452<br/><br/>Chapter 21: Estimating Probability: Logistic Regression 457<br/><br/>Working Your Way Through Logistic Regression 458<br/><br/>Mining with XLMiner 460<br/><br/>Part 5: The Part of Tens 465<br/><br/>Chapter 22: Ten (12, Actually) Statistical and Graphical Tips and Traps 467<br/><br/>Significant Doesn't Always Mean Important 467<br/><br/>Trying to Not Reject a Null Hypothesis Has a Number of Implications 468<br/><br/>Regression Isn't Always Linear 468<br/><br/>Extrapolating Beyond a Sample Scatterplot Is a Bad Idea 469<br/><br/>Examine the Variability Around a Regression Line 469<br/><br/>A Sample Can Be Too Large 470<br/><br/>Consumers: Know Your Axes 470<br/><br/>Graphing a Categorical Variable as a Quantitative Variable Is Just Plain Wrong 471<br/><br/>Whenever Appropriate, Include Variability in Your Graph 472<br/><br/>Be Careful When Relating Statistics Textbook Concepts to Excel 472<br/><br/>It's Always a Good Idea to Use Named Ranges in Excel 472<br/><br/>Statistical Analysis with Excel on the iPad Is Pretty Good! 473<br/><br/>Chapter 23: Ten Topics (Thirteen, Actually) That Just Don't Fit Elsewhere 475<br/><br/>Graphing the Standard Error of the Mean 475<br/><br/>Probabilities and Distributions 479<br/><br/>PROB 479<br/><br/>WEIBULL.DIST 479<br/><br/>Drawing Samples 480<br/><br/>Testing Independence: The True Use of CHISQ.TEST 481<br/><br/>Logarithmica Esoterica 484<br/><br/>What is a logarithm? 484<br/><br/>What is e? 486<br/><br/>LOGNORM.DIST 489<br/><br/>LOGNORM.INV 490<br/><br/>Array Function: LOGEST 491<br/><br/>Array Function: GROWTH 494<br/><br/>The logs of Gamma 497<br/><br/>Sorting Data 498<br/><br/>Part 6: Appendices 501<br/><br/>Appendix A: When Your Data Live Elsewhere 503<br/><br/>Appendix B: Tips for Teachers (and Learners) 507<br/><br/>Augmenting Analyses Is a Good Thing 507<br/><br/>Understanding ANOVA 508<br/><br/>Revisiting regression 510<br/><br/>Simulating Data Is Also a Good Thing 512<br/><br/>When All You Have Is a Graph 514<br/><br/>Appendix C: More on Excel Graphics 515<br/><br/>Tasting the Bubbly 515<br/><br/>Taking Stock 516<br/><br/>Scratching the Surface 518<br/><br/>On the Radar 519<br/><br/>Growing a Treemap and Bursting Some Sun 520<br/><br/>Building a Histogram 521<br/><br/>Ordering Columns: Pareto 522<br/><br/>Of Boxes and Whiskers 523<br/><br/>3D Maps 524<br/><br/>Filled Maps 527<br/><br/>Appendix D: The Analysis of Covariance 529<br/><br/>Covariance: A Closer Look 529<br/><br/>Why You Analyze Covariance 530<br/><br/>How You Analyze Covariance 531<br/><br/>ANCOVA in Excel 532<br/><br/>Method 1: ANOVA 533<br/><br/>Method 2: Regression 537<br/><br/>After the ANCOVA 540<br/><br/>And One More Thing 542<br/><br/>Index 545 |
| 650 ## - SUBJECT ADDED ENTRY--TOPICAL TERM | |
| Topical term or geographic name entry element | Electronic spreadsheets -- Computer programs |
| 650 ## - SUBJECT ADDED ENTRY--TOPICAL TERM | |
| Topical term or geographic name entry element | Microsoft Excel (Computer file) |
| Form subdivision | Statistical analysis |
| 906 ## - LOCAL DATA ELEMENT F, LDF (RLIN) | |
| a | 0 |
| b | ibc |
| c | orignew |
| d | 2 |
| e | epcn |
| f | 20 |
| g | y-gencatlg |
| 942 ## - ADDED ENTRY ELEMENTS (KOHA) | |
| Source of classification or shelving scheme | Dewey Decimal Classification |
| Koha item type | Stack text books |
| Withdrawn status | Lost status | Source of classification or shelving scheme | Damaged status | Not for loan | Collection code | Home library | Current library | Date acquired | Total Checkouts | Full call number | Barcode | Date last seen | Date last checked out | Price effective from | Koha item type |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Dewey Decimal Classification | 2/5 | All India Institute of Speech and Hearing | All India Institute of Speech and Hearing | 31/01/2023 | 1 | 005.54 SCH | 23236 | 12/09/2024 | 13/08/2024 | 31/01/2023 | Stack text books |