Analysis of Experimental Data Microsoft®Excel or Spss??! Sharing of Experience English Version (eBook)

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 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, University
of Connecticut, Stamford, is totally free also and seems even more powerful than Analysis TookPak, including a more automatic Tukeys-Kramer Multiple
Comparison 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 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.