Preview this item
Preview this item

# Statistics with Microsoft Excel

Author: Beverly Jean Dretzke Upper Saddle River : Pearson/Prentice Hall, ©2009. Print book : English : 4th edView all editions and formats Statistics with Microsoft Excel, Fourth Edition, shows readers how to use Microsoft Excel (R) to perform statistical analysis. This step-by-step guide has been updated to cover the new features and  Read more... (not yet rated) 0 with reviews - Be the first.

## Find a copy in the library

Finding libraries that hold this item...

## Details

Document Type: Book Beverly Jean Dretzke Find more information about: Beverly Jean Dretzke 0136043879 9780136043874 190395112 Includes index. ix, 268 pages : illustrations ; 28 cm 1. Getting Started1.1 Introduction and Overview1.2 What May Be Skipped1.3 Excel Worksheet Basics1.4 Dialog Boxes1.5 Accessing Excel Files on the Web site1.6 Saving Information1.7 Printing1.8 Loading Excel's Analysis ToolPak 2. Entering, Editing, and Recoding Information2.1 Opening Documents2.2 Entering Information2.3 Editing Information2.4 Formatting Numbers2.5 Recoding2.6 Sorting 3. Formulas3.1 Operators3.2 Using Formulas in Statistics 4. Frequency Distributions4.1 Frequency Distributions Using Pivot Table and Pivot Chart4.2 Frequency Distributions Using Data Analysis Tools 5. Descriptive Statistics5.1 Data Analysis Tools: Descriptive Statistics5.2 Functions: Descriptive Statistics5.3 Pivot Table: Descriptive Statistics 6. Probability Distributions6.1 Discrete Probability Distributions6.2 Continuous Probability Distributions 7. Testing Hypotheses About One Sample Means7.1 One-Sample Z-Test7.2 One-Sample t-Test 8. Testing Hypotheses About the Difference Between Two Means8.1 t-Test for Two Independent Samples8.2 Paired-Samples t-Test8.3 Z-Test for Two Independent Samples 9. Analysis of Variance9.1 One-Way Between-Groups ANOVA9.2 One-Way Repeated Measures ANOVA9.3 Two-Way Between-Groups ANOVA9.4 F-Test for Two Sample Variances 10. Correlation10.1 Pearson Correlation Coefficient10.2 Spearman Rank Correlation Coefficient 11. Regression11.1 Two-Variable Regression11.2 Multiple Regression11.3 Dummy Coding of Qualitative Variables11.4 Curvilinear Regression 12. Cross Tabulations12.1 Cross Tabulations Using the Pivot Table12.2 Chi-Square Test of Independence 13. Random Samples13.1 Random Selection Using the Random Number Generation Tool13.2 Random Selection Using the Sampling Tool13.3 Random Selection Using the RANDBETWEEN Function Beverly J. Dretzke.

## Reviews

User-contributed reviews

## Tags

### All user tags (2)

View most popular tags as: tag list | tag cloud

## Similar Items

### Related Subjects:(4)

Confirm this request

You may have already requested this item. Please select Ok if you would like to proceed with this request anyway.

### Primary Entity

<http://www.worldcat.org/oclc/190395112> # Statistics with Microsoft Excel
a schema:Book, schema:CreativeWork ;
library:oclcnum "190395112" ;
library:placeOfPublication <http://id.loc.gov/vocabulary/countries/nju> ;
schema:about <http://experiment.worldcat.org/entity/work/data/14356797#CreativeWork/microsoft_excel> ; # Microsoft Excel.
schema:about <http://id.loc.gov/authorities/subjects/sh85127583> ; # Statistics--Data processing
schema:about <http://id.worldcat.org/fast/1366659> ; # Microsoft Excel (Computer file)
schema:about <http://experiment.worldcat.org/entity/work/data/14356797#CreativeWork/microsoft_excel_computer_file> ; # Microsoft Excel (Computer file)
schema:about <http://id.worldcat.org/fast/1132113> ; # Statistics--Data processing
schema:bookEdition "4th ed." ;
schema:bookFormat bgn:PrintBook ;
schema:creator <http://viaf.org/viaf/63050314> ; # Beverly Jean Dretzke
schema:datePublished "2009" ;
schema:exampleOfWork <http://worldcat.org/entity/work/id/14356797> ;
schema:inLanguage "en" ;
schema:name "Statistics with Microsoft Excel"@en ;
schema:productID "190395112" ;
schema:publisher <http://experiment.worldcat.org/entity/work/data/14356797#Agent/pearson_prentice_hall> ; # Pearson/Prentice Hall
schema:workExample <http://worldcat.org/isbn/9780136043874> ;
wdrs:describedby <http://www.worldcat.org/title/-/oclc/190395112> ;
.

### Related Entities

<http://experiment.worldcat.org/entity/work/data/14356797#Agent/pearson_prentice_hall> # Pearson/Prentice Hall
a bgn:Agent ;
schema:name "Pearson/Prentice Hall" ;
.

<http://experiment.worldcat.org/entity/work/data/14356797#CreativeWork/microsoft_excel_computer_file> # Microsoft Excel (Computer file)
a schema:CreativeWork ;
schema:name "Microsoft Excel (Computer file)" ;
.

a schema:Place ;
.

<http://experiment.worldcat.org/entity/work/data/14356797#Topic/statistique_informatique> # Statistique--Informatique
a schema:Intangible ;
schema:name "Statistique--Informatique"@fr ;
.

<http://id.loc.gov/authorities/subjects/sh85127583> # Statistics--Data processing
a schema:Intangible ;
schema:name "Statistics--Data processing"@en ;
.

<http://id.worldcat.org/fast/1132113> # Statistics--Data processing
a schema:Intangible ;
schema:name "Statistics--Data processing"@en ;
.

<http://id.worldcat.org/fast/1366659> # Microsoft Excel (Computer file)
a schema:CreativeWork ;
schema:name "Microsoft Excel (Computer file)" ;
.

<http://viaf.org/viaf/63050314> # Beverly Jean Dretzke
a schema:Person ;
schema:familyName "Dretzke" ;
schema:givenName "Beverly Jean" ;
schema:name "Beverly Jean Dretzke" ;
.

<http://worldcat.org/isbn/9780136043874>
a schema:ProductModel ;
schema:isbn "0136043879" ;
schema:isbn "9780136043874" ;
.

Content-negotiable representations