Excel Statistics

A Quick Guide

Author: Neil J. Salkind

Publisher: SAGE Publications

ISBN: 148337405X

Category: Social Science

Page: 168

View: 8077

DOWNLOAD NOW »
Ideal for those already familiar with basic Excel features, this updated Third Edition of Neil J. Salkind’s Excel Statistics: A Quick Guide shows readers how to utilize Microsoft® Excel’s functions and Analysis ToolPak to answer simple and complex questions about data. Part I explores 35 Excel functions, while Part II contains 20 Analysis ToolPak tools. To make it easy to see what each function or tool looks like when applied, at-a-glance two-page spreads describe each function and its use with corresponding screenshots. In addition, actual data files used in the examples are readily available online at an open-access Student Study Site.

Statistik mit Excel für Dummies

Author: Joseph Schmuller

Publisher: John Wiley & Sons

ISBN: 3527811702

Category: Computers

Page: 535

View: 4548

DOWNLOAD NOW »
Statistiken und Aussagen zu Wahrscheinlichkeiten begegnen uns heute überall: Die Umsatzentwicklung in Unternehmen, Hochrechnungen für Wahlergebnisse, PISA-Ergebnisse fünfzehnjähriger Schüler sind nur drei von zahlreichen Beispielen. Joseph Schmuller zeigt Ihnen in diesem Buch, wie Sie die Zahlen in den Griff bekommen und Daten, Statistiken und Wahrscheinlichkeiten richtig lesen und interpretieren. Dafür brauchen Sie keinen Statistikkurs zu belegen und kein Mathegenie zu sein. Für alles gibt es in Excel die passende Funktion und das passende Werkzeug. So können Sie Theorie und Praxis sofort miteinander verbinden.

Practical and Clear Graduate Statistics in Excel - The Excel Statistical Master

Author: Mark Harmon

Publisher: N.A

ISBN: 9781937159139

Category: Education

Page: 478

View: 9951

DOWNLOAD NOW »
Complete and practical yet easy-to-understand graduate-level statistics instruction with ALL of the problems and examples worked out in the accompanying Excel workbooks. Thoroughly covers all topics of an intense graduate statistics course using nothing but step-by-step, simple explanations. Some of the major topics covered with easy-to-follow explanations and fully described and demonstrated in detail in Excel include: 1) ALL types of t-Tests (1-sample, 2-sample pooled and unpooled, and paired) and z tests including verification of ALL required assumptions * 2) Single-variable and multiple regression (includes verification of ALL required assumptions and ALL underlying formulas used to produce Excel regression output) * 3) Logistic regression (Logit and P(X), MLL, Max Log-Likelihood Function, R Square (Cox and Snell and Nagelkerke), variable significance with Likelihood Ratio, Classification Table, Hosmer-Lemeshow) * 4) Normality Tests (Kolmogorov-Smirnov, Anderson-Darlington, Shapiro-Wilk, Automated Histograms) * 5) Single-factor and two-factor ANOVA with and without replication including verification of ALL required assumptions and ALL underlying formulas used to produce Excel ANOVA output * 6) Post-Hoc tests for ANOVA (Tukey's HSD, Tukey-Kramer, Games-Howell) * 7) ANOVA substitute tests (Welch's ANOVA, Brown-Forsythe F test) * 8) Variance comparison tests (F test, Levene's test, Brown-Forsythe test) * 9) Effect size tests (Eta square, RMSSE, Omega square) * 10) Detailed description of calculating test power using the online utility G*Power for all types of tests) * 11) Nonparametric tests (Mann-Whitney U test alternative for 2-sample t-Tests, Wilcoxon Signed-Rank test alternative for 1-sample and paired t-Tests, Kruskal-Wallis test alternative for 1-way ANOVA, Scheirer-Ray-Hare test alternative for 2-way ANOVA, Sign Test) * 11) Chi-Square tests (Goodness-of-Fit, Independence tests, and population variance tests) * 12) Confidence intervals of population means and of population proportions (includes calculation of min sample size and verification of ALL required assumptions) * 13) Combinations and Permutations (many different examples of each) * 14) Correlations - Pearson and Spearman (includes calculation of r Critical and p value of calculated r) * 15) Covariance * 16) Automated histograms, sorting, and charting created with formulas that automatically re-calculate when data changes * 17) Central Limit Theorem demonstrated in Excel * 18) Lots of problems solved in Excel using the following distributions: Normal, t, Binomial, Negative Binomial, F, Chi-Square, Poisson, Exponential, Uniform, Geometric, Beta, Gamma, Hypergeometric, and Multinomial * 19) Instructions to create user-interactive PDF and CDF graphs in Excel for the following distributions: Normal, t, Binomial, Chi-Square, Poisson, Exponential, Uniform, Beta, Gamma, and Hypergeometric * This book is complete and thorough enough for the professional statistician but simple and clear enough for the new statistics student. The reader of this book will become an Excel Statistical Master!

Statistical Analysis with Excel For Dummies

Author: Joseph Schmuller

Publisher: John Wiley & Sons

ISBN: 0470535423

Category: Computers

Page: 504

View: 345

DOWNLOAD NOW »
You too can understand the statistics of life, even if you're math-challenged! What do you need to calculate? Manufacturing output? A curve for test scores? Sports stats? You and Excel can do it, and this non-intimidating guide shows you how. It demystifies the different types of statistics, how Excel functions and formulas work, the meaning of means and medians, how to interpret your figures, and more — in plain English. Getting there — learn how variables, samples, and probability are used to get the information you want Excel tricks — find out what's built into the program to help you work with Excel formulas Playing with worksheets — get acquainted with the worksheet functions for each step Graphic displays — present your data as pie graphs, bar graphs, line graphs, or scatter plots What's normal? — understand normal distribution and probability Hyping hypotheses — learn to use hypothesis testing with means and variables When regression is progress — discover when and how to use regression for forecasting What are the odds — work with probability, random variables, and binomial distribution Open the book and find: Ten statistical and graphical tips and traps The difference between descriptive and inferential statistics Why graphs are good How to measure variations What standard scores are and why they're used When to use two-sample hypothesis testing How to use correlations Different ways of working with probability

Excel 2007 for Business Statistics

A Guide to Solving Practical Business Problems

Author: Thomas J Quirk

Publisher: Springer Science & Business Media

ISBN: 1461437342

Category: Business & Economics

Page: 244

View: 5478

DOWNLOAD NOW »
​​ ​ This is the first book to show the capabilities of Microsoft Excel to teach business statistics effectively. It is a step-by-step exercise-driven guide for students and practitioners who need to master Excel to solve practical business problems. If understanding statistics isn’t your strongest suit, you are not especially mathematically-inclined, or if you are wary of computers, this is the right book for you. Excel, a widely available computer program for students and managers, is also an effective teaching and learning tool for quantitative analyses in business courses. Its powerful computational ability and graphical functions make learning statistics much easier than in years past. However, Excel 2007 for Business Statistics: A Guide to Solving Practical Business Problems is the first book to capitalize on these improvements by teaching students and managers how to apply Excel to statistical techniques necessary in their courses and work. Each chapter explains statistical formulas and directs the reader to use Excel commands to solve specific, easy-to-understand business problems. Practice problems are provided at the end of each chapter with their solutions in an appendix. Separately, there is a full Practice Test (with answers in an Appendix) that allows readers to test what they have learned.

Advanced Regression in Excel - the Excel Statistical Master

Author: Mark Harmon

Publisher: N.A

ISBN: 9781937159146

Category: Education

Page: 90

View: 9966

DOWNLOAD NOW »
Complete step-by-step instructions and videos showing exactly how to perform a variety of advanced regression techniques and how to do them all in Excel. Some of these advanced regression techniques include nonlinear regression, logistic regression, and dummy-variable regression. This manual will also clearly explain all of the steps of a regression and how to quickly read the output of regression done in Excel. This manual is loaded with completed examples, screenshots, and videos of the advanced regression techniques all being performed in Excel. The instructions, screenshots, and videos are clear and easy-to-follow but at the graduate level. If you are currently taking a difficult graduate-level statistics course that covers advanced regression techniques such as nonlinear regression, logistic regression, or dummy-variable regression, you will find this manual to be an outstanding course supplement that will explain these advanced regression techniques much more clearly than your textbook does. If you are a business manager, you will really appreciate how easily and clearly this manual will show you how you can perform these advanced regression techniques in Excel to solve difficult statistical problems on your job. Nonlinear regression, logistic regression, and dummy-variable regression are extremely useful in business, but are not widely understood. For example, you can use logistic regression to accurately calculate the probability that your next customer will make a purchase. That use of logistic regression is covered in detail in this manual. A detailed model of dummy-variable regression is provided in the manual which shows how to calculate how important each attribute of your product is to your customers. Not many people have a working knowledge of these advanced and useful regression techniques. You will. This manual will make you an Excel Statistical Master of nonlinear regression, logistic regression, dummy-variable regression, and thoroughly understanding every part of the output of Excel regression. You will be one of the few that know how every necessary step when doing regression in Excel.

Modern Business Statistics with Microsoft Office Excel (with XLSTAT Education Edition Printed Access Card)

Author: David R. Anderson,Dennis J. Sweeney,Thomas A. Williams,Jeffrey D. Camm,James J. Cochran

Publisher: Cengage Learning

ISBN: 1337516678

Category: Business & Economics

Page: 1056

View: 3768

DOWNLOAD NOW »
Gain a strong conceptual understanding of statistics as MODERN BUSINESS STATISTICS, 6E balances real-world applications with an integrated focus on Microsoft Excel 2016. This best-selling, comprehensive book clearly develops each statistical technique in an application setting. The integrated approach focuses on statistical methodology with an easy-to-follow presentation of a statistical procedure followed by a discussion of how to use Excel to perform the procedure. Step-by-step instructions and screen ensure understanding. Business examples, proven methods, and application exercises demonstrate how statistical results provide insights into business decisions and help resolve business problems. A problem-scenario approach emphasizes how to apply statistical methods to practical business situations. New case problems and self-tests let you check personal understanding and help you master both Excel 2016 skills and an understanding of business statistics. Important Notice: Media content referenced within the product description or the product text may not be available in the ebook version.

The Excel Statistics Cookbook, Second Edition

Author: N.A

Publisher: Lulu.com

ISBN: 9970041622

Category: Electronic spreadsheets

Page: 65

View: 868

DOWNLOAD NOW »
Provides step-by-step illustrated instructions for performing the most common statistical procedures in Microsoft Excel. Topics covered: data structures and data lists, descriptive statistics, charts and graphs, one-sample t test, independent samples t test, dependent samples t test, one-way ANOVA, repeated-measures ANOVA, correlation and regression, chi-square tests.

The Excel Statistics Companion 2.0

Author: Kenneth M. Rosenberg

Publisher: Wadsworth Publishing Company

ISBN: 9780495186953

Category: Computers

Page: 220

View: 384

DOWNLOAD NOW »
Master statistical concepts and computational procedures with EXCEL STATISTICS COMPANION ON CD-ROM AND MANUAL! A collection of demonstrations, sampling experiments, and interactive experiments, this CD-ROM/manual package provides you with hands-on experience you need to succeed in statistics. With on-screen instructions, reviews, and step-by-step approaches, you will easily learn basic statistical concepts and how to use computer programs to solve problems.

Nonparametric Testing in Excel - The Excel Statistical Master

Author: Mark Harmon

Publisher: N.A

ISBN: 9781937159030

Category: Business & Economics

Page: 104

View: 5809

DOWNLOAD NOW »
Complete step-by-step instructions showing how to perform nearly every major type of nonparametric test and how to do each one of them in Excel. This manual will make you an expert on knowing exactly how and when to use and set up in Excel all types of nonparametric tests, such as the Mann Whitney U Test, the Kruskall Wallis Test, the Wilcoxon Rank Sum Test for both large and small samples, the Spearman Correlation Coefficient Test, the Sign Test, and the Wilcoxon Signed Rank Test for both large and small samples. This manual is loaded with completed examples and screenshots in Excel of all the above of nonparametric tests being performed. The instructions are clear and easy-to-follow but at the graduate level. Nothing but simple explanations all taught in small-bite-size lessons. The emphasis is on problem solving, not on useless, complicated, hard-to-apply theory that fills many statistics course. If you are currently taking a difficult graduate-level statistics course that covers nonparametric or normality tests, you will find this manual to be an outstanding course supplement that will explain nonparametric tests much more clearly than your textbook does. Every lesson uses Excel. You'll be glad to know that you'll never have to look up anything on statistical charts ever again. The easy-to-follow frameworks in this manual can be cleanly and swiftly duplicated in the real world and on statistics exams by hand (without Excel) right away. If you are a business manager, you will really appreciate how easily and clearly this manual will show you how you can perform nonparametric tests in Excel to solve difficult statistical problems on your job. You already know Excel so no new software is necessary. You don't need SPSS, SAS, SyStat, or Minitab (all of those are expensive, require lots of user training, and expect the user to be an expert statistician right from the start. Not Excel nor this book. This manual achieves two goals: teaching graduate-level nonparametric testing statistical frameworks in an easy-to-understand, real-world, practical way and then showing how to implement all of it in Excel. Nonparametric tests are very important statistical tests in business, but are not widely understood. Nonparametric testing must nearly always be performed in place of most well-known statistics tests when it is not known that samples are being taken from a normally distributed population. This is more often the case than not, yet not many people have a working knowledge of nonparametric testing. You will. This manual will make you an Excel Statistical Master of nonparametric testing.

Bundle: Salkind: Excel Statistics 3e + Salkind: Statistics for People Who (Think They) Hate Statistics (Excel 2010 Edition) 3e + Salkind: Statistics F

Author: Neil J. Salkind

Publisher: Sage Publications, Incorporated

ISBN: 9781506320984

Category: Social Science

Page: N.A

View: 8154

DOWNLOAD NOW »
This bundle includes Salkind: Excel Statistics 3e, Salkind: Statistics for People Who (Think They) Hate Statistics (Excel 2010 Edition) 3e, and Salkind: Statistics for People Who (Think They) Hate Statistics Electronic Version (Excel 2010 Edition) 3e

Using Statistics in the Social and Health Sciences with SPSS and Excel

Author: Martin Lee Abbott

Publisher: John Wiley & Sons

ISBN: 111912106X

Category: Social Science

Page: 600

View: 5439

DOWNLOAD NOW »
Provides a step-by-step approach to statistical procedures to analyze data and conduct research, with detailed sections in each chapter explaining SPSS® and Excel® applications This book identifies connections between statistical applications and research design using cases, examples, and discussion of specific topics from the social and health sciences. Researched and class-tested to ensure an accessible presentation, the book combines clear, step-by-step explanations for both the novice and professional alike to understand the fundamental statistical practices for organizing, analyzing, and drawing conclusions from research data in their field. The book begins with an introduction to descriptive and inferential statistics and then acquaints readers with important features of statistical applications (SPSS and Excel) that support statistical analysis and decision making. Subsequent chapters treat the procedures commonly employed when working with data across various fields of social science research. Individual chapters are devoted to specific statistical procedures, each ending with lab application exercises that pose research questions, examine the questions through their application in SPSS and Excel, and conclude with a brief research report that outlines key findings drawn from the results. Real-world examples and data from social and health sciences research are used throughout the book, allowing readers to reinforce their comprehension of the material. Using Statistics in the Social and Health Sciences with SPSS® and Excel® includes: Use of straightforward procedures and examples that help students focus on understanding of analysis and interpretation of findings Inclusion of a data lab section in each chapter that provides relevant, clear examples Introduction to advanced statistical procedures in chapter sections (e.g., regression diagnostics) and separate chapters (e.g., multiple linear regression) for greater relevance to real-world research needs Emphasizing applied statistical analyses, this book can serve as the primary text in undergraduate and graduate university courses within departments of sociology, psychology, urban studies, health sciences, and public health, as well as other related departments. It will also be useful to statistics practitioners through extended sections using SPSS® and Excel® for analyzing data.

Six Sigma Statistics with Excel: Statistical Process Control

Author: Issa Bass

Publisher: McGraw Hill Professional

ISBN: 0071735429

Category: Business & Economics

Page: 35

View: 7509

DOWNLOAD NOW »
Here is a chapter from Six Sigma Statistics with Excel and MINITAB. This is a comprehensive and easy-to-use guide for understanding and using Excel and MINITAB programs for Six Sigma statistical data analysis. Each chapter includes relevant theory and technique, step-by-step exercises, case studies, graphical illustrations and screen shots for performing the techniques in both Excel and MINITAB.

Six Sigma Statistics with EXCEL and MINITAB

Author: Issa Bass

Publisher: McGraw Hill Professional

ISBN: 9780071542685

Category: Business & Economics

Page: 374

View: 9084

DOWNLOAD NOW »
Master the Statistical Techniques for Six Sigma Operations, While Boosting Your Excel and Minitab Skills! Now with the help of this “one-stop” resource, operations and production managers can learn all the powerful statistical techniques for Six Sigma operations, while becoming proficient at Excel and Minitab at the same time. Six Sigma Statistics with Excel and Minitab offers a complete guide to Six Sigma statistical methods, plus expert coverage of Excel and Minitab, two of today's most popular programs for statistical analysis and data visualization. Written by a seasoned Six Sigma Master Black Belt, the book explains how to create and interpret dot plots, histograms, and box plots using Minitab...decide on sampling strategies, sample size, and confidence intervals...apply hypothesis tests to compare variance, means, and proportions...conduct a regression and residual analysis...design and analyze an experiment...and much more. Filled with clear, concise accounts of the theory for each statistical method presented, Six Sigma Statistics with Excel and Minitab features: Easy-to-follow explanations of powerful Six Sigma tools A wealth of exercises and case studies 200 graphical illustrations for Excel and Minitab Essential for achieving Six Sigma goals in any organization, Six Sigma Statistics with Excel and Minitab is a unique, skills-building toolkit for mastering a wide range of vital statistical techniques, and for capitalizing on the potential of Excel and Minitab. Six Sigma Statistical with Excel and Minitab offers operations and production managers a complete guide to Six Sigma statistical techniques, together with expert coverage of Excel and Minitab, two of today's most popular programs for statistical analysis and data visualization. Written by Issa Bass, a Six Sigma Master Black Belt with years of hands-on experience in industry, this on-target resource takes readers through the application of each Six Sigma statistical tool, while presenting a straightforward tutorial for effectively utilizing Excel and Minitab. With the help of this essential reference, managers can: Acquire the basic tools for data collection, organization, and description Learn the fundamental principles of probability Create and interpret dot plots, histograms, and box plots using Minitab Decide on sampling strategies, sample size, and confidence intervals Apply hypothesis tests to compare variance, means, and proportions Stay on top of production processes with statistical process control Use process capability analysis to ensure that processes meet customers' expectations Employ analysis of variance to make inferences about more than two population means Conduct a regression and residual analysis Design and analyze an experiment In addition, Six Sigma Statistics with Excel and Minitab enables you to develop a better understanding of the Taguchi Method...use measurement system analysis to find out if measurement processes are accurate...discover how to test ordinal or nominal data with nonparametric statistics...and apply the full range of basic quality tools. Filled with step-by-step exercises, graphical illustrations, and screen shots for performing Six Sigma techniques on Excel and Minitab, the book also provides clear, concise explanations of the theory for each of the statistical tools presented. Authoritative and comprehensive, Six Sigma Statistics with Excel and Minitab is a valuable skills-building resource for mastering all the statistical techniques for Six Sigma operations, while harnessing the power of Excel and Minitab.

Hypothesis Testing in Excel - The Excel Statistical Master

Author: Mark Harmon

Publisher: N.A

ISBN: 9781937159023

Category: Business & Economics

Page: 142

View: 2894

DOWNLOAD NOW »
Complete step-by-step instructions showing how to perform every type of hypothesis test and how to do each in Excel. This manual will make you an expert on knowing exactly how and when to use all types of hypothesis tests (hypothesis tests of mean vs. proportion, one-tailed vs. two-tailed tests, one-sample vs. two-sample tests, and unpaired data vs. paired data tests) and how to set them all up in Excel. This manual is loaded with completed problems and screenshots in Excel of all major variations of hypothesis tests. All hypothesis tests regardless of type can be solved in four steps. This manual walks you through that four-step process during each of the many solved problems. The instructions are clear and easy-to-follow but at the graduate level. Nothing but simple explanations all taught in small-bite-size lessons. The emphasis is on problem solving, not on useless, complicated, hard-to-apply theory that fills many statistics course. If you are currently taking a difficult graduate-level statistics course that covers hypothesis tests, you will find this manual to be an outstanding course supplement that will explain hypothesis testing much more clearly than your textbook does. Every lesson uses Excel. You'll be glad to know that you'll never have to look up anything on statistical charts ever again. The easy-to-follow frameworks in this manual can be cleanly and swiftly duplicated in the real world and on statistics exams by hand (without Excel) right away. If you are a business manager, you will really appreciate how easily and clearly this manual will show you how you can perform hypothesis tests in Excel to solve difficult statistical problems on your job. You already know Excel so no new software is necessary. You don't need SPSS, SAS, SyStat, or Minitab (all of those are expensive, require lots of user training, and expect the user to be an expert statistician right from the start. Not Excel nor this book. This manual achieves two goals: teaching graduate-level hypothesis testing statistical frameworks in an easy-to-understand, real-world, practical way and then showing how to implement all of it in Excel. Hypothesis tests are the most widely-used statistical tests in business. This manual will make you an Excel Statistical Master of hypothesis testing.

Excel 2013 for Human Resource Management Statistics

A Guide to Solving Practical Problems

Author: Thomas J. Quirk,Julie Palmer-Schuyler

Publisher: Springer

ISBN: 3319289829

Category: Social Science

Page: 252

View: 4458

DOWNLOAD NOW »
This book shows how Microsoft Excel is able to teach human resource management statistics effectively. Similar to the previously published Excel 2010 for Human Resource Management Statistics, it is a step-by-step exercise-driven guide for students and practitioners who need to master Excel to solve practical human resource management problems. If understanding statistics isn’t your strongest suit, you are not especially mathematically-inclined, or if you are wary of computers, this is the right book for you. Excel, a widely available computer program for students and managers, is also an effective teaching and learning tool for quantitative analyses in human resource management courses. Its powerful computational ability and graphical functions make learning statistics much easier than in years past. Excel 2013 for Human Resource Management Statistics: A Guide to Solving Practical Problems is the next book to capitalize on these improvements by teaching students and managers how to apply Excel to statistical techniques necessary in their courses and work. Each chapter explains statistical formulas and directs the reader to use Excel commands to solve specific, easy-to-understand human resource management problems. Practice problems are provided at the end of each chapter with their solutions in an Appendix. Separately, there is a full Practice Test (with answers in an Appendix) that allows readers to test what they have learned.

Statistics for Health Policy and Administration Using Microsoft Excel

Author: James E. Veney

Publisher: Jossey-Bass

ISBN: N.A

Category: Medical

Page: 496

View: 5944

DOWNLOAD NOW »
Statistics for Health Policy and Administration Using Microsoft Excel provides an introduction to the use of statistics in health policy and health administration-related fields. The book is keyed to the powerful statistical tool Microsoft Excel and shows how to prepare data and understand the data display capabilities of the program. It also offers the information needed to master probability— the foundation of statistical analysis. This important book is structured around illustrative examples that are demonstrated with Excel displays. The book is filled with step-by-step discussions of how statistical problems are solved using Excel, and it contains a wealth of exercises addressing the material covered in each section. Many of the book's exercises include the replication of examples so that the student has an immediate reference with which to compare his or her work and determine whether or not the procedure was carried out correctly. Additional exercises are provided for further practice to reinforce the valuable lessons learned

Excel 2013 for Biological and Life Sciences Statistics

A Guide to Solving Practical Problems

Author: Thomas J Quirk,Meghan Quirk,Howard F Horton

Publisher: Springer

ISBN: 3319125176

Category: Medical

Page: 254

View: 8303

DOWNLOAD NOW »
This is the first book to show the capabilities of Microsoft Excel to teach biological and life sciences statistics effectively. It is a step-by-step exercise-driven guide for students and practitioners who need to master Excel to solve practical science problems. If understanding statistics isn’t your strongest suit, you are not especially mathematically-inclined, or if you are wary of computers, this is the right book for you. Excel, a widely available computer program for students and managers, is also an effective teaching and learning tool for quantitative analyses in science courses. Its powerful computational ability and graphical functions make learning statistics much easier than in years past. However, Excel 2013 for Biological and Life Sciences Statistics: A Guide to Solving Practical Problems is the first book to capitalize on these improvements by teaching students and managers how to apply Excel to statistical techniques necessary in their courses and work. Each chapter explains statistical formulas and directs the reader to use Excel commands to solve specific, easy-to-understand science problems. Practice problems are provided at the end of each chapter with their solutions in an appendix. Separately, there is a full Practice Test (with answers in an Appendix) that allows readers to test what they have learned.

Excel 2013 for Educational and Psychological Statistics

A Guide to Solving Practical Problems

Author: Thomas J. Quirk

Publisher: Springer

ISBN: 3319267124

Category: Social Science

Page: 258

View: 4616

DOWNLOAD NOW »
This is the first book to show the capabilities of Microsoft Excel to teach educational and psychological statistics effectively. It is a step-by-step exercise-driven guide for students and practitioners who need to master Excel to solve practical problems in education and psychology. If understanding statistics isn’t your strongest suit, you are not especially mathematically-inclined, or if you are wary of computers, this is the right book for you. Excel, a widely available computer program for students and practitioners, is also an effective teaching and learning tool for quantitative analyses in statistics courses. Its powerful computational ability and graphical functions make learning statistics much easier than in years past. However, Excel 2013 for Educational and Psychological Statistics: A Guide to Solving Practical Problems is the first book to capitalize on these improvements by teaching students and practitioners how to apply Excel to statistical techniques necessary in their courses and work. Each chapter explains statistical formulas and directs the reader to use Excel commands to solve specific, easy-to-understand problems in education and psychology. Practice problems are provided at the end of each chapter with their solutions in an appendix. Separately, there is a full Practice Test (with answers in an Appendix) that allows readers to test what they have learned.

Modern Business Statistics with Microsoft Excel

Author: David R. Anderson,Dennis J. Sweeney,Thomas A. Williams

Publisher: Cengage Learning

ISBN: 128596831X

Category: Education

Page: 1056

View: 4162

DOWNLOAD NOW »
MODERN BUSINESS STATISTICS, 5E allows students to gain a strong conceptual understanding of statistics with a balance of real-world applications and a focus on the integrated strengths of Microsoft Excel 2013. To ensure student understanding, this best-selling, comprehensive text carefully discusses and clearly develops each statistical technique in a solid application setting. Microsoft Excel 2013 instruction, which is integrated in each chapter, plays an integral part in strengthening this edition's applications orientation. Immediately after each easy-to-follow presentation of a statistical procedure, a subsection discusses how to use Excel to perform the procedure. This integrated approach emphasizes the applications of Excel while focusing on the statistical methodology. Step-by-step instructions and screen captures further clarify student learning. A wealth of timely business examples, proven methods, and additional exercises throughout this edition demonstrate how statistical results provide insights into business decisions and present solutions to contemporary business problems. High-quality problems noted for their unwavering accuracy and the authors' signature problem-scenario approach clearly show how to apply statistical methods to practical business situations. New case problems and self-tests allow students to challenge their personal understanding. Important Notice: Media content referenced within the product description or the product text may not be available in the ebook version.