Cookbook

# Cookbook - The Excel 2007 Data &amp; Statistics Cookbook A...

This preview shows pages 1–8. Sign up to view the full content.

The Excel 2007 Data & Statistics Cookbook A Point-and-Click! Guide Larry A. Pace Anderson University TwoPaces LLC Anderson SC

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
Pace, Larry A. The Excel 2007 Data & Statistics Cookbook: A Point-and-Click! Guide ISBN 978-0-9799775-1-0 Published in the United States of America by TwoPaces LLC 102 San Mateo Dr. Anderson SC 29625 Copyright © 2007 Larry A. Pace Camera-ready text produced by the author. All rights reserved. No part of this document may be photocopied, reproduced by any means, or translated into another language without the prior written consent of the author. MICROSOFT ® is a registered trademark, and EXCEL ® is a trademark of the Microsoft Corporation.
iii Brief Contents Preface and Acknowledgements vii About the Author ix 1 A Crash Course in Excel 1 2 Data Structures and Descriptive Statistics 7 3 Charts, Graphs, and Tables 25 4 One-Sample t Test 43 5 Independent-Samples t Test 47 6 Paired-Samples t Test 49 7 One-Way Between-Groups ANOVA 53 8 Repeated-Measures ANOVA 57 9 Correlation and Regression 61 10 Chi-Square Tests 65 11 Appendix 71 12 Index 73

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
v Contents Preface and Acknowledgements vii About the Author ix 1 A Crash Course in Excel 1 The Workbook Interface 1 What Goes into a Worksheet 1 Entering Information 3 2 Data Structures and Descriptive Statistics 7 Data Tables 7 Built-In Functions 7 Summary Statistics Available From the AutoSum Tool 10 Data Table Summary Statistics 10 Additional Statistical Functions 13 The Analysis ToolPak 14 Example Data 15 Descriptive Statistics in the Analysis ToolPak 18 Frequency Distributions 20 3 Charts, Graphs, and Tables 25 Pie Charts 25 Bar Charts 26 Histograms 27 Line Graphs 29 Scatterplots 30 Pivot Tables and Charts 33 Using the Pivot Table to Summarize Quantitative Data 37 The Charts Excel Does Not Do 41 4 One-Sample t Test 43 Example Data 43 Using Excel for a One-Sample t Test 44

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
vi Contents 5 Independent-Samples t Test 47 Example Data 47 The Independent-Samples t Test in the Analysis ToolPak 48 6 Paired-Samples t Test 49 Example Data 49 Dependent t Test in the Analysis ToolPak 50 7 One-Way Between-Groups ANOVA 53 Example Data 53 One-Way ANOVA in the Analysis ToolPak 54 8 Repeated-Measures ANOVA 57 Example Data 57 Within-Subjects ANOVA in the Analysis ToolPak 58 9 Correlation and Regression 61 Example Data 61 Regression Analysis in the Analysis ToolPak 62 10 Chi-Square Tests 65 Chi-Square Goodness-of-Fit Test with Equal Frequencies 65 Chi-Square Goodness-of-Fit Test with Unequal Expected Frequencies 67 Chi-Square Test of Independence 68 11 Appendix 71 12 Index 73
vii Preface and Acknowledgements The predecessor to this book was well received, and considering the feedback from instructors and students, I have expanded the coverage of the data management features of Excel in this update, as these are quite powerful and flexible. This book makes use of Excel 2007 for Microsoft Windows. All the functionality described in this book is also available in Excel 2003, and most of it is available in earlier versions as well. However,

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
This is the end of the preview. Sign up to access the rest of the document.

## Cookbook - The Excel 2007 Data &amp; Statistics Cookbook A...

This preview shows document pages 1 - 8. Sign up to view the full document.

View Full Document
Ask a homework question - tutors are online