Preview this item
Preview this item
Checking...

# Data analysis with Microsoft Excel

Author: Kenneth N Berk; Patrick Carey Pacific Grove : Duxbury Press, ©1998. Print book : CD for computer : EnglishView all editions and formats A guide to using Microsoft Excel for Windows 95 for statistical analysis in business. With a step-by-step approach and the use of numerous screen shots, the book is intended even for students who  Read more... (not yet rated) 0 with reviews - Be the first.

## Find a copy in the library

Finding libraries that hold this item...

## Details

Material Type: Internet resource Book, Internet Resource Kenneth N Berk; Patrick Carey Find more information about: Kenneth N Berk Patrick Carey 0534529291 9780534529291 36922502 Revised edition of: Data analysis with Microsoft Excel 5.0 for Windows. c1995. xxi, 503 pages : illustrations ; 24 cm ₊ 1 computer disc (3 1/2 in.) System requirements for accompanying computer disk: Windows 95 or Windows 97. Part 1 Getting started: accessing the student files; launching Excel; using the Excel window; opening an Excel window; using the worksheet window; formulas and functions; printing worksheets; saving your work; exiting Excel. Part 2 Entering and manipulating data: entering data; defining range names; cell references; inserting new data; sorting data; querying data; importing data from a text file; creating new variables; freeze planes. Part 3 Single variable graphs and statistics: statistics and distributions; frequency tables and histograms; statistics describing a distribution; boxplots; distribution shapes; other descriptive statistics; Part 4 Scatterplots: creating scatterplots with the chart wizard; editing a chart; working with the data series; plotting several Y's; plotting two variables with a grouping variable; scatterplot matrices. Part 5 Probability distributions: random variables; probability distributions; normal data; the normal probability plot (PPlot); the distribution of the sample mean; the central-limit theorem. Part 6 Statistical inference: confidence intervals; hypothesis testing; the T distribution; paired comparisons; two sample comparisons. Part 7 Tables: variable types - continuous and categorical; pivot tables; pie charts; bar charts; two-way tables; the chi-square distribution; computing expected values; Pearson chi-square statistic; validity of chi-square test with small frequencies; tables with ordinal values. Part 8 Correlation and simple regression: simple linear regression; correlation; regression analysis with Excel; correlation and plot matrices; graphing relationships. Part 9 Multiple regression: regression models; the F distribution; regression assumptions; using regression for prediction; regression example - predicting grades; useful plots; regression example - sex discrimination. Part 10 Analysis of variance: one-way analysis of variance; multiple comparisons - Bonferroni test; one-way analysis of variance; two-way analysis of variance. Part 11 Time series: time-series concepts; the Dow in the '80s; lagged values; the autocorrelation function; simple exponential smoothing and forecasting; two-parameter exponential smoothing; seasonality; seasonal example - beer production; three-parameter exponential smoothing; optimizing the exponential smoothing. Part 12 Quality control: statistical quality control; control charts; the mean chart when sigma is known; the mean chart when sigma is unknown; the range chart; the C-chart; the P-chart; the Pareto chart. Data analysis Excel Kenneth N. Berk, Patrick Carey.

## Reviews

User-contributed reviews

Be the first.

## Similar Items

### Related Subjects:(9)

Confirm this request

You may have already requested this item. Please select Ok if you would like to proceed with this request anyway.

### Primary Entity

<http://www.worldcat.org/oclc/36922502> # Data analysis with Microsoft Excel
a schema:Book, schema:CreativeWork, bgn:CD ;
library:oclcnum "36922502" ;
library:placeOfPublication <http://id.loc.gov/vocabulary/countries/cau> ;
library:placeOfPublication <http://experiment.worldcat.org/entity/work/data/713501#Place/pacific_grove> ; # Pacific Grove
rdfs:seeAlso <http://experiment.worldcat.org/entity/work/data/713501#CreativeWork/data_analysis_with_microsoft_excel_5_0_for_windows> ; # Data analysis with Microsoft Excel 5.0 for Windows.
schema:about <http://experiment.worldcat.org/entity/work/data/713501#Topic/microsoft_excel> ; # Microsoft Excel
schema:about <http://experiment.worldcat.org/entity/work/data/713501#Topic/statistik> ; # Statistik
schema:about <http://experiment.worldcat.org/entity/work/data/713501#Topic/excel> ; # EXCEL
schema:about <http://id.worldcat.org/fast/1366659> ; # Microsoft Excel (Computer file)
schema:about <http://experiment.worldcat.org/entity/work/data/713501#CreativeWork/microsoft_excel_computer_file> ; # Microsoft Excel (Computer file)
schema:about <http://experiment.worldcat.org/entity/work/data/713501#Topic/data_analyse> ; # Data-analyse
schema:about <http://id.loc.gov/authorities/subjects/sh85082137> ; # Mathematical statistics--Data processing
schema:about <http://id.worldcat.org/fast/1012133> ; # Mathematical statistics--Data processing
schema:about <http://experiment.worldcat.org/entity/work/data/713501#Topic/matematica_da_computacao> ; # Matemática da computação
schema:alternateName "Data analysis Excel" ;
schema:bookFormat bgn:PrintBook ;
schema:contributor <http://viaf.org/viaf/38657650> ; # Kenneth N. Berk
schema:contributor <http://viaf.org/viaf/23881620> ; # Patrick Carey
schema:creator <http://viaf.org/viaf/38657650> ; # Kenneth N. Berk
schema:datePublished "1998" ;
schema:exampleOfWork <http://worldcat.org/entity/work/id/713501> ;
schema:inLanguage "en" ;
schema:name "Data analysis with Microsoft Excel"@en ;
schema:productID "36922502" ;
schema:publication <http://www.worldcat.org/title/-/oclc/36922502#PublicationEvent/pacific_grove_duxbury_press_1998> ;
schema:publisher <http://experiment.worldcat.org/entity/work/data/713501#Agent/duxbury_press> ; # Duxbury Press
schema:url <http://catdir.loc.gov/catdir/enhancements/fy1515/97014883-t.html> ;
schema:workExample <http://worldcat.org/isbn/9780534529291> ;
wdrs:describedby <http://www.worldcat.org/title/-/oclc/36922502> ;
.

### Related Entities

<http://experiment.worldcat.org/entity/work/data/713501#Agent/duxbury_press> # Duxbury Press
a bgn:Agent ;
schema:name "Duxbury Press" ;
.

<http://experiment.worldcat.org/entity/work/data/713501#CreativeWork/data_analysis_with_microsoft_excel_5_0_for_windows> # Data analysis with Microsoft Excel 5.0 for Windows.
a schema:CreativeWork ;
schema:creator <http://viaf.org/viaf/38657650> ; # Kenneth N. Berk
schema:name "Data analysis with Microsoft Excel 5.0 for Windows." ;
.

<http://experiment.worldcat.org/entity/work/data/713501#CreativeWork/microsoft_excel_computer_file> # Microsoft Excel (Computer file)
a schema:CreativeWork ;
schema:name "Microsoft Excel (Computer file)" ;
.

a schema:Intangible ;
schema:name "Computadores (ciências da computação)"@en ;
.

<http://experiment.worldcat.org/entity/work/data/713501#Topic/matematica_da_computacao> # Matemática da computação
a schema:Intangible ;
schema:name "Matemática da computação"@en ;
.

<http://id.loc.gov/authorities/subjects/sh85082137> # Mathematical statistics--Data processing
a schema:Intangible ;
schema:name "Mathematical statistics--Data processing"@en ;
.

<http://id.worldcat.org/fast/1012133> # Mathematical statistics--Data processing
a schema:Intangible ;
schema:name "Mathematical statistics--Data processing"@en ;
.

<http://id.worldcat.org/fast/1366659> # Microsoft Excel (Computer file)
a schema:CreativeWork ;
schema:name "Microsoft Excel (Computer file)" ;
.

<http://viaf.org/viaf/23881620> # Patrick Carey
a schema:Person ;
schema:birthDate "1961" ;
schema:familyName "Carey" ;
schema:givenName "Patrick" ;
schema:name "Patrick Carey" ;
.

<http://viaf.org/viaf/38657650> # Kenneth N. Berk
a schema:Person ;
schema:birthDate "1938" ;
schema:familyName "Berk" ;
schema:givenName "Kenneth N." ;
schema:name "Kenneth N. Berk" ;
.

<http://worldcat.org/isbn/9780534529291>
a schema:ProductModel ;
schema:isbn "0534529291" ;
schema:isbn "9780534529291" ;
.

Content-negotiable representations