Home

PDF Ebook The Excel 2007 Data & Statistics Cookbook

Submitted by antoq on Sun, 04/12/2009 - 07:09

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, as you have already found or will soon find, the screens look very much different in the newest version of Excel. If you are using Excel 2003 or an earlier version, you may find my Excel Statistics Cookbook (2006) more to your liking.

Students, instructors, and researchers wanting to perform data management and basic descriptive and inferential statistical analyses using Excel will find this book helpful. My goal was to produce a succinct guide to conducting the most common basic statistical procedures using Excel as a computational aid. For each procedure, I provide an example problem with data, and then show how to perform the procedure in Excel. I display the output and explain how to interpret it.

This cookbook shows you how to use Microsoft Excel for data management, basic descriptive and inferential statistics, charts and graphs, one-sample t tests, independent samples t tests, dependent t tests, one-way between groups ANOVA, repeated measures ANOVA, correlation and regression, and chi-square tests. I include an appendix that provides a quick reference to some of the most frequently-used statistical functions in Excel.

Interactive Excel templates for performing most of the statistical tests described in this book can be found at the author’s web site. Most of the datasets used in this book and other resources are available as well:

This cookbook makes no use of macros or third-party add-ins, instead relying on Excel’s
built-in statistical functions, simple formulas, and the Analysis ToolPak distributed with Excel. I would like to say from the outset that Excel is best suited for preliminary data handling and exploration and only the most basic statistical analyses. More complicated analyses should be performed with dedicated statistical packages such as SPSS, SAS, or MINITAB.

Contents
Preface and Acknowledgements
About the Author
1 A Crash Course in Excel

    The Workbook Interface
    What Goes into a Worksheet
    Entering Information

2 Data Structures and Descriptive Statistics

    Data Tables
    Built-In Functions
    Summary Statistics Available From the AutoSum Tool
    Data Table Summary Statistics
    Additional Statistical Functions
    The Analysis ToolPak
    Example Data
    Descriptive Statistics in the Analysis ToolPak
    Frequency Distributions

3 Charts, Graphs, and Tables

    Pie Charts
    Bar Charts
    Histograms
    Line Graphs
    Scatterplots
    Pivot Tables and Charts
    Using the Pivot Table to Summarize Quantitative Data
    The Charts Excel Does Not Do

4 One-Sample t Test

    Example Data
    Using Excel for a One-Sample t Test

5 Independent-Samples t Test

    Example Data
    The Independent-Samples t Test in the Analysis ToolPak

6 Paired-Samples t Test

    Example Data
    Dependent t Test in the Analysis ToolPak

7 One-Way Between-Groups ANOVA

    Example Data
    One-Way ANOVA in the Analysis ToolPak

8 Repeated-Measures ANOVA

    Example Data
    Withi-Subjects ANOVA in the Analysis ToolPak

9 Correlation and Regression

    Example Data
    Regression Analysis in the Analysis ToolPak

10 Chi-Square Tests

    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

11 Appendix
12 Index

Download
PDF Ebook The Excel 2007 Data & Statistics Cookbook

»

Posted in :