Statistical Analysis: Microsoft Excel 2010

Microsoft Excel 2010

Business & Finance, Accounting, Financial, Nonfiction, Computers, Application Software, Spreadsheets, Financial Applications
Cover of the book Statistical Analysis: Microsoft Excel 2010 by Conrad Carlberg, Pearson Education
View on Amazon View on AbeBooks View on Kobo View on B.Depository View on eBay View on Walmart
Author: Conrad Carlberg ISBN: 9780132681919
Publisher: Pearson Education Publication: April 22, 2011
Imprint: Que Publishing Language: English
Author: Conrad Carlberg
ISBN: 9780132681919
Publisher: Pearson Education
Publication: April 22, 2011
Imprint: Que Publishing
Language: English

Statistical Analysis: Microsoft Excel 2010

 

“Excel has become the standard platform for quantitative analysis. Carlberg has become a world-class guide for Excel users wanting to do quantitative analysis. The combination makes Statistical Analysis: Microsoft Excel 2010 a must-have addition to the library of those who want to get the job done and done right.” 

—Gene V Glass, Regents’ Professor Emeritus, Arizona State University

 

Use Excel 2010’s statistical tools to transform your data into knowledge

 

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.

View on Amazon View on AbeBooks View on Kobo View on B.Depository View on eBay View on Walmart

Statistical Analysis: Microsoft Excel 2010

 

“Excel has become the standard platform for quantitative analysis. Carlberg has become a world-class guide for Excel users wanting to do quantitative analysis. The combination makes Statistical Analysis: Microsoft Excel 2010 a must-have addition to the library of those who want to get the job done and done right.” 

—Gene V Glass, Regents’ Professor Emeritus, Arizona State University

 

Use Excel 2010’s statistical tools to transform your data into knowledge

 

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.

More books from Pearson Education

Cover of the book CCNP Voice CVoice 642-437 Quick Reference by Conrad Carlberg
Cover of the book Objective-C by Conrad Carlberg
Cover of the book Sams Teach Yourself iOS 6 Application Development in 24 Hours by Conrad Carlberg
Cover of the book Enterprise Mobility with App Management, Office 365, and Threat Mitigation by Conrad Carlberg
Cover of the book Compliance by Conrad Carlberg
Cover of the book Shifting from YouTube to Ustream and Beyond by Conrad Carlberg
Cover of the book Domain-Driven Design by Conrad Carlberg
Cover of the book C++ Coding Standards by Conrad Carlberg
Cover of the book Give Your Business a Heart (Collection) by Conrad Carlberg
Cover of the book Microsoft Office Access 2007 Forms, Reports, and Queries by Conrad Carlberg
Cover of the book Tools and Tactics for Operations Managers (Collection) by Conrad Carlberg
Cover of the book The Process of Software Architecting by Conrad Carlberg
Cover of the book The Network Challenge (Chapter 10) by Conrad Carlberg
Cover of the book The Definitive Guide to DAX by Conrad Carlberg
Cover of the book Train Your Gut Like a Master Trader by Conrad Carlberg
We use our own "cookies" and third party cookies to improve services and to see statistical information. By using this website, you agree to our Privacy Policy