Cover image for Statistics with Microsoft Excel
Title:
Statistics with Microsoft Excel
Author:
Dretzke, Beverly Jean.
Personal Author:
Publication Information:
Upper Saddle River, NJ : Prentice Hall, [1998]

©1998
Physical Description:
164 pages : illustrations ; 28 cm
General Note:
Includes index.
Language:
English
Added Author:
ISBN:
9780139565335
Format :
Book

Available:*

Library
Call Number
Material Type
Home Location
Status
Central Library QA276.4 .D74 1998 Adult Non-Fiction Central Closed Stacks-Oversize
Searching...

On Order

Summary

Summary

This supplement assumes no prior experience with Excel, and uses examples from across the curriculum to instruct students in using Excel as a simple number-crunching and data analysis tool for statistics. Special attention is given to interpreting Excel output and linking it to the formulae and techniques taught in any introductory statistics course.


Table of Contents

Chapter 1 Getting Startedp. 1
Introduction and Overviewp. 1
Versions of Excelp. 1
Versions of Windowsp. 2
What May Be Skippedp. 2
More Detailed Information on Excelp. 2
Excel Worksheet Basicsp. 3
Using the Mousep. 3
Starting Excelp. 4
Exiting Excelp. 4
Layout of Worksheets and Workbooksp. 4
Menus, Toolbars, and Dialog Boxesp. 8
Manipulating Windowsp. 9
Ways to Get Helpp. 10
Help on the Main Menup. 10
Answer Wizardp. 11
Chapter 2 Entering, Saving, and Editing Informationp. 13
Opening and Saving Documentsp. 13
Opening a Brand-New Worksheetp. 13
Opening a File You Have Already Createdp. 13
Entering Informationp. 14
Addressesp. 14
Activating a Cell or Range of Cellsp. 14
Types of Informationp. 15
Changing Informationp. 15
Moving and Copying Informationp. 15
Dragging and Droppingp. 16
Formatting Numbersp. 16
Aligning Informationp. 17
Formatting a Rangep. 17
Inserting or Deleting Rows and Columnsp. 18
Filling Adjacent Cellsp. 18
Seriesp. 19
Sortingp. 19
Saving and Retrieving Informationp. 20
Naming Workbooksp. 20
Printingp. 21
Page Setupp. 21
Enhancing Outputp. 24
Chapter 3 Using Formulas and Functionsp. 25
Operatorsp. 25
Order of Operationsp. 25
Writing Equationsp. 26
Entering Formulasp. 27
Relative Referencesp. 29
Absolute Referencesp. 29
Chapter 4 Frequency Distributionsp. 31
Histogram Using Analysis Toolsp. 31
Sorting the Datap. 32
Sorting: Potential Problemsp. 32
Binsp. 33
Interpreting the Outputp. 37
Modifying and Printing the Histogram Chartp. 37
Pivot Tablep. 38
Sample Research Problemp. 38
Setting up a Pivot Tablep. 39
Pivot Table: Frequency Distributionsp. 42
Chapter 5 Descriptive Statisticsp. 45
Data Analysis Tools: Descriptive Statisticsp. 45
Sample Research Problemp. 45
Steps to Follow to Obtain Descriptive Statistics for a Single Variablep. 45
Interpreting the Outputp. 47
Steps to Follow to Obtain Descriptive Statistics for Two or More Variablesp. 50
Function Wizard: Descriptive Statisticsp. 51
Sample Research Problemp. 51
Steps to Follow to Obtain Descriptive Statistics for One Variablep. 52
Interpreting the Outputp. 55
Steps to Follow to Obtain Descriptive Statistics for More than One Variablep. 56
Interpreting the Outputp. 57
Pivot Table: Descriptive Statisticsp. 57
Sample Research Problemp. 57
Setting up a Pivot Tablep. 58
Chapter 6 Probability Distributionsp. 61
Discrete Probability Distributionsp. 61
Binomial Distributionp. 61
Interpreting the Outputp. 64
Hypergeometric Distributionp. 65
Interpreting the Outputp. 66
Poisson Distributionp. 67
Interpreting the Outputp. 69
Continuous Probability Distributionsp. 70
Normal Distributionp. 70
t Distributionp. 74
F Distributionp. 76
Chi-Square Distributionp. 78
Chapter 7 Testing Hypotheses About One Sample Meansp. 79
One-Sample Z-Testp. 79
Assumptions Underlying the Z-Testp. 79
Sample Research Problemp. 80
Steps to Follow to Analyze the Sample Research Problemp. 80
Interpreting the Outputp. 84
Confidence Interval for the One-Sample Z-Testp. 85
Interpreting the Confidence Intervalp. 86
One-Sample t-Testp. 86
Assumptions Underlying the t-Testp. 86
Sample Research Problemp. 87
Steps to Follow to Analyze the Sample Research Problemp. 87
Interpreting the Outputp. 91
Confidence Interval for the One-Sample t-Testp. 92
Interpreting the Confidence Intervalp. 93
Chapter 8 Testing Hypotheses About the Difference Between Two Meansp. 95
t-Test for Two Independent Samplesp. 95
Variances Are Not Known and Are Assumed to Be Equalp. 95
Assumptions Underlying the Independent Samples t-Testp. 96
Sample Research Problemp. 96
Using Analysis Tools for t-Test: Two-Sample Assuming Equal Variancesp. 96
Steps to Follow to Analyze the Sample Research Problemp. 97
Interpreting the Outputp. 99
Variances Are Not Known and Are Assumed to Be Unequalp. 99
Assumptions Underlying the Independent Samples t*-Testp. 100
Sample Research Problemp. 100
Using Analysis Tools for t-Test: Two-Sample Assuming Unequal Variancesp. 101
Interpreting the Outputp. 102
Paired-Samples t-Testp. 102
Sample Research Problemp. 103
Using Analysis Tools for t-Test: Paired-Two-Sample for Meansp. 103
Interpreting the Outputp. 104
Z-Test for Two Independent Samplesp. 105
Assumptions Underlying the Z-Testp. 105
Sample Research Problemp. 106
Using Analysis Tools for Z-Test: Two-Sample for Meansp. 106
Steps to Follow to Analyze the Sample Research Problemp. 107
Interpreting the Outputp. 108
Chapter 9 Analysis of Variancep. 111
One-Way Between-Groups ANOVAp. 111
F-Testp. 111
Assumptions Underlying the F-Testp. 111
Sample Research Problemp. 111
Using Analysis Tools for One-Way Between-Groups ANOVAp. 112
Interpreting the Outputp. 113
One-Way Repeated Measures ANOVAp. 115
F-Testp. 115
Assumptions Underlying the F-Testp. 115
Sample Research Problemp. 115
Using Analysis Tools for One-Way Repeated Measures ANOVAp. 115
Interpreting the Outputp. 116
Two-Way Between-Groups ANOVAp. 119
F-Testp. 119
Assumptions Underlying the F-Testp. 119
Sample Research Problemp. 120
Using Analysis Tools for Two-Way Between-Groups ANOVAp. 120
Interpreting the Outputp. 121
Chapter 10 Correlationp. 125
Pearson Correlation Coefficientp. 125
Sample Research Problemp. 125
Function Wizardp. 126
Correlation Matricesp. 127
Scatterplotp. 128
Modifying the Scatterplotp. 131
Chapter 11 Regressionp. 133
Two-Variable Regressionp. 133
Sample Research Problemp. 133
Scatterplotp. 134
Steps to Follow to Analyze the Sample Research Problemp. 135
Interpreting the Outputp. 136
Multiple Regressionp. 138
Sample Research Problemp. 138
Steps to Follow to Analyze the Sample Research Problemp. 138
Interpreting the Outputp. 140
Chapter 12 Cross Tabulationsp. 145
Sample Research Problemp. 145
Cross Tabulation of Two Qualitative Variablesp. 145
Cross Tabulation of a Qualitative and a Quantitative Variablep. 147
Cross Tabulation of Three Variablesp. 148
Missing Datap. 150
Chi-Square Test of Independencep. 151
Assumptions Underlying the Chi-Square Test of Independencep. 151
Sample Research Problemp. 151
Using the Pivot Table for Observed Cell Frequenciesp. 152
Using Formulas to Calculate Expected Cell Frequenciesp. 153
Using the Function Wizard to Calculate Chi-Squarep. 155
Using the Function Wizard to Find the Critical Value of Chi-Squarep. 156
Using the Function Wizard to Find the P-Valuep. 157
Appendix A How to Obtain Data Files on the Webp. 159
Taking the Long Way to the Sitep. 159
Taking the Short Way to the Sitep. 159
Description of the Data Setsp. 159
Appendix B Web Sites that Provide
Information About Excel and Statisticsp. 161
http://www.nyu.edu/acf/socsci/statistics.htmlp. 162
http://www.census.gov/statab/freqp. 162
http://www.j-walk.com/ss/ssjokes.htmp. 162

Google Preview