CART

(0) items

Statistics with Microsoft Excel

by
Edition:
3rd
ISBN13:

9780131471115

ISBN10:
0131471112
Format:
Paperback
Pub. Date:
1/1/2005
Publisher(s):
Pearson College Div

Related Products


  • Statistics With Excel
    Statistics With Excel
  • Statistics with Microsoft Excel
    Statistics with Microsoft Excel
  • Statistics with Microsoft Excel
    Statistics with Microsoft Excel





Summary

This book provides a complete introduction to statistics using Excel. Its easy-to-understand basic spreadsheet operations, and its Analysis Tools make Excel an superb software package to carry out statistical analyses. Covers Excel's numerous options for constructing charts, manipulating and transforming data, and pasting output into written documents. Excel's Analysis Tools provide numerous statistical analysis procedures: descriptive statistics, correlation, regression, t-test, and two-way analysis of variance. Several data sets available at the authors' Web site - http://psyc.uwec.edu/bd.htm For business professionals utilizing Microsoft Excel for statistical analysis and/or those within business statistics courses.

Table of Contents

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
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
Using Formulas and Functionsp. 25
Operatorsp. 25
Order of Operationsp. 25
Writing Equationsp. 26
Entering Formulasp. 27
Relative Referencesp. 29
Absolute Referencesp. 29
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
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
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
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
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
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
Correlationp. 125
Pearson Correlation Coefficientp. 125
Sample Research Problemp. 125
Function Wizardp. 126
Correlation Matricesp. 127
Scatterplotp. 128
Modifying the Scatterplotp. 131
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
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
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
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
Table of Contents provided by Syndetics. All Rights Reserved.


Please wait while the item is added to your cart...