Ping Yuen PY Cheng Analysis of Experimental Data Microsoft(R)Excel or Spss??! Sharing of Experience English Version

Annotation

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, illustrativeand directive, and is very useful for both practitioners and those who performstatistical analysis in experimental designsOne the other hand, there is a general belief that after getting a significantAnova result, using the built-in Analysis TookPak MicrosoftExcel 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 MicrosoftExcel Add-In PHStat2 ver.3.0, from Dr Robert Jantzen, Universityof Connecticut, Stamford, is totally free also and seems even more powerful than Analysis TookPak, including a more automatic Tukeys-Kramer MultipleComparison Post Hoc Test. Lastly, we would introduce a very powerful MicrosoftExcel Add-In, XLSTAT,that can perform many important statistical tests as if using SPSS! Although thisis not totally free, it provides a 30 days full function trial version and a studentannual 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.