Doing statistics with Excel 97 : (Record no. 5486)

MARC details
000 -LEADER
fixed length control field 07183nam a22003137a 4500
003 - CONTROL NUMBER IDENTIFIER
control field OSt
005 - DATE AND TIME OF LATEST TRANSACTION
control field 20210728061647.0
008 - FIXED-LENGTH DATA ELEMENTS--GENERAL INFORMATION
fixed length control field 210728b ||||| |||| 00| 0 eng d
020 ## - INTERNATIONAL STANDARD BOOK NUMBER
International Standard Book Number 0471251712
020 ## - INTERNATIONAL STANDARD BOOK NUMBER
International Standard Book Number 9780471251712
040 ## - CATALOGING SOURCE
Original cataloging agency BUL
Transcribing agency BUL
Modifying agency BUL
Language of cataloging ENG
Description conventions RDA
082 00 - DEWEY DECIMAL CLASSIFICATION NUMBER
Classification number 519.5/0285/5369
Edition number 21
Item number PEL
100 1# - MAIN ENTRY--PERSONAL NAME
Personal name Pelosi, Marilyn K.
245 10 - TITLE STATEMENT
Title Doing statistics with Excel 97 :
Remainder of title software instruction and exercise activity supplement /
Statement of responsibility, etc. Marilyn K. Pelosi, Theresa M. Sandifer, Jerzy J. Letkowski.
260 ## - PUBLICATION, DISTRIBUTION, ETC.
Place of publication, distribution, etc. New York :
Name of publisher, distributor, etc. J. Wiley & Sons,
Date of publication, distribution, etc. c1998.
300 ## - PHYSICAL DESCRIPTION
Extent xiv, 338 p. :
Other physical details ill. ;
Dimensions 26 cm. +
Accompanying material 1 computer disk (3 1/2 in.)
500 ## - GENERAL NOTE
General note CONTENTS<br/><br/>Chapter 1 An Introduction to the Workbook 1<br/> Section 1. I Overview 1<br/> Section 1.2 Objectives of the Workbook 1<br/> Section 1.3 Description of the Data Sets 2<br/> Section 1.4 Organization of the Workbook 2<br/> Section 1.5 How to Use the Workbook 4<br/> Section 1.6 Web Pages 4<br/><br/>Chapter 2 The Basics of Windows 5<br/> Section 2.1 Overview 5<br/> Section 2.2 Starting Windows 95 5<br/> Section 2.3 The Windows 95 Desktop 5<br/> Section 2.4 Using the Mouse 7<br/> Section 2.5 Using the Keyboard 9<br/> Section 2.6 Windows Structure and Behavior 14<br/> Section 2.7 My Computer 22<br/> Section 2.8 Windows Explorer 24<br/> Section 2.9 Exiting Explorer and Windows 29<br/><br/>Chapter 3 The Basics in Microsoft Excel 97 31<br/> Section 3.1 Overview 31<br/> Section 3.2 Launching Excel 31<br/> Section 3.3 Statistical Data in Excel 36<br/> Section 3.4 Saving a Workbook 39<br/> Section 3.5 Using Named References in Excel 41<br/> Section 3.6 Printing Your Work 43<br/> Section 3.7 Exiting Excel 47<br/><br/>Chapter 4 Displaying Qualitative Data 49<br/> Section 4.1 Overview 49<br/> Section 4.2 Problem Statement 49<br/> Section 4.3 Characteristics of the Data Set 50<br/> Section 4.4 Overview of Graphs in Excel 51<br/> Section 4.5 How to Create Column Charts in Excel 51<br/> Section 4.6 Clustered and Stacked Column Charts 66<br/> Section 4.7 How to Create a Pie Chart in Excel 76<br/> Section 4.8 Consolidating Data 83<br/> Section 4.9 Pareto Diagrams 87<br/> Section 4.10 Looking at the Data for Different Time Periods 89<br/> Section 4.11 Investigative Exercises 90<br/><br/>Chapter 5 Displaying Quantitative Data 95<br/> Section 5.1 Overview 95<br/> Section 5.2 Problem Statement 95<br/> Section 5.3 Characteristics of the Data Set 97<br/> Section 5.4 How to Create a Histogram in Excel 99<br/> Section 5.5 Creating Histograms for Subsets of a Variable 117<br/> Section 5.6 Investigative Exercises 129<br/><br/>Chapter 6 Numerical Descriptors 135<br/> Section 6.1 Overview 135<br/> Section 6.2 Problem Statement 135<br/> Section 6.3 Generating Descriptive Statistics for an Entire<br/> Column of data 136<br/> Section 6.4 Generating Descriptive Statistics for Grouped Data 146<br/> Section 6.5 Descriptive Statistics Tool Versus Excel Functions 156<br/> Section 6.6 Creating a Boxplot and Detecting Outliers 157<br/> Section 6.7 Investigative Exercises 162<br/><br/>Chapter 7 A Study of The Binomial Distribution 169<br/> Section 7.1 Overview 169<br/> Section 7.2 Problem Statement 170<br/> Section 7.3 Characteristics of the Data Set 170<br/> Section 7.4 Detecting a Binomial Variable 172<br/> Section 7.5 The Binomial Distribution in Excel 174<br/> Section 7.6 Plotting the Binomial Distribution in Excel 179<br/> Section 7.7 Estimating the Probability of Success, p 182<br/> Section 7.8 The Beginnings of Hypothesis Testing 188<br/> Section 7.9 Investigative Exercises 191<br/><br/>Chapter 8 A Study of the Normal Distribution 193<br/> Section 8.1 Overview 193<br/> Section 8.2 Problem Statement 193<br/> Section 8.3 Characteristics of the Data Set 195<br/> Section 8.4 Normal Distribution in Excel 196<br/> Section 8.5 Plotting the Normal Distribution 203<br/> Section 8.6 Changing the Normal Distribution 205<br/> Section 8.7 Empirical Rules for Testing Normality 208<br/> Section 8.8 Investigative Exercises 215<br/><br/>Chapter 9 A Study of the Central Limit Theorem 219<br/> Section 9.1 Overview 219<br/> Section 9.2 Problem Statement 219<br/> Section 9.3 Characteristics of the Data Set 220<br/> Section 9.4 Finding Sample Means 221<br/> Section 9.5 The Central Limit Theorem 227<br/> Section 9.6 Control Charts in Excel 227<br/> Section 9.7 Investigative Exercises 237<br/><br/>Chapter 10 Hypothesis Tests - One Population 241<br/> Section 10.1 Overview 241<br/> Section 10.2 Problem Statement 241<br/> Section 10.3 Characteristics of the Data Set 242<br/> Section 10.4 Testing a Hypothesis 243<br/> Section 10.5 Hypothesis Testing in Excel 244<br/> Section 10.6 Interpreting the Test Output 245<br/> Section 10.7 After the Test - Now What? 247<br/> Section 10.8 Other Considerations 250<br/> Section 10.9 Investigative Exercises 251<br/><br/>Chapter 11 Hypothesis Tests -Two Populations 255<br/> Section 11. I Overview 255<br/> Section 11.2 Problem Statement 255<br/> Section 11.3 Characteristics of the Data Set 256<br/> Section 11.4 Hypothesis Testing - Two Populations 257<br/> Section 11.5 Investigative Exercises 266<br/><br/>Chapter 12 Testing Proportions 269<br/> Section 12.1 Overview 269<br/> Section 12.2 Problem Statement 269<br/> Section 12.3 Characteristics of the Data Set 270<br/> Section 12.4 Creating Cross Tabulation Tables in Excel 272<br/> Section 12.5 Hypothesis Test on a Single Proportion Using Excel 279<br/> Section 12.6 Comparing Two Proportions: Hypothesized<br/> Difference of Zero 286<br/> Section 12.7 Investigative Exercises 292<br/><br/>Chapter 13 Chi-Square Test for Independence 299<br/> Section 13.1 Overview 299<br/> Section 13.2 Problem Statement 299<br/> Section 13.3 Chi-Square Test for Independence 299<br/> Section 13.4 Investigative Exercises 306<br/><br/>Chapter 14 Linear Regression and Correlation 309<br/> Section 14.1 Overview 309<br/> Section 14.2 Problem Statement 309<br/> Section 14.3 Characteristics of the Data Set 310<br/> Section 14.4 Regression and Correlation 311<br/> Section 14.5 Looking for Relationships 312<br/> Section 14.6 Measuring Relationships 317<br/> Section 14.7 Finding the Regression Model 319<br/> Section 14.8 Testing Significance of the Model 320<br/> Section 14.9 Examining the Fit of the Model 323<br/> Section 14.10 Interpolation and Extrapolation 326<br/> Section 14.11 Investigative Exercises 331<br/><br/>Chapter 15 Pulling It All Together 335<br/> Section 15.1 Overview 335<br/> Section 15.2 Problem Statement 335<br/> Section 15.3 Characteristics of the Data Set 337<br/> Section 15.4 Investigative Exercises 338<br/><br/>
500 ## - GENERAL NOTE
General note "This disk contains data files for use in workbook chapters 4 through 15"--Label on disk.
630 00 - SUBJECT ADDED ENTRY--UNIFORM TITLE
Uniform title Microsoft Excel (Computer file)
650 #0 - SUBJECT ADDED ENTRY--TOPICAL TERM
Topical term or geographic name entry element Commercial statistics
General subdivision Computer programs.
650 #0 - SUBJECT ADDED ENTRY--TOPICAL TERM
Topical term or geographic name entry element Economics
General subdivision Statistical methods
-- Computer programs.
700 1# - ADDED ENTRY--PERSONAL NAME
Personal name Sandifer, Theresa M.
700 1# - ADDED ENTRY--PERSONAL NAME
Personal name Letkowski, Jerzy J.
856 42 - ELECTRONIC LOCATION AND ACCESS
Materials specified Publisher description
Uniform Resource Identifier <a href="http://www.loc.gov/catdir/description/wiley033/98138197.html">http://www.loc.gov/catdir/description/wiley033/98138197.html</a>
856 7# - ELECTRONIC LOCATION AND ACCESS
Materials specified Table of contents
Uniform Resource Identifier <a href="http://lcweb.loc.gov/catdir/toc/98-138197.html">http://lcweb.loc.gov/catdir/toc/98-138197.html</a>
Access method http
906 ## - LOCAL DATA ELEMENT F, LDF (RLIN)
a 7
b cbc
c orignew
d 2
e ncip
f 19
g y-gencatlg
942 ## - ADDED ENTRY ELEMENTS (KOHA)
Source of classification or shelving scheme Dewey Decimal Classification
Koha item type Book Closed Access
Classification part 519.5/0285/5369
Item part 1
Call number prefix PEL
Call number suffix 519.5/0285/5369 PEL
Holdings
Withdrawn status Lost status Source of classification or shelving scheme Damaged status Not for loan Home library Current library Date acquired Source of acquisition Total Checkouts Full call number Barcode Date last seen Copy number Price effective from Koha item type
    Dewey Decimal Classification     Engineering Library Engineering Library 07/28/2021 Donation   519.5/0285/5369 PEL 1 0012391 07/28/2021 1 07/28/2021 Book Closed Access