data, how to analyze data and finally how to present the results. The book uses Microsoft Excel and the powerful Open Source R program to carry out data handling as well as producing graphs. Statistical approaches covered include: data exploration; tests for difference - t-test and U-test; correlation - Spearman's rank test and Pearson product-moment; association including Chi-squared tests and goodness of fit; multivariate testing using analysis of variance (ANOVA) and Kruskal-Wallis test; and multiple regression. Key skills taught in this book include: how to plan ecological projects; how to record and assemble your data; how to use R and Excel for data analysis and graphs; how to carry out a wide range of statistical analyses including analysis of variance and regression; how to create professional looking graphs; and how to present your results.New in this edition: a completely revised chapter on graphics including graph types and their uses, Excel Chart Tools, R graphics commands and producing different chart types in Excel and in R; an expanded range of support material online, including; example data, exercises and additional notes & explanations; a new chapter on basic community statistics, biodiversity and similarity; chapter summaries and end-of-chapter exercises. Praise for the first edition: This book is a superb way in for all those looking at how to design investigations and collect data to support their findings. - Sue Townsend, Biodiversity Learning Manager, Field Studies Council [M]akes it easy for the reader to synthesise R and Excel and there is extra help and sample data available on the free companion webpage if needed. I recommended this text to the university library as well as to colleagues at my student workshops on R. Although I initially bought this book when I wanted to discover R I actually also learned new techniques for data manipulation and management in Excel - Mark Edwards, EcoBlogging A must for anyone getting to grips with data analysis using R and excel.- Amazon 5-star review It has been very easy to follow and will be perfect for anyone. - Amazon 5-star review A solid introduction to working with Excel and R. The writing is clear and informative, the book provides plenty of examples and figures so that each string of code in R or step in Excel is understood by the reader. - Goodreads, 4-star review

Hide more