Related Products

Statistics With 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 Started

p. 1

Introduction and Overview

p. 1

Versions of Excel

p. 1

Versions of Windows

p. 2

What May Be Skipped

p. 2

More Detailed Information on Excel

p. 2

Excel Worksheet Basics

p. 3

Using the Mouse

p. 3

Starting Excel

p. 4

Exiting Excel

p. 4

Layout of Worksheets and Workbooks

p. 4

Menus, Toolbars, and Dialog Boxes

p. 8

Manipulating Windows

p. 9

Ways to Get Help

p. 10

Help on the Main Menu

p. 10

Answer Wizard

p. 11

Entering, Saving, and Editing Information

p. 13

Opening and Saving Documents

p. 13

Opening a Brand-New Worksheet

p. 13

Opening a File You Have Already Created

p. 13

Entering Information

p. 14

Addresses

p. 14

Activating a Cell or Range of Cells

p. 14

Types of Information

p. 15

Changing Information

p. 15

Moving and Copying Information

p. 15

Dragging and Dropping

p. 16

Formatting Numbers

p. 16

Aligning Information

p. 17

Formatting a Range

p. 17

Inserting or Deleting Rows and Columns

p. 18

Filling Adjacent Cells

p. 18

Series

p. 19

Sorting

p. 19

Saving and Retrieving Information

p. 20

Naming Workbooks

p. 20

Printing

p. 21

Page Setup

p. 21

Enhancing Output

p. 24

Using Formulas and Functions

p. 25

Operators

p. 25

Order of Operations

p. 25

Writing Equations

p. 26

Entering Formulas

p. 27

Relative References

p. 29

Absolute References

p. 29

Frequency Distributions

p. 31

Histogram Using Analysis Tools

p. 31

Sorting the Data

p. 32

Sorting: Potential Problems

p. 32

Bins

p. 33

Interpreting the Output

p. 37

Modifying and Printing the Histogram Chart

p. 37

Pivot Table

p. 38

Sample Research Problem

p. 38

Setting up a Pivot Table

p. 39

Pivot Table: Frequency Distributions

p. 42

Descriptive Statistics

p. 45

Data Analysis Tools: Descriptive Statistics

p. 45

Sample Research Problem

p. 45

Steps to Follow to Obtain Descriptive Statistics for a Single Variable

p. 45

Interpreting the Output

p. 47

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

p. 50

Function Wizard: Descriptive Statistics

p. 51

Sample Research Problem

p. 51

Steps to Follow to Obtain Descriptive Statistics for One Variable

p. 52

Interpreting the Output

p. 55

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