Statistical analysis :
Carlberg, Conrad George
Statistical analysis : Microsoft Excel 2010 / Conrad Carlberg. - Indianapolis : Que, c2011. - x, 412 p. : ill. b&w ; 24 cm.
Includes index.
Ch. 1. About Variables and Values --
Ch. 2. How Values Cluster Together --
Ch. 3. Variability: How Values Disperse --
Ch. 4. How Variables Move Jointly: Correlation --
Ch. 5. How Variables Classify Jointly: Contingency Tables --
Ch. 6. Telling the Truth with Statistics --
Ch. 7. Using Excel with the Normal Distribution --
Ch. 8. Testing Differences Between Means: The Basics --
Ch. 9. Testing Differences Between Means: Further Issues --
Ch. 10. Testing Differences Between Means: The Analysis of Variance --
Ch. 11. Analysis of Variance: Further Issues --
Ch. 12. Multiple Regression Analysis and Effect Coding: The Basics --
Ch. 13. Multiple Regression Analysis: Further Issues --
Ch. 14. Analysis of Covariance: The Basics --
Ch. 15. Analysis of Covariance: Further Issues.
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.
9780789747204
Microsoft Excel (Computer file)
Statistics
Social sciences--Methodology
005.54
Statistical analysis : Microsoft Excel 2010 / Conrad Carlberg. - Indianapolis : Que, c2011. - x, 412 p. : ill. b&w ; 24 cm.
Includes index.
Ch. 1. About Variables and Values --
Ch. 2. How Values Cluster Together --
Ch. 3. Variability: How Values Disperse --
Ch. 4. How Variables Move Jointly: Correlation --
Ch. 5. How Variables Classify Jointly: Contingency Tables --
Ch. 6. Telling the Truth with Statistics --
Ch. 7. Using Excel with the Normal Distribution --
Ch. 8. Testing Differences Between Means: The Basics --
Ch. 9. Testing Differences Between Means: Further Issues --
Ch. 10. Testing Differences Between Means: The Analysis of Variance --
Ch. 11. Analysis of Variance: Further Issues --
Ch. 12. Multiple Regression Analysis and Effect Coding: The Basics --
Ch. 13. Multiple Regression Analysis: Further Issues --
Ch. 14. Analysis of Covariance: The Basics --
Ch. 15. Analysis of Covariance: Further Issues.
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.
9780789747204
Microsoft Excel (Computer file)
Statistics
Social sciences--Methodology
005.54