skip to content
Data analysis with Microsoft Excel Preview this item
ClosePreview this item

Data analysis with Microsoft Excel

Author: Kenneth N Berk; Patrick Carey
Publisher: Pacific Grove : Duxbury Press, ©1998.
Edition/Format:   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.

More like this


Find a copy in the library

&AllPage.SpinnerRetrieving; Finding libraries that hold this item...


Material Type: Internet resource
Document Type: Book, Internet Resource
All Authors / Contributors: Kenneth N Berk; Patrick Carey
ISBN: 0534529291 9780534529291
OCLC Number: 36922502
Notes: Revised edition of: Data analysis with Microsoft Excel 5.0 for Windows. c1995.
Description: xxi, 503 pages : illustrations ; 24 cm ₊ 1 computer disc (3 1/2 in.)
Details: System requirements for accompanying computer disk: Windows 95 or Windows 97.
Contents: 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.
Other Titles: Data analysis Excel
Responsibility: Kenneth N. Berk, Patrick Carey.
More information:


User-contributed reviews
Retrieving GoodReads reviews...
Retrieving DOGObooks reviews...


Be the first.
Confirm this request

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

Linked Data

Primary Entity

<> # Data analysis with Microsoft Excel
    a schema:Book, schema:CreativeWork, bgn:CD ;
   library:oclcnum "36922502" ;
   library:placeOfPublication <> ;
   library:placeOfPublication <> ; # Pacific Grove
   rdfs:seeAlso <> ; # Data analysis with Microsoft Excel 5.0 for Windows.
   schema:about <> ; # Microsoft Excel
   schema:about <> ; # Statistik
   schema:about <> ; # Computadores (ciências da computação)
   schema:about <> ; # EXCEL
   schema:about <> ; # Microsoft Excel (Computer file)
   schema:about <> ; # Microsoft Excel (Computer file)
   schema:about <> ; # Data-analyse
   schema:about <> ;
   schema:about <> ; # Mathematical statistics--Data processing
   schema:about <> ; # Mathematical statistics--Data processing
   schema:about <> ; # Matemática da computação
   schema:alternateName "Data analysis Excel" ;
   schema:bookFormat bgn:PrintBook ;
   schema:contributor <> ; # Kenneth N. Berk
   schema:contributor <> ; # Patrick Carey
   schema:copyrightYear "1998" ;
   schema:creator <> ; # Kenneth N. Berk
   schema:datePublished "1998" ;
   schema:exampleOfWork <> ;
   schema:inLanguage "en" ;
   schema:name "Data analysis with Microsoft Excel"@en ;
   schema:productID "36922502" ;
   schema:publication <> ;
   schema:publisher <> ; # Duxbury Press
   schema:url <> ;
   schema:workExample <> ;
   wdrs:describedby <> ;

Related Entities

<> # Duxbury Press
    a bgn:Agent ;
   schema:name "Duxbury Press" ;

<> # Data analysis with Microsoft Excel 5.0 for Windows.
    a schema:CreativeWork ;
   schema:creator <> ; # Kenneth N. Berk
   schema:name "Data analysis with Microsoft Excel 5.0 for Windows." ;

<> # Microsoft Excel (Computer file)
    a schema:CreativeWork ;
   schema:name "Microsoft Excel (Computer file)" ;

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

<> # Matemática da computação
    a schema:Intangible ;
   schema:name "Matemática da computação"@en ;

<> # Mathematical statistics--Data processing
    a schema:Intangible ;
   schema:name "Mathematical statistics--Data processing"@en ;

<> # Mathematical statistics--Data processing
    a schema:Intangible ;
   schema:name "Mathematical statistics--Data processing"@en ;

<> # Microsoft Excel (Computer file)
    a schema:CreativeWork ;
   schema:name "Microsoft Excel (Computer file)" ;

<> # Patrick Carey
    a schema:Person ;
   schema:birthDate "1961" ;
   schema:familyName "Carey" ;
   schema:givenName "Patrick" ;
   schema:name "Patrick Carey" ;

<> # Kenneth N. Berk
    a schema:Person ;
   schema:birthDate "1938" ;
   schema:familyName "Berk" ;
   schema:givenName "Kenneth N." ;
   schema:name "Kenneth N. Berk" ;

    a schema:ProductModel ;
   schema:isbn "0534529291" ;
   schema:isbn "9780534529291" ;

Content-negotiable representations

Close Window

Please sign in to WorldCat 

Don't have an account? You can easily create a free account.