Statistical analysis : Microsoft Excel 2016

✍ Scribed by Carlberg, Conrad George

• Publisher: Que
• Year: 2018
• Tongue: English
• Leaves: 537
• Category: Library

✦ Synopsis

Nationally reconized Excel expert Conrad Carlberg shows you how to use Excel 2016 to perform core statistical tasks every business professional, student, and researcher should master. Using real-world examples and downloadable workbooks, Carlberg helps you choose the right technique for each problem and get the most out of Excel's statistical features. Along the way, he clarifies confusing statistical terminology and helps you avoid common mistakes.  Read more...

✦ Table of Contents

About variables and values --
How values cluster together --
Variability : how values disperse --
How variables move jointly : correlation --
Charting statistics --
How variables classify jointly : contingency tables --
Using Excel with the normal distribution --
Telling the truth with statistics --
Testing differences between means: the basics --
Testing differences between means : further issues --
Testing differences between means : the analysis of variance --
Analysis of variance : further issues --
Experimental design and ANOVA --
Statistical power --
Multiple regression analysis and effect coding : the basics --
Multiple regression analysis and effect coding : further issues --
Analysis of covariance : the basics --
Analysis of covariance : further issues.

✦ Subjects

Microsoft Excel (Computer file);Statistics -- Methodology -- Computer programs;Electronic spreadsheets -- Computer programs;Social sciences -- Statistics -- Methodology