Coverart for item
The Resource Managing data using Excel : organizing, summarizing and visualizing scientific data, Mark Gardener

Managing data using Excel : organizing, summarizing and visualizing scientific data, Mark Gardener

Label
Managing data using Excel : organizing, summarizing and visualizing scientific data
Title
Managing data using Excel
Title remainder
organizing, summarizing and visualizing scientific data
Statement of responsibility
Mark Gardener
Creator
Author
Subject
Language
eng
Summary
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
Member of
Cataloging source
EBLCP
http://library.link/vocab/creatorName
Gardener, Mark
Dewey number
005.54
Index
no index present
LC call number
HF5548.4.M523 .G384 2015
Literary form
non fiction
Nature of contents
dictionaries
Series statement
Research skills series
http://library.link/vocab/subjectName
  • Electronic spreadsheets
  • Science
  • Excel
  • COMPUTERS
  • Electronic spreadsheets
  • Science
  • Forschung
  • Tabellenkalkulation
  • Datenmanagement
Label
Managing data using Excel : organizing, summarizing and visualizing scientific data, Mark Gardener
Instantiates
Publication
Note
9.1.1 Sharing your entire dataset
Antecedent source
unknown
Carrier category
online resource
Carrier category code
cr
Carrier MARC source
rdacarrier
Color
multicolored
Content category
text
Content type code
txt
Content type MARC source
rdacontent
Contents
  • ABOUT THE AUTHOR; ACKNOWLEDGEMENTS; INTRODUCTION; WHO THIS BOOK IS FOR; WHAT YOU WILL LEARN IN THIS BOOK; HOW THIS BOOK IS ARRANGED; HOW TO READ THIS BOOK; SOFTWARE USED; SUPPORT FILES; PART 1 Arranging and managing your data; 1 ARRANGING YOUR DATA; 1.1 SYSTEMS FOR DATA LAYOUT; 1.1.1 Common ways to lay out data; 1.1.2 A standard layout for data; 1.2 RECORDING FORMAT; 1.3 TURNING YOUR DATA INTO A DATABASE; 1.4 PLANNING YOUR DATA LAYOUT; 1.4.1 Index variables; 1.4.2 Using dates; 1.5 USING RECORDING SHEETS AND NOTEBOOKS; 1.5.1 Data from equipment; 1.5.2 Data in notebooks
  • 1.5.3 Data in recording sheets1.6 SAVING YOUR DATA; 1.7 EXERCISES; 1.8 SUMMARY; 2 MANAGING YOUR DATA: BUILDING YOUR DATASET; 2.1 ADDING TO YOUR DATASET; 2.1.1 Adding new variables; 2.1.2 Adding notes to your data; 2.2 EDITING YOUR DATA; 2.2.1 Find and replace; 2.2.2 Sorting data; 2.2.3 Filtering data; 2.3 REARRANGING YOUR DATA; 2.3.1 Rearranging data by row; 2.3.2 Rearranging data by column; 2.4 EXERCISES; 2.5 SUMMARY; 3 MANAGING YOUR DATA: CHECKING YOUR DATASET; 3.1 TYPOGRAPHICAL ERRORS; 3.1.1 Sort tools in error checking; 3.1.2 Pivot tables in error checking
  • 3.1.3 Filter tools in error checking3.2 VALIDATING ENTRIES; 3.2.1 Validation during entry; 3.2.2 Validation after data entry; 3.3 NUMERICAL ERRORS; 3.3.1 Errors in sample data; 3.3.2 Errors in correlation data; 3.4 EXERCISES; 3.5 SUMMARY; PART 2 Using your dataset -- summarizing, visualizing andsharing your data; 4 MAKING SENSE OF YOUR DATA; 4.1 TYPES OF DATASET; 4.1.1 Correlation and regression datasets; 4.1.2 Association datasets; 4.1.3 Differences datasets; 4.2 WAYS TO SUMMARIZE YOUR DATA; 4.2.1 Averages; 4.2.2 Variability; 4.2.3 Replication; 4.2.4 Data distribution
  • 4.2.5 Using the Analysis ToolPak4.3 WAYS TO VISUALIZE YOUR DATA; 4.3.1 Types of graph; 4.3.2 Pivot charts; 4.3.3 Sparklines; 4.4 EXERCISES; 4.5 SUMMARY; 5 EXPLORING REGRESSION DATA; 5.1 FINDING CORRELATIONS IN YOUR DATASET; 5.1.1 Correlation matrices using all-numeric data; 5.1.2 Correlation matrices using grouping variables; 5.1.3 Highlighting correlations; 5.2 VISUALIZING THE CORRELATIONS; 5.2.1 Sparklines; 5.2.2 Scatter plots; 5.2.3 Checking assumptions of normality; 5.3 EXERCISES; 5.4 SUMMARY; 6 EXPLORING TIME-RELATED DATA; 6.1 SUMMARIZING TIME-RELATED DATA; 6.1.1 Using pivot tables
  • 6.2 VISUALIZING TIME-RELATED DATA6.2.1 Sparklines; 6.2.2 Line plots; 6.3 EXERCISES; 6.4 SUMMARY; 7 EXPLORING ASSOCIATION DATA; 7.1 CONTINGENCY TABLES FROM YOUR DATA; 7.2 VISUALIZING YOUR CONTINGENCY TABLES; 7.2.1 Column and bar charts; 7.2.2 Pie charts; 7.3 EXERCISES; 7.4 SUMMARY; 8 EXPLORING DIFFERENCES DATA; 8.1 SUMMARIZING DIFFERENCES DATA; 8.1.1 Using pivot tables; 8.1.2 Using the Analysis ToolPak; 8.2 VISUALIZING DIFFERENCES DATA; 8.2.1 Sparklines; 8.2.2 Histograms; 8.2.3 Bar charts; 8.2.4 Box-and-whisker plots; 8.3 EXERCISES; 8.4 SUMMARY; 9 SHARING YOUR DATA; 9.1 EXPORTING YOUR DATA
Control code
908515071
Dimensions
unknown
Extent
1 online resource (327 pages).
File format
unknown
Form of item
online
Isbn
9781784270094
Level of compression
unknown
Media category
computer
Media MARC source
rdamedia
Media type code
c
http://library.link/vocab/ext/overdrive/overdriveId
  • 0774dcbf-fe74-48fe-abb5-aa06d5ad0e4c
  • 74c4bf3b-0200-46d8-b74c-ab805da7bc97
Quality assurance targets
not applicable
Reformatting quality
unknown
Sound
unknown sound
Specific material designation
remote
System control number
(OCoLC)908515071
Label
Managing data using Excel : organizing, summarizing and visualizing scientific data, Mark Gardener
Publication
Note
9.1.1 Sharing your entire dataset
Antecedent source
unknown
Carrier category
online resource
Carrier category code
cr
Carrier MARC source
rdacarrier
Color
multicolored
Content category
text
Content type code
txt
Content type MARC source
rdacontent
Contents
  • ABOUT THE AUTHOR; ACKNOWLEDGEMENTS; INTRODUCTION; WHO THIS BOOK IS FOR; WHAT YOU WILL LEARN IN THIS BOOK; HOW THIS BOOK IS ARRANGED; HOW TO READ THIS BOOK; SOFTWARE USED; SUPPORT FILES; PART 1 Arranging and managing your data; 1 ARRANGING YOUR DATA; 1.1 SYSTEMS FOR DATA LAYOUT; 1.1.1 Common ways to lay out data; 1.1.2 A standard layout for data; 1.2 RECORDING FORMAT; 1.3 TURNING YOUR DATA INTO A DATABASE; 1.4 PLANNING YOUR DATA LAYOUT; 1.4.1 Index variables; 1.4.2 Using dates; 1.5 USING RECORDING SHEETS AND NOTEBOOKS; 1.5.1 Data from equipment; 1.5.2 Data in notebooks
  • 1.5.3 Data in recording sheets1.6 SAVING YOUR DATA; 1.7 EXERCISES; 1.8 SUMMARY; 2 MANAGING YOUR DATA: BUILDING YOUR DATASET; 2.1 ADDING TO YOUR DATASET; 2.1.1 Adding new variables; 2.1.2 Adding notes to your data; 2.2 EDITING YOUR DATA; 2.2.1 Find and replace; 2.2.2 Sorting data; 2.2.3 Filtering data; 2.3 REARRANGING YOUR DATA; 2.3.1 Rearranging data by row; 2.3.2 Rearranging data by column; 2.4 EXERCISES; 2.5 SUMMARY; 3 MANAGING YOUR DATA: CHECKING YOUR DATASET; 3.1 TYPOGRAPHICAL ERRORS; 3.1.1 Sort tools in error checking; 3.1.2 Pivot tables in error checking
  • 3.1.3 Filter tools in error checking3.2 VALIDATING ENTRIES; 3.2.1 Validation during entry; 3.2.2 Validation after data entry; 3.3 NUMERICAL ERRORS; 3.3.1 Errors in sample data; 3.3.2 Errors in correlation data; 3.4 EXERCISES; 3.5 SUMMARY; PART 2 Using your dataset -- summarizing, visualizing andsharing your data; 4 MAKING SENSE OF YOUR DATA; 4.1 TYPES OF DATASET; 4.1.1 Correlation and regression datasets; 4.1.2 Association datasets; 4.1.3 Differences datasets; 4.2 WAYS TO SUMMARIZE YOUR DATA; 4.2.1 Averages; 4.2.2 Variability; 4.2.3 Replication; 4.2.4 Data distribution
  • 4.2.5 Using the Analysis ToolPak4.3 WAYS TO VISUALIZE YOUR DATA; 4.3.1 Types of graph; 4.3.2 Pivot charts; 4.3.3 Sparklines; 4.4 EXERCISES; 4.5 SUMMARY; 5 EXPLORING REGRESSION DATA; 5.1 FINDING CORRELATIONS IN YOUR DATASET; 5.1.1 Correlation matrices using all-numeric data; 5.1.2 Correlation matrices using grouping variables; 5.1.3 Highlighting correlations; 5.2 VISUALIZING THE CORRELATIONS; 5.2.1 Sparklines; 5.2.2 Scatter plots; 5.2.3 Checking assumptions of normality; 5.3 EXERCISES; 5.4 SUMMARY; 6 EXPLORING TIME-RELATED DATA; 6.1 SUMMARIZING TIME-RELATED DATA; 6.1.1 Using pivot tables
  • 6.2 VISUALIZING TIME-RELATED DATA6.2.1 Sparklines; 6.2.2 Line plots; 6.3 EXERCISES; 6.4 SUMMARY; 7 EXPLORING ASSOCIATION DATA; 7.1 CONTINGENCY TABLES FROM YOUR DATA; 7.2 VISUALIZING YOUR CONTINGENCY TABLES; 7.2.1 Column and bar charts; 7.2.2 Pie charts; 7.3 EXERCISES; 7.4 SUMMARY; 8 EXPLORING DIFFERENCES DATA; 8.1 SUMMARIZING DIFFERENCES DATA; 8.1.1 Using pivot tables; 8.1.2 Using the Analysis ToolPak; 8.2 VISUALIZING DIFFERENCES DATA; 8.2.1 Sparklines; 8.2.2 Histograms; 8.2.3 Bar charts; 8.2.4 Box-and-whisker plots; 8.3 EXERCISES; 8.4 SUMMARY; 9 SHARING YOUR DATA; 9.1 EXPORTING YOUR DATA
Control code
908515071
Dimensions
unknown
Extent
1 online resource (327 pages).
File format
unknown
Form of item
online
Isbn
9781784270094
Level of compression
unknown
Media category
computer
Media MARC source
rdamedia
Media type code
c
http://library.link/vocab/ext/overdrive/overdriveId
  • 0774dcbf-fe74-48fe-abb5-aa06d5ad0e4c
  • 74c4bf3b-0200-46d8-b74c-ab805da7bc97
Quality assurance targets
not applicable
Reformatting quality
unknown
Sound
unknown sound
Specific material designation
remote
System control number
(OCoLC)908515071

Library Locations

    • Ellis LibraryBorrow it
      1020 Lowry Street, Columbia, MO, 65201, US
      38.944491 -92.326012
Processing Feedback ...