Managing Data Using Excel

Erscheinungsjahr 2015
ISBN: 978-1-78427-008-7
Verlag: Pelagic Publishing

Buch, Englisch, 326 Seiten, HC gerader Rücken kaschiert, Format (B × H): 161 mm x 240 mm, Gewicht: 655 g

Reihe: Research Skills

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

Autoren/Hrsg.

Gardener, Mark

Fachgebiete

• Mathematik | Informatik EDV | Informatik Programmierung | Softwareentwicklung Datenbankprogrammierung
• Mathematik | Informatik EDV | Informatik Daten / Datenbanken Automatische Datenerfassung, Datenanalyse
• Mathematik | Informatik EDV | Informatik Business Application Tabellenkalkulation Microsoft Excel
• Mathematik | Informatik EDV | Informatik Business Application Software für Projektmanagement
• Mathematik | Informatik EDV | Informatik EDV & Informatik Allgemein
• Interdisziplinäres Wissenschaften Wissenschaften: Forschung und Information Datenanalyse, Datenverarbeitung
• Mathematik | Informatik EDV | Informatik Daten / Datenbanken Data Warehouse

Inhaltsverzeichnis

1. Arranging your data

2. Managing your data: building your dataset

3. Managing your data: checking your dataset

4. Making sense of your data

5. Exploring regression data

6. Exploring time-related data

7. Exploring association data

8. Exploring differences data

9. Sharing your data

Appendices

Index

Über Autor(innen)

Gardener, Mark
Mark Gardener began his career as an optician but returned to science and trained as an ecologist. His research is in the area of pollination ecology. He has worked extensively in the UK as well as Australia and the United States. Currently he works as an associate lecturer for the Open University and also runs courses in data analysis for ecology and environmental science.

Mark Gardener (www.gardenersown.co.uk) is an ecologist, lecturer, and writer working in the UK. His primary area of research was in pollination ecology and he has worked in the UK and around the word (principally Australia and the United States). Since his doctorate he has worked in many areas of ecology, often as a teacher and supervisor. He believes that ecological data, especially community data, is the most complicated and ill-behaved and is consequently the most fun to work with. He was introduced to R by a like-minded pedant whilst working in Australia during his doctorate. Learning R was not only fun but opened up a new avenue, making the study of community ecology a whole lot easier. He is currently self-employed and runs courses in ecology, data analysis, and R for a variety of organizations. Mark lives in rural Devon with his wife Christine, a biochemist who consequently has little need of statistics.