Includes numerous relevant examples and case studies drawn fr
Trade Review
"…a primer suited for the inexperienced student or novice researcher in search of a basic foundation of data analysis within the Windows platform." (American Journal of Pharmaceutical Education, Vol. 69, No. 5 (2005)) "There is no reason that anyone who wants to learn how to do statistics using Microsoft Excel would not find this book useful." (CHOICE, July 2005)
"The writing is straightforward and the explanations provided by the author clearly illustrate with liberal inclusion of examples and computer printouts the material discussed." (Journal of Hazardous Materials, June 2005)
"…an invaluable text allowing students to develop appropriate key skills…" (Journal of the American Water Resources Association, February 2005)
"…ideal for any science student who needs a primer in using Microsoft software for data analysis...teachers who support project-based learning will find this complete review invaluable." (NSTA Recommends)
"This book should be very useful…especially useful to anyone needing to become more familiar with Microsoft applications." (Doody's Book Review Service)
" … a comprehensive and useful book which covers virtually all aspects of data analysis and its presentation." (Journal of Biological Education, Spring 2006: Vol.40; 2)
Table of Contents
Preface. 1 Working in theWindows Environment.
1.1 Basic computing terms.
1.2 Working inWindows.
1.3 General functions in Microsoft applications.
2 Researching and Planning Scientific Investigations.
2.1 Sources of information.
2.2 Experimental design.
3 Presenting Scientific Data.
3.1 An Introduction to Microsoft Excel.
3.2 Presenting graphs and charts.
4 Preliminary Data Analysis.
4.1 Descriptive statistics.
4.2 Frequency distributions .
4.3 Correlation and linear regression
5 Statistical Analysis.
5.1 Selecting a statistical test.
5.2 Statistical tests for two samples.
5.3 Analysis of variance.
5.4 The Chi-squared test.
6 Presentational Skills.
6.1 Preparing for seminars.
6.2 Using Microsoft PowerPoint.
6.3 Poster presentations.
Appendix.
Further reading.
Alt key codes for special symbols in Microsoft applications.
Statistical tables.
Index.
