NoNO

Excel Manual to Accompany
James T. McClave
P. George Benson and Terry Sincich's

Statistics for Business and Economics
Tenth Edition

Mark Dummeldinger
University of South Florida

Table of Contents
Primer

Excel Basics Needed for Statistical Analysis of Data
P.1

Introduction and Overview
1
P.1.1 Versions of Excel
1
P.1.2 Versions of Windows
1
P.1.3 What May be Skipped 2
P.1.4 More Detailed Information on Excel

2

P.2

What You Need to Know to Begin Using Excel 2
P.2.1 Using the Mouse 2
P.2.2.1 Starting and Exiting PHStat
3
P.2.2.2 Starting and Exiting Excel
3
P.2.3 Layout of Worksheets and Worksheets
4
P.2.4 Menus, Toolbars and Dialog Boxes 7
P.2.5 Manipulating Windows 9

P.3

Ways to Get Help 10
P.3.1 Help on the Main Menu

P.4

10

Opening and Saving Documents
12
P.4.1 Opening a Brand New Spreadsheet
12
P.4.2 Opening a File you have Already Created

P.5

Entering Information
13
P.5.1 Activating a Cell or Range of Cells
13
P.5.2 Types of Information
14
P.5.3 Changing Information
14
P.5.4 Moving and Copying Information
15

P.6

Formatting Numbers
16
P.6.1 Aligning Information
17
P.6.2 Formatting a Range
17
P.6.3 Inserting or Deleting Rows and Columns
P.6.4 Filling Adjacent Cells
18
P.6.5 Series
19
P.6.6 Sorting
19

12

P.7

Saving and Retrieving Information
P.7.1 Naming Workbooks
21

P.8

Printing
22
P.8.1 Page Setup
22
P.8.2 Page
22
P.8.3 Margins
23
P.8.4 Header/Footer
23
P.8.5 Sheet
25

iii

21

17

iv Contents

P.8.6
P.8.7
P.8.8

Enhancing Output
25
Inserting and Removing Page Breaks
Preview and Print
26

P.9

Using Formulas and Functions
P.9.1 Operators
27
P.9.2 Order of Operators
27
P.9.3 Writing Equations
28

P.10

Entering Formulas
30
P.10.1 Relative References
P.10.2 Absolute References

25

27

31
32

Chapter 1

Statistics, Data, and Statistical Thinking
1.1
Introduction
34

Chapter 2