This is a book about the scientific process and how we apply it to data in ecology. We will learn how to plan for data collection, how to assemble data, how to analyse 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. Who this book is for Students of ecology and environmental science will find this book aimed at them although many other scientists will find the text useful as the principles and data analysis are the same in many disciplines. No prior knowledge is assumed and the reader can develop their skills to degree level and beyond. What you will learn from this book How to plan ecological projects How to record and assemble your data How to use Excel for data analysis and graphs How to use R for data analysis and graphs How to carry out a wide range of statistical analyses How to create professional looking graphs How to present your resultsHere we have to consider empty cells as well and use an If statement We have chosen a simple 1a5 scale here but we ... we start we should select the appropriate cells and use the sort button (Figure 34 shows how to do this in Excel 2007).
|Title||:||Statistics for Ecologists Using R and Excel|
|Publisher||:||Pelagic Publishing - 2012-01-01|