Statistics with Microsoft Excel

Name: Statistics with Microsoft Excel
Price: 2.54 USD
Availability: InStock
ISBN: 9780131471115

ISBN-10: 0131471112

ISBN-13: 9780131471115

Edition: 3rd 2005 (Revised)

Authors: Beverly Jean Dretzke

List price: $26.67

30 day, 100% satisfaction guarantee!

Marketplace

2 new & used from $2.54

what's this?

Rush Rewards U
Members Receive:

You have reached 400 XP and carrot coins. That is the daily max!

Description:

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…

Book details

List price: $26.67
Edition: 3rd
Copyright year: 2005
Publisher: Prentice Hall PTR
Binding: Paperback
Pages: 312
Size: 8.25" wide x 10.75" long x 0.75" tall
Weight: 1.386
Language: English




Getting Started


Introduction and Overview


Versions of Excel


Versions of Windows


What May Be Skipped


More Detailed Information on Excel


Excel Worksheet Basics


Using the Mouse


Starting Excel


Exiting Excel


Layout of Worksheets and Workbooks


Menus, Toolbars, and Dialog Boxes


Manipulating Windows


Ways to Get Help


Help on the Main Menu


Answer Wizard



Entering, Saving, and Editing Information


Opening and Saving Documents


Opening a Brand-New Worksheet


Opening a File You Have Already Created


Entering Information


Addresses


Activating a Cell or Range of Cells


Types of Information


Changing Information


Moving and Copying Information


Dragging and Dropping


Formatting Numbers


Aligning Information


Formatting a Range


Inserting or Deleting Rows and Columns


Filling Adjacent Cells


Series


Sorting


Saving and Retrieving Information


Naming Workbooks


Printing


Page Setup


Enhancing Output



Using Formulas and Functions


Operators


Order of Operations


Writing Equations


Entering Formulas


Relative References


Absolute References



Frequency Distributions


Histogram Using Analysis Tools


Sorting the Data


Sorting: Potential Problems


Bins


Interpreting the Output


Modifying and Printing the Histogram Chart


Pivot Table


Sample Research Problem


Setting up a Pivot Table


Pivot Table: Frequency Distributions



Descriptive Statistics


Data Analysis Tools: Descriptive Statistics


Sample Research Problem


Steps to Follow to Obtain Descriptive Statistics for a Single Variable


Interpreting the Output


Steps to Follow to Obtain Descriptive Statistics for Two or More Variables


Function Wizard: Descriptive Statistics


Sample Research Problem


Steps to Follow to Obtain Descriptive Statistics for One Variable


Interpreting the Output


Steps to Follow to Obtain Descriptive Statistics for More than One Variable


Interpreting the Output


Pivot Table: Descriptive Statistics


Sample Research Problem


Setting up a Pivot Table



Probability Distributions


Discrete Probability Distributions


Binomial Distribution


Interpreting the Output


Hypergeometric Distribution


Interpreting the Output


Poisson Distribution


Interpreting the Output


Continuous Probability Distributions


Normal Distribution


t Distribution


F Distribution


Chi-Square Distribution



Testing Hypotheses About One Sample Means


One-Sample Z-Test


Assumptions Underlying the Z-Test


Sample Research Problem


Steps to Follow to Analyze the Sample Research Problem


Interpreting the Output


Confidence Interval for the One-Sample Z-Test


Interpreting the Confidence Interval


One-Sample t-Test


Assumptions Underlying the t-Test


Sample Research Problem


Steps to Follow to Analyze the Sample Research Problem


Interpreting the Output


Confidence Interval for the One-Sample t-Test


Interpreting the Confidence Interval



Testing Hypotheses About the Difference Between Two Means


t-Test for Two Independent Samples


Variances Are Not Known and Are Assumed to Be Equal


Assumptions Underlying the Independent Samples t-Test


Sample Research Problem


Using Analysis Tools for t-Test: Two-Sample Assuming Equal Variances


Steps to Follow to Analyze the Sample Research Problem


Interpreting the Output


Variances Are Not Known and Are Assumed to Be Unequal


Assumptions Underlying the Independent Samples t*-Test


Sample Research Problem


Using Analysis Tools for t-Test: Two-Sample Assuming Unequal Variances


Interpreting the Output


Paired-Samples t-Test


Sample Research Problem


Using Analysis Tools for t-Test: Paired-Two-Sample for Means


Interpreting the Output


Z-Test for Two Independent Samples


Assumptions Underlying the Z-Test


Sample Research Problem


Using Analysis Tools for Z-Test: Two-Sample for Means


Steps to Follow to Analyze the Sample Research Problem


Interpreting the Output



Analysis of Variance


One-Way Between-Groups ANOVA


F-Test


Assumptions Underlying the F-Test


Sample Research Problem


Using Analysis Tools for One-Way Between-Groups ANOVA


Interpreting the Output


One-Way Repeated Measures ANOVA


F-Test


Assumptions Underlying the F-Test


Sample Research Problem


Using Analysis Tools for One-Way Repeated Measures ANOVA


Interpreting the Output


Two-Way Between-Groups ANOVA


F-Test


Assumptions Underlying the F-Test


Sample Research Problem


Using Analysis Tools for Two-Way Between-Groups ANOVA


Interpreting the Output



Correlation


Pearson Correlation Coefficient


Sample Research Problem


Function Wizard


Correlation Matrices


Scatterplot


Modifying the Scatterplot



Regression


Two-Variable Regression


Sample Research Problem


Scatterplot


Steps to Follow to Analyze the Sample Research Problem


Interpreting the Output


Multiple Regression


Sample Research Problem


Steps to Follow to Analyze the Sample Research Problem


Interpreting the Output



Cross Tabulations


Sample Research Problem


Cross Tabulation of Two Qualitative Variables


Cross Tabulation of a Qualitative and a Quantitative Variable


Cross Tabulation of Three Variables


Missing Data


Chi-Square Test of Independence


Assumptions Underlying the Chi-Square Test of Independence


Sample Research Problem


Using the Pivot Table for Observed Cell Frequencies


Using Formulas to Calculate Expected Cell Frequencies


Using the Function Wizard to Calculate Chi-Square


Using the Function Wizard to Find the Critical Value of Chi-Square


Using the Function Wizard to Find the P-Value



How to Obtain Data Files on the Web


Taking the Long Way to the Site


Taking the Short Way to the Site


Description of the Data Sets



Web Sites that Provide


Information About Excel and Statistics


http://www.nyu.edu/acf/socsci/statistics.html


http://www.census.gov/statab/freq


http://www.j-walk.com/ss/ssjokes.htm