Statistics with Microsoft Excel

by Dretzke, Beverly

• ISBN13: 9780136043874
• ISBN10: 0136043879
• Edition: 4th
• Format: Paperback
• Copyright: 2009-01-01
• Publisher: Prentice Hall

Summary

Key Message: Statistics with Microsoft Excel reg; , Fourth Editionshows readers how to use Microsoft Excel reg; to perform statistical analysis. This step-by-step guide has been updated to cover the new features and new interface of Excel 2007. Key Topics: Getting Started; Entering, Editing, and Recoding Information; Formulas; Frequency Distributions; Descriptive Statistics; Probability Distributions; Testing Hypotheses About One Sample Means; Testing Hypotheses About the Difference Between Two Means; Analysis of Variance; Correlation; Regression; Cross Tabulations; Random Samples MARKET:For a variety of disciplines, including mathematics, the social sciences, and business. This book will be useful for data analysts and all readers who wish to use Excel to record, manipulate, and analyze their data.

Table of Contents

Getting Started

Introduction and Overview

What May Be Skipped

Excel Worksheet Basics

Dialog Boxes

Accessing Excel Files on the Web site

Saving Information

Printing

Loading Excel's Analysis ToolPak

Entering, Editing, and Recoding Information

Opening Documents

Entering Information

Editing Information

Formatting Numbers

Recoding

Sorting

Formulas

Operators

Using Formulas in Statistics

Frequency Distributions

Frequency Distributions Using Pivot Table and Pivot Chart

Frequency Distributions Using Data Analysis Tools

Descriptive Statistics

Data Analysis Tools: Descriptive Statistics

Functions: Descriptive Statistics

Pivot Table: Descriptive Statistics

Probability Distributions

Discrete Probability Distributions

Continuou

Table of Contents provided by Publisher. All Rights Reserved.