Dr. Mark Gardener

 
About

Providing training for:

  • Ecology
  • Data analysis
  • Statistics
  • R The statistical programming language
  • Data management
  • Data mining

Publications and Support Notes

I have written several books on ecology and data analysis. On this page you can find:

  • My books on ecology and data analysis
  • Support material for my books
  • Don't Panic III – a spreadsheet tool for teaching and learning basic statistics
  • Current projects – notes about current projects

Managing Data Using Excel | Community EcologyStatistics for Ecologists
Beginning R | The Essential R Reference


My Publications

Follow me...
Facebook Twitter Google+ Linkedin Amazon

Get a 20% discount on "Statistics for Ecologists" when you buy direct from the publisher! Enter the voucher code S4E20 in the shopping basket at Pelagic Publishing.

 


Support Index for Edition 2.

See details of the original version (including support material) here.

More about R

The R website

My Amazon author profile

Back to top

Statistics for Ecologists using R and Excel

Data Collection, Exploration, Analysis and Presentation

by: Mark Gardener

Available now from Pelagic Publishing. Get a 20% discount using the S4E20 code!

This is a book about the scientific process and how you apply it to data in ecology. You will learn how to plan for data collection, how to assemble 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.

Statistics help you make sense of data, which is generated in all branches of science. Ecology is a wide-ranging and important science, which helps our understanding of the natural world.

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 up to degree level.

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 including analysis of variance and regression.
  • How to create professional looking graphs.
  • How to present your results.

What's new in Edition 2

  • Completely revised chapter on graphics.
  • Chapter on basic community statistics, biodiversity and similarity.
  • Chapter summaries.
  • End of chapter exercises

Statistics for Ecologists Using R and Excel

Statistics for Ecologists Edition 2 Cover

Available Now from:
Pelagic Publishing

Support Index page




Writer's Bloc - diary of a perplexed mind.

New: Statistics for Ecologists (Edition 2) Support Pages

See also MonogRaphs: a random series of notes related to R: the statistical programming language.

Current Project

See my Writer's Bloc page for notes about my latest project (now published), a new edition of "Statistics for Ecologists Using R and Excel: Data Collection, Exploration, Analysis and Presentation". You can find various notes about topics that are coming up as I produce the new edition. The book is available now from Pelagic Publishing.

New: Statistics for Ecologists (Edition 2) Support pages available now (e.g. Outline/TOC, exercises & notes).

The Writer's Bloc pages also include notes from previous projects:

Managing Data Using Excel: Organizing, Summarizing and Visualizing Scientific Data

Community Ecology: Analytical Methods Using R and Excel

The Writer's Bloc page(s) feature notes, example data and R scripts/code.

See also my MonogRaphs page(s) for notes related to R: the statistical programming language.

Statistics for Ecologists Using R and Excel

Statistics for Ecologists Edition 2 Cover

Available Now from:
Pelagic Publishing

Support Index page



Available now!

Get £5 discount on the paperback and £10 discount on the hardback when you buy direct from the publisher. Enter voucher code MDUE20 in the shopping basket at Pelagic Publishing.

Outline and TOC available here

Support files available here (datasets, chart templates and other spreadsheets)

My Amazon author profile

Back to top

Managing Data Using Excel

Organizing, Summarizing and Visualizing Scientific Data

by: Mark Gardener

Available now from Pelagic Publishing

Microsoft Excel is a powerful tool that can transform the way you use data. This book explains in comprehensive and user-friendly detail how to manage, make sense of, explore and share data, giving scientists at all levels the skills they need to maximise the usefulness of their data.

Readers will learn how to use Excel to:

  • Build a dataset – how to handle variables and notes, rearrangements and edits to data.
  • Check datasets – dealing with typographic errors, data validation and numerical errors.
  • Make sense of data – including datasets for regression and correlation; summarizing data with averages and variability; and visualizing data with graphs, pivot charts and sparklines.
  • Explore regression data – finding, highlighting and visualizing correlations.
  • Explore time-related data – using pivot tables, sparklines and line plots.
  • Explore association data – creating and visualizing contingency tables.
  • Explore differences – pivot tables and data visualizations including box-whisker plots.
  • Share data – methods for exporting and sharing your datasets, summaries and graphs.

Alongside the text, Have a Go exercises, Tips and Notes give readers practical experience and highlight important points, and helpful self-assessment exercises and summary tables can be found at the end of each chapter.

Managing Data Using Excel is an essential book for all scientists and students who use data and are seeking to manage data more effectively. It is aimed at scientists at all levels but it is especially useful for university-level research, from undergraduates to postdoctoral researchers.

See also my Writer's Bloc page for notes about various topics associated with the book. These were written as the book progressed, Excel spreadsheets that are mentioned will also be in the support material.

Managing Data Using Excel:
Organizing, Summarizing and Visualizing Scientific Data

Managing data using Excel cover

Available from:
Pelagic Publishing

Outline/TOC
Support Files




See an outline and TOC here

Support files available here (Excel, CSV and RData)

Custom R commands used in the book: see here for index, help and examples of use

News: Important changes and tweaks noted here

More about R

The R website

My Amazon author profile

Back to top

Community Ecology

Analytical Methods Using R and Excel

by: Mark Gardener

Available now from Pelagic Publishing.

Interactions between species are of fundamental importance to all living systems and the framework we have for studying these interactions is community ecology. This is important to our understanding of the planet's biological diversity and how species interactions relate to the functioning of ecosystems at all scales. Species do not live in isolation and the study of community ecology is of practical application in a wide range of conservation issues.

The study of ecological community data involves many methods of analysis. In this book you will learn many of the mainstays of community analysis including: diversity, similarity and cluster analysis, ordination and multivariate analyses. This book is for undergraduate and postgraduate students and researchers seeking a step-by-step methodology for analysing plant and animal communities using R and Excel.

Features:

  • Chapter summaries
  • End-of-chapter exercises
  • Have a Go examples/exercises
  • Custom R commands
  • Custom Excel worksheets

Key Topics:

  • Diversity (richness, indices, beta diversity, rank-abundance)
  • Cluster analysis (hierarchical and partitioning)
  • Association analysis (Chi square)
  • Ordination (e.g. PCA, CCA, NMDS)

See also my Writer's Bloc page for notes about various topics associated with the book. These were written as the book progressed, R scripts and Excel spreadsheets that are mentioned will also be in the support material.

News:

Look in the News section for details about important changes and tweaks to custom commands and so on. I continue to work on support material and will update things from time to time. This may include new custom commands (or changes to old ones) as well as support notes, additional data and exercises.

Community Ecology: Analytical Methods Using R and Excel

Available from:
Pelagic Publishing

Outline/TOC
Support Files

Custom R Commands
News

Sample chapter on Scribd



The Essential R Reference is available now. See it at Wiley or Amazon.co.uk.

See an outline and TOC here as well as example data used in the book

More about R

The R website

My Amazon author profile

Back to top

The Essential R Reference

by: Mark Gardener

An essential companion in your day-to-day conversations with R

R is a language with its own vocabulary and grammar. To make R work for you, you communicate with the computer using the language of R and tell it what to do. You accomplish this by typing commands directly into the program. This means that you need to know some of the words of the language and how to put them together to make a “sentence” that R understands. This book aims to help with this task by providing a “dictionary” of words that R understands.

The help system built into R is extensive, but it is arranged by command name; this makes it hard to use unless you know some command names to start with. That’s where this book comes in handy; the command names (the vocabulary of R) are arranged by topic, so you can look up the kind of task that you require and find the correct R command for your needs.

Each command listed in this book has an explanation of what the command does and how to use it—the “grammar,” if you will. Related commands are also listed, as in a thesaurus, so if the word you are looking at is not quite what you need, you are likely to see the correct one nearby. There are also examples of each command “in action” so you can gain a better understanding of how the command works.

I like to think of this book as a cross between a dictionary, a thesaurus, and a glossary, with a fair sprinkling of practical examples. Even though some may consider me an “R expert” at this point, I am still learning and still forgetting! I often have to refer to notes to remind me how to carry out a task in R. That is why I wrote this book—to help novice users learn more easily and to provide more experienced users with a reference work they can delve into time and time again. I also learned a great deal more about R by writing it, and I hope that you will find it an essential companion in your day-to-day conversations with R.

The Essential R Reference

Available from:
Wiley
Amazon.com
Amazon.co.uk

Outline/TOC
Data example file

Sample Chapter on Scribd



Beginning R is available from the publisher Wrox or see the entry on Amazon.co.uk.

See an outline and TOC here as well as example data used in the book

Instructor support materials (PowerPoints, Assessment Q&A) available here

More about R

The R website

My Amazon author profile

Back to top

Beginning R: The Statistical Programming Language

by: Mark Gardener

Conquer the complexities of this open source statistical language

R is fast becoming the de facto standard for statistical computing and analysis in science, business, engineering, and related fields. This book examines this complex language using simple statistical examples, showing how R operates in a user–friendly context. Both students and workers in fields that require extensive statistical analysis will find this book helpful as they learn to use R for simple summary statistics, hypothesis testing, creating graphs, regression, and much more. It covers formula notation, complex statistics, manipulating data and extracting components, and rudimentary programming.

  • R, the open source statistical language increasingly used to handle statistics and produces publication–quality graphs, is notoriously complex
  • This book makes R easier to understand through the use of simple statistical examples, teaching the necessary elements in the context in which R is actually used
  • Covers getting started with R and using it for simple summary statistics, hypothesis testing, and graphs
  • Shows how to use R for formula notation, complex statistics, manipulating data, extracting components, and regression
  • Provides beginning programming instruction for those who want to write their own scripts

Beginning R offers anyone who needs to perform statistical analysis the information necessary to use R with confidence.

Beginning R: The Statistical Programming Language

Available from:
Wiley
Wrox
Amazon.com
Amazon.co.uk

Outline/TOC
Data example file
Instructor Support

Sample Chapter on Scribd



This book has now been superceded by Edition 2.


Data example files for the publication are available here

For an outline/overview of the book see here

More about R

The R website

My Amazon author profile

Back to top

Statistics for Ecologists using R and Excel

Data Collection, Exploration, Analysis and Presentation

by: Mark Gardener

There is a new edition of this book available now from Pelagic Publishing.

This is a book about the scientific process and how you apply it to data in ecology. You 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 up to degree level.

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 results.

Statistics for Ecologists using R and Excel

Outline/TOC
Data example files

Sample Chapter on Scribd



Don't Panic III - an aid to teaching and learning basic statistics

Don't Panic III

A aid to teaching and learning basic statistics

Don't Panic III is a spreadsheet that is designed to help you learn or teach basic statistics.



Top DataAnalytics Home
Contact GardenersOwn Homepage