Home | Amazing | Today | Tags | Publishers | Years | Account | Search 
Statistical Analysis: Microsoft Excel 2010

Statistical Analysis: Microsoft Excel 2010, 9780789747204 (0789747200), Que, 2011

There was no reason I shouldn’t have already written a book about statistical analysis using Excel. But I didn’t, although I knew I wanted to. Finally, I talked Pearson into letting me write it for them.

Be careful what you ask for. It’s been a struggle, but at last I’ve got it out of my system, and I want to start by talking here about the reasons for some of the choices I made in writing this book.

Use Excel 2010’s powerful statistical tools to gain a deeper understanding of your data, make more accurate and reliable inferences, and solve problems in fields ranging from business to health sciences.


Top Excel guru Conrad Carlberg shows how to use Excel 2010 to perform the 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 its new consistency functions. Along the way, you discover the most effective ways to use correlation and regression and analysis of variance and covariance. You see how to use Excel to test statistical hypotheses using the normal, binomial, t and F distributions.


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 an extensive set of 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

  •  View how values cluster and disperse

  •  Infer a population’s characteristics from a sample’s frequency distribution

  •  Explore correlation and regression to learn how variables move in tandem

  •  Understand Excel’s new consistency functions

  •  Test differences between two means using z tests, t tests, and Excel’s Data Analysis Add-in

  •  Use ANOVA and ANCOVA to test differences between more than two means

  •  Explore statistical power by manipulating mean differences, standard errors, directionality, and alpha


There is an Excel workbook for each chapter, and each worksheet is keyed to one of the book's figures. You'll also find additional material, such as a chart that demonstrates how statistical power shifts as you manipulate sample size, mean differences, alpha and directionality. To access these free files, please visit http://www.quepublishing.com/title/0789747200 and click the Downloads Tab.

(HTML tags aren't allowed.)

Microsoft ASP.NET Web Matrix Starter Kit
Microsoft ASP.NET Web Matrix Starter Kit

Have you ever gone to a great Web site and said to yourself, “I sure wish I could do that?” This hands-on book shows you exactly how. It’s a task-oriented, no-frills introduction, specifically for programming novices, to the cool world of programming the Web by using the power of Microsoft ASP.NET Web Matrix—an...

50 Math and Science Games for Leadership
50 Math and Science Games for Leadership

Did you like Math or Science in school? Have you played games that stimulated your thought processes for Math and Science? Trying to be creative in your Math, Science or leadership class? Can leadership be taught? Is leadership an Art or a Science or Math? Seeking to impact your training program with creative games? A primer for leadership...

Web Engineering Advancements and Trends: Building New Dimensions of Information Technology (Premier Reference Source)
Web Engineering Advancements and Trends: Building New Dimensions of Information Technology (Premier Reference Source)

As countless failures in information technology and Web-based systems are caused by an incorrect understanding of knowledge sharing, an increased awareness of modern, fundamental industry concepts becomes crucial to Web and interface developers.

Web Engineering Advancements and Trends: Building New Dimensions of Information...

Healing Fibromyalgia
Healing Fibromyalgia
If you picked up this book looking for more ways to cope with fibromyalgia, you’re in for a surprise. What we propose here is that fibromyalgia is not an incurable, chronic source of pain and misery but rather a temporary and reversible problem that can be fixed.

Just in the last year, a wealth of
The Secret History of the World: And How to Get Out Alive
The Secret History of the World: And How to Get Out Alive
I suspected something was wrong with the “facts of life” as they were presented to me when I was a kid. Sure, I then spent a little over thirty years trying to be “normal” and make that square peg fit the round hole, “looking for a reason to believe.” But then there was a memorable day when I finally grew up and...
Ansible: From Beginner to Pro
Ansible: From Beginner to Pro
This book is your concise guide to Ansible, the simple way to automate apps and IT infrastructure. In less than 250 pages, this book takes you from knowing nothing about configuration management to understanding how to use Ansible in a professional setting.

You will learn how to create an Ansible playbook...

©2019 LearnIT (support@pdfchm.net) - Privacy Policy