Statistics as Easy as 1, 2, 3 with Microsoft Excel for Windows

Statistics as Easy as 1, 2, 3 with Microsoft Excel for Windows
Author: Christian N. Madu
Publisher: Chi Publishers Inc
Total Pages: 182
Release: 2003
Genre: Business & Economics
ISBN: 9780967602325

This title has been written as a basic statistical applications book for non-statistics majors. It focuses on the use of Microsoft Excel Add-Ins function in analyzing basic statistical problems. It is intended for beginners, and it introduces statistical concepts in ways that may be relevant to practitioners. The data used throughout the book is based on responses to common social issues. This way, the book can be relevant to multiple users with different backgrounds. The topics covered include: questionnaire design, descriptive statistics; hypothesis testing; confidence interval estimation; nonparametric statistics; and simple and multiple regression analysis. of statistics. Students majoring in business, health sciences, and social sciences are also likely to find the book useful in understanding statistical concepts. Practitioners who may be interested in exploring the power of Microsoft Excel for statistical analysis should also find the book very useful.

Statistical Analysis

Statistical Analysis
Author: Conrad Carlberg
Publisher: Que Publishing
Total Pages: 714
Release: 2014-04-04
Genre: Business & Economics
ISBN: 0133823997

Use Excel 2013’s statistical tools to transform your data into knowledge Conrad Carlberg shows how to use Excel 2013 to perform core statistical tasks every business professional, student, and researcher should master. Using real-world examples, Carlberg helps you choose the right technique for each problem and get the most out of Excel’s statistical features, including recently introduced consistency functions. Along the way, he clarifies confusing statistical terminology and helps you avoid common mistakes. You’ll learn how to use correlation and regression, analyze variance and covariance, and test statistical hypotheses using the normal, binomial, t, and F distributions. To help you make accurate inferences based on samples from a population, this edition adds two more chapters on inferential statistics, covering crucial topics ranging from experimental design to the statistical power of F tests. Becoming an expert with Excel statistics has never been easier! You’ll find crystal-clear instructions, insider insights, and complete step-by-step projects—all complemented by extensive web-based resources. Master Excel’s most useful descriptive and inferential statistical tools Tell the truth with statistics—and recognize when others don’t Accurately summarize sets of values Infer a population’s characteristics from a sample’s frequency distribution Explore correlation and regression to learn how variables move in tandem Use Excel consistency functions such as STDEV.S() and STDEV.P() Test differences between two means using z tests, t tests, and Excel’s Data Analysis Add-in Use ANOVA to test differences between more than two means Explore statistical power by manipulating mean differences, standard errors, directionality, and alpha Take advantage of Recommended PivotTables, Quick Analysis, and other Excel 2013 shortcuts

Understanding Educational Statistics Using Microsoft Excel and SPSS

Understanding Educational Statistics Using Microsoft Excel and SPSS
Author: Martin Lee Abbott
Publisher: John Wiley & Sons
Total Pages: 446
Release: 2014-08-21
Genre: Mathematics
ISBN: 1118627180

Utilizing the latest software, this book presents the essential statistical procedures for drawing valuable results from data in the social sciences. Mobilizing interesting real-world examples from the field of education, Understanding Educational Statistics Using Microsoft Excel and SPSS supplies a seamless presentation that identifies valuable connections between statistical applications and research design. Class-tested to ensure an accessible presentation, the book combines clear, step-by-step explanations and the use of software packages that are accessible to both the novice and professional alike to present the fundamental statistical practices for organizing, understanding, and drawing conclusions from educational research data. The book begines with an introduction to descriptive and inferential statistics and then proceeds to acquaint readers with the various functions for working with quantitative data in the Microsoft Excel environment, such as spreadsheet navigation; sorting and filtering; and creating pivot tables. Subsequent chapters treat the procedures that are commonly-employed when working with data across various fields of social science research, including: Single-sample tests Repeated measure tests Independent t-tests One way ANOVA and factorial ANOVA Correlation Bivariate regression Chi square Multiple regression Individual chapters are devoted to specific procedures, each ending with a lab exercise that highlights the importance of that procedure by posing a research question, examining the question through its application in Excel and SPSS, and concluding with a brief research report that outlines key findings drawn from the results. Real-world examples and data from modern educational research are used throughout the book, and a related Web site features additional data sets, examples, and labs, allowing readers to reinforce their comprehension of the material. Bridging traditional statistical topics with the latest software and applications in the field of education, Understanding Educational Statistics Using Microsoft Excel and SPSS is an excellent book for courses on educational research methods and introductory statistics in the social sciences at the upper-undergraduate and graduate levels. It also serves as a valuable resource for researchers and practitioners in the fields of education, psychology, and the social sciences who require a statistical background to work with data in their everyday work.

PC Mag

PC Mag
Author:
Publisher:
Total Pages: 536
Release: 1992-10-13
Genre:
ISBN:

PCMag.com is a leading authority on technology, delivering Labs-based, independent reviews of the latest products and services. Our expert industry analysis and practical solutions help you make better buying decisions and get more from technology.

PC Mag

PC Mag
Author:
Publisher:
Total Pages: 408
Release: 1990-04-10
Genre:
ISBN:

PCMag.com is a leading authority on technology, delivering Labs-based, independent reviews of the latest products and services. Our expert industry analysis and practical solutions help you make better buying decisions and get more from technology.

PC Mag

PC Mag
Author:
Publisher:
Total Pages: 530
Release: 1993-02-09
Genre:
ISBN:

PCMag.com is a leading authority on technology, delivering Labs-based, independent reviews of the latest products and services. Our expert industry analysis and practical solutions help you make better buying decisions and get more from technology.

A Microsoft Excel Companion for Business Statistics

A Microsoft Excel Companion for Business Statistics
Author: David L. Eldredge
Publisher: South-Western College
Total Pages: 300
Release: 2005
Genre: Business & Economics
ISBN:

Provides step-by-step instructions for using Excel to solve most of the problems found in introductory business statistics. Screen captures show data input, pull-down menus, dialog boxes, and statistical results.

PC Mag

PC Mag
Author:
Publisher:
Total Pages: 452
Release: 1994-01-11
Genre:
ISBN:

PCMag.com is a leading authority on technology, delivering Labs-based, independent reviews of the latest products and services. Our expert industry analysis and practical solutions help you make better buying decisions and get more from technology.

PC Mag

PC Mag
Author:
Publisher:
Total Pages: 530
Release: 1993-02-09
Genre:
ISBN:

PCMag.com is a leading authority on technology, delivering Labs-based, independent reviews of the latest products and services. Our expert industry analysis and practical solutions help you make better buying decisions and get more from technology.

PC Mag

PC Mag
Author:
Publisher:
Total Pages: 416
Release: 1996-02-06
Genre:
ISBN:

PCMag.com is a leading authority on technology, delivering Labs-based, independent reviews of the latest products and services. Our expert industry analysis and practical solutions help you make better buying decisions and get more from technology.