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 |