Analysis of Experimental Data Microsoft®Excel or SPSS??! Sharing of Experience English Version

About the Book

The first characteristic of this book is the skipping of difficult theories, starting directly with typical examples, and the working out of the answers clearly by computer software. The aim is to help readers to be able to solve basic statistical problems in various Common Experimental Designs as soon as possible, and to be confident to run the tests and interpret the computer output, without being hesitated by the starting with large amount of difficult theories behind. This book has been reviewed by some experts as ‘…very practical, illustrative and directive, and is very useful for both practitioners and those who perform statistical analysis in experimental designs…’ One the other hand, there is a general belief that after getting a significant Anova result, using the built-in ‘Analysis TookPak’ Microsoft®Excel Add-In, nothing can be done further to find where do the differences exist, and we must use large packages such as SPSS to complete the job! However, we find that this might not be absolutely true. We can often find similar results as using SPSS by combining the overall Anova results with a few, simple, manual steps introduced in this book! An Microsoft®Excel Add-In ‘PHStat2 ver.3.0’, from Dr Robert Jantzen, University of Connecticut, Stamford, is totally free also and seems even more powerful than Analysis TookPak, including a ‘more automatic’ Tukey’s-Kramer’ Multiple Comparison Post Hoc Test. Lastly, we would introduce a very powerful Microsoft®Excel Add-In, ‘XLSTAT’, that can perform many important statistical tests as if using SPSS! Although this is not totally free, it provides a 30 days full function trial version and a student annual price of only US$ 50, that is much cheaper than SPSS etc.! We would use it to show ‘Repeated Measures’, ‘Repeated measures Anova’ and ‘Ancova’ that are only analyzed by e.g. SPSS otherwise.

About the Author