Managing Data Using Excel by Mark GardenerManaging Data Using Excel by Mark Gardener

Managing Data Using Excel

byMark Gardener

Paperback | April 9, 2015

Pricing and Purchase Info


Earn 275 plum® points

Prices and offers may vary in store


In stock online

Ships free on orders over $25

Not available in stores


Microsoft Excel is a powerful tool that can transform the way you use data. Thisbook 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 maximize 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 numericalerrors.* 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 andgraphs.Alongside the text, Have a Go exercises, Tips and Notes give readers practicalexperience and highlight important points, and helpful self-assessment exercises and summary tables can be found at the end of each chapter. Supplementary material can also be downloaded on the companion website.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.
Mark Gardener is an ecologist, lecturer and writer and has worked as a teacher and supervisor around the world. He runs courses in ecology, data analysis and R (a statistical programming language) for a variety of organizations.
Title:Managing Data Using ExcelFormat:PaperbackDimensions:556 pages, 9.39 × 6.17 × 0.71 inPublished:April 9, 2015Publisher:Pelagic PublishingLanguage:English

The following ISBNs are associated with this title:

ISBN - 10:1784270075

ISBN - 13:9781784270070

Look for similar items by category: