Data Analysis with Microsoft Excel / Edition 1

Data Analysis with Microsoft Excel / Edition 1

by Kenneth N. Berk, Kenneth Berk
     
 

ISBN-10: 0534529291

ISBN-13: 9780534529291

Pub. Date: 09/28/1997

Publisher: Wadsworth

Learn how to solve real-life business problems and generate professional reports that include spreadsheets and graphics by harnessing the power of Microsoft Excel for Windows 95, 98, Me, 2000, and XP. This book teaches readers how to use Excel - the industry standard software for spreadsheets - to do statistical analysis and the number-crunching that is often

…  See more details below

Overview

Learn how to solve real-life business problems and generate professional reports that include spreadsheets and graphics by harnessing the power of Microsoft Excel for Windows 95, 98, Me, 2000, and XP. This book teaches readers how to use Excel - the industry standard software for spreadsheets - to do statistical analysis and the number-crunching that is often required in business. This book is ideal for anyone who finds themselves having to make recommendations, forecasts, or decisions based upon sets of real data. Even readers with no previous experience using computer spreadsheets will find this text's step-by-step approach and use of numerous screen shots make it easy to learn to use Excel in analyzing data sets. The authors have included a wide range of real-world examples to show how the skills the book teaches apply to a variety of business situations.

  • The text includes a wide range of real-world examples to show how the skills the book teaches apply to a variety of business situations.

  • This text includes a data analysis add-in toolpak on disk that significantly enhances the statistical capabilities of Excel. Among the additional procedures and graphics made possible with this one-of-a-kind toolpak are boxplots, quality control charts, scatterplot matrices, and correlation matrices.

  • Summary boxes allow students to quickly apply techniques learned to new data sets.

  • Interactive Excel instructional templates allow students to gain an intuitive understanding of difficult statistical concepts such as hypothesis testing and the Central Limit Theorem.

  • The text includes introductory sections designed to walk first-time users of Excel through thesoftware's basic functions.

  • StatPlus Add-ins are included in every new copy of the book.

  • The book has been updated for the Windows 95 environment.

  • New exercises appear in every chapter.

Read More

Product Details

ISBN-13:
9780534529291
Publisher:
Wadsworth
Publication date:
09/28/1997
Series:
Business Statistics Ser.
Edition description:
Older Edition
Pages:
503
Product dimensions:
7.35(w) x 9.09(h) x 0.91(d)

Table of Contents

Pt. 1Excel1
Ch. 1Getting Started with Excel3
Ch. 2Working with Data38
Ch. 3Working with Charts78
Pt. 2Fundamentals of Statistics117
Ch. 4Describing Your Data119
Ch. 5Probability Distributions172
Ch. 6Statistical Inference210
Ch. 7Tables260
Pt. 3Statistical Methods297
Ch. 8Regression and Correlation299
Ch. 9Multiple Regression337
Ch. 10Analysis of Variance373
Ch. 11Time Series413
Ch. 12Quality Control474
Appendix507
Excel Reference508
Bibliography575
Index577

Read More

Customer Reviews

Average Review:

Write a Review

and post it to your social network

     

Most Helpful Customer Reviews

See all customer reviews >