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

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.

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

PART I: EXCEL. 1. Getting Started with Excel. 2. Working with Data. 3. Working with Charts. PART II: FUNDAMENTALS OF STATISTICS. 4. Describing Your Data. 5. Probability Distributions. 6. Statistical Inference. 7. Tables. PART III: STATISTICAL METHODS. 8. Regression and Correlation. 9. Multiple Regression. 10. Analysis of Variance. 11. Time Series. 12. Quality Control. Appendix. Excel Reference. Bibliography. Index.

Customer Reviews

Average Review:

Write a Review

and post it to your social network

     

Most Helpful Customer Reviews

See all customer reviews >