Dr. Mark Gardener
Dr. Christine Gardener

GO...
Gardeners Own Home
Education Home
About Us
*NEW* Managing Data Using Excel in print now

Publications and Support Notes

Here you can find some details about publications and any supplementary material associated with them.

Managing Data Using Excel | Community Ecology | Statistics for Ecologists
Beginning R | The Essential R Reference
Guide to common grasses


New: Statistics for Ecologists (Edition 2) Support Pages

Writer's Bloc – current project information

Current Projects

See my Writer's Bloc page for notes about my latest project, 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 will be published by Pelagic Publishing in due course. The original is still available via Pelagic Publishing.

New: Statistics for Ecologists (Edition 2) Support Pages

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

Managing Data Using Excel

Community Ecology: Analytical Methods Using R and Excel

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

See also my MonogRaphs page(s) for other topics related to R: The Statistical Programming Language.

Statistics for Ecologists Edition 2 Cover

Available soon

Support Index



Available Now

Use voucher code MDUE20 to get £5 off the paperback and £10 off the hardback when you buy direct from Pelagic Publishing

PPLogo

Outline and TOC here

Support material here (datasets, spreadsheets and chart templates)

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
(data, spreadsheets, chart templates)

 

PPLogo
Pelagic Publishing website

For an overview (outline and TOC) see here

Custom R commands used in the book: details here

Support files available here

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

Community Ecology Cover

Available from:
Pelagic Publishing

Outline/TOC
Support Files
Custom R Commands
News

Sample Chapter on Scribd

 

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.

PPLogo
Pelagic Publishing website

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

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

S4E cover

Available from:
Pelagic Publishing
Amazon.com
Amazon.co.uk

Outline/TOC
Data example files

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

Instructors materials (PowerPoints, Q&A etc.) 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

 

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

 

Get the grass ID guide here

FSCLogo
FSC publications site

Back to top

Guide to common grasses

by: Mark Gardener and Carol Roberts

Available from the Field Studies Council website HERE

Covering 30 species, this new fold-out chart should enable everyone to put a name to some of the most common species of grass found in Britain and Ireland. A special feature of this chart is a simple-to-use lateral key to enable users to make an accurate identification quickly.

With text by Mark Gardener and illustrations by Carol Roberts this guide uses the classic lateral key developed by Charles Sinker. The illustrations are split into several sections covering: Common meadow grasses, Woodland and riverbank grasses, Waste ground and roadside grasses.

The style of key allows the user to identify these common grasses even if all the characteristics are not available (if for example the plant is not in flower).

FSC 2010 OP136

Grass ID cover
 
More about data analysis and training courses at DataAnalytics

See also...

Learn to use R for statistical analyses: Index page

Tips, Tricks & Hints for R and Excel.


blogger counter
 


Top
Gardeners Own Home
Education Home
About Us