The Excel Data and Statistics Cookbook, Third Edition

The Excel Data and Statistics Cookbook, Third Edition
Author: Larry Pace
Publisher: Lulu.com
Total Pages: 207
Release: 2012-11-12
Genre: Computers
ISBN: 0988630001

The Excel Data and Statistics Cookbook,3rd edition, covers all the basic descriptive and inferential statistics taught in an introductory class. Completely updated to illustrate Excel 2013, 2011 (for Mac), and 2010, this book is classroom-tested and instructor-approved.

The Excel Statistics Cookbook, Second Edition

The Excel Statistics Cookbook, Second Edition
Author: Larry Alton Pace
Publisher: Lulu.com
Total Pages: 65
Release: 2006
Genre: Electronic spreadsheets
ISBN: 9789970041626

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.

Data and Statistics Cookbook with Excel 2007

Data and Statistics Cookbook with Excel 2007
Author: Larry Alton Pace
Publisher:
Total Pages: 0
Release: 2011
Genre: Electronic spreadsheets
ISBN: 9780205840670

"Over the past several years, there has been an increased interest in the use of spreadsheets for teaching and learning basic statistics. This movement began in business schools, where spreadsheets are used extensively, but has recently expanded to the sciences and more recently, the social sciences. This book about using a widely available spreadsheet program for basic statistics can be used as a course supplement or as a standalone text. Topics covered include those commonly taught in a first course (or two-course sequence) in basic descriptive and inferential statistics. Although the text makes repeated use of certain datasets, each chapter serves as a standalone module, so instructors can skip the topics they do not wish to cover."--Publisher's website.

Excel Scientific and Engineering Cookbook

Excel Scientific and Engineering Cookbook
Author: David M Bourg
Publisher: "O'Reilly Media, Inc."
Total Pages: 445
Release: 2006-01-17
Genre: Computers
ISBN: 059655317X

Given the improved analytical capabilities of Excel, scientists and engineers everywhere are using it--instead of FORTRAN--to solve problems. And why not? Excel is installed on millions of computers, features a rich set of built-in analyses tools, and includes an integrated Visual Basic for Applications (VBA) programming language. No wonder it's today's computing tool of choice. Chances are you already use Excel to perform some fairly routine calculations. Now the Excel Scientific and Engineering Cookbook shows you how to leverage Excel to perform more complex calculations, too, calculations that once fell in the domain of specialized tools. It does so by putting a smorgasbord of data analysis techniques right at your fingertips. The book shows how to perform these useful tasks and others: Use Excel and VBA in general Import data from a variety of sources Analyze data Perform calculations Visualize the results for interpretation and presentation Use Excel to solve specific science and engineering problems Wherever possible, the Excel Scientific and Engineering Cookbook draws on real-world examples from a range of scientific disciplines such as biology, chemistry, and physics. This way, you'll be better prepared to solve the problems you face in your everyday scientific or engineering tasks. High on practicality and low on theory, this quick, look-up reference provides instant solutions, or "recipes," to problems both basic and advanced. And like other books in O'Reilly's popular Cookbook format, each recipe also includes a discussion on how and why it works. As a result, you can take comfort in knowing that complete, practical answers are a mere page-flip away.

SPSS Statistics For Dummies

SPSS Statistics For Dummies
Author: Jesus Salcedo
Publisher: John Wiley & Sons
Total Pages: 487
Release: 2020-09-09
Genre: Business & Economics
ISBN: 1119560837

The fun and friendly guide to mastering IBM’s Statistical Package for the Social Sciences Written by an author team with a combined 55 years of experience using SPSS, this updated guide takes the guesswork out of the subject and helps you get the most out of using the leader in predictive analysis. Covering the latest release and updates to SPSS 27.0, and including more than 150 pages of basic statistical theory, it helps you understand the mechanics behind the calculations, perform predictive analysis, produce informative graphs, and more. You’ll even dabble in programming as you expand SPSS functionality to suit your specific needs. Master the fundamental mechanics of SPSS Learn how to get data into and out of the program Graph and analyze your data more accurately and efficiently Program SPSS with Command Syntax Get ready to start handling data like a pro—with step-by-step instruction and expert advice!

R Through Excel

R Through Excel
Author: Richard M. Heiberger
Publisher: Springer Science & Business Media
Total Pages: 357
Release: 2010-01-23
Genre: Computers
ISBN: 1441900527

In this book, the authors build on RExcel, a free add-in for Excel that can be downloaded from the R distribution network. RExcel seamlessly integrates the entire set of R's statistical and graphical methods into Excel, allowing students to focus on statistical methods and concepts and minimizing the distraction of learning a new programming language.

The Excel 2007 Data and Statistics Cookbook

The Excel 2007 Data and Statistics Cookbook
Author: Larry Alton Pace
Publisher:
Total Pages: 132
Release: 2008-01-01
Genre: Electronic data processing
ISBN: 9780979977527

Provides point-and-click access to the most common basic descriptive and inferential statistics. Topics include: the Excel 2007 interface, data management features of Excel 2007, tables and pivot tables, descriptive statistics, charts and graphs, working with z scores and the normal distribution, installing and using the analysis toolpak, one-sample t tests, paired-samples t tests, independent-samples t tests, one-way ANOVA, repeated-measures ANOVA, correlation and regression, Chi-square tests, post hoc comparisons, and effect size.

Head First Data Analysis

Head First Data Analysis
Author: Michael Milton
Publisher: "O'Reilly Media, Inc."
Total Pages: 486
Release: 2009-07-24
Genre: Business & Economics
ISBN: 0596153937

A guide for data managers and analyzers. It shares guidelines for identifying patterns, predicting future outcomes, and presenting findings to others.

R Cookbook

R Cookbook
Author: Paul Teetor
Publisher: "O'Reilly Media, Inc."
Total Pages: 438
Release: 2011-03-03
Genre: Computers
ISBN: 1449307264

With more than 200 practical recipes, this book helps you perform data analysis with R quickly and efficiently. The R language provides everything you need to do statistical work, but its structure can be difficult to master. This collection of concise, task-oriented recipes makes you productive with R immediately, with solutions ranging from basic tasks to input and output, general statistics, graphics, and linear regression. Each recipe addresses a specific problem, with a discussion that explains the solution and offers insight into how it works. If you’re a beginner, R Cookbook will help get you started. If you’re an experienced data programmer, it will jog your memory and expand your horizons. You’ll get the job done faster and learn more about R in the process. Create vectors, handle variables, and perform other basic functions Input and output data Tackle data structures such as matrices, lists, factors, and data frames Work with probability, probability distributions, and random variables Calculate statistics and confidence intervals, and perform statistical tests Create a variety of graphic displays Build statistical models with linear regressions and analysis of variance (ANOVA) Explore advanced statistical techniques, such as finding clusters in your data "Wonderfully readable, R Cookbook serves not only as a solutions manual of sorts, but as a truly enjoyable way to explore the R language—one practical example at a time."—Jeffrey Ryan, software consultant and R package author