Have a personal or library account? Click to login
Excel 2013 for Scientists Cover

Excel 2013 for Scientists

Master advanced Excel techniques and data analysis tailored for scientific research and workflows

Publisher:Packt Publishing Limited
By: MrExcel's Holy Macro! Books and  Dr. Gerard Verschuuren  
Paid access
|Dec 2024
Product purchase options

Master data visualization, statistical tools, and regression analysis tailored for scientific research in Excel 2013. Discover tools to streamline experiments and improve productivity.

Key Features

  • Comprehensive guide to Excel 2013 tools tailored for scientific data analysis and modeling
  • Practical examples and exercises designed specifically for research and experimental workflows
  • Detailed coverage of statistical methods, regression techniques, and advanced graphing tools

Book Description

This book provides a detailed guide for scientists to fully utilize Excel 2013 for data analysis, visualization, and statistical modeling. It begins with core spreadsheet techniques like range names, nested functions, and cell referencing, creating a strong foundation for advanced skills. Tailored examples help readers understand how to apply these basics in scientific contexts.
The book progresses into advanced data analysis tools, covering pivot tables, lookups, conditional formatting, and filtering techniques. Regression methods, curve fitting, and distribution simulations are explored, allowing readers to analyze trends, predict outcomes, and validate data. Statistical methods such as ANOVA, significance testing, and sampling techniques are presented with practical examples to reinforce learning.
Later chapters focus on advanced graphing techniques, customizing charts, and working with complex functions like arrays and nonlinear regression. Exercises and step-by-step instructions ensure concepts are clear and practical. By the end, readers will confidently apply Excel tools to streamline experiments, enhance productivity, and achieve scientific precision.

What you will learn

  • Create tailored graphs and charts for scientific research needs
  • Analyze complex datasets with advanced Excel 2013 functions
  • Utilize pivot tables for efficient frequency distribution analysis
  • Generate random data samples for simulation and experiments
  • Differentiate key statistical functions for precise calculations
  • Automate data validation and formatting to enhance accuracy

Who this book is for

Students and professionals in science, engineering, and related fields seeking practical Excel skills will find this book helpful. Basic familiarity with Excel is recommended. No advanced programming or statistical background is required.

Table of Contents

  1. Navigation in Excel
  2. The Fill Handle
  3. Relative vs. Absolute Cell References
  4. Range Names
  5. Nested Functions
  6. Auto-numbering
  7. Subtotals
  8. Summary Functions
  9. Unique Lists
  10. Data Validation
  11. Conditional Formatting
  12. Filtering Tools
  13. Lookups
  14. Working with Trends
  15. Fixing Numbers
  16. Copying Formulas
  17. Multi-cell Arrays
  18. Single-cell Arrays
  19. Date Manipulation
  20. Time Manipulation
  21. Types of Charts and Graphs
  22. A Chart's or Graph's Data Source
  23. Combining Chart Types
  24. Changing Graph Locations
  25. Templates and Defaults
  26. Axis Scales
  27. More Axes
  28. Error Bars
  29. More Bars
  30. Line Markers
  31. Interpolation
  32. Graph Formulas
  33. Linear Regression
  34. Nonlinear Regression
  35. Curve Fitting
  36. Sigmoid Curves
  37. Predictability
  38. Correlation
  39. Multiple Regression: Linear Estimates
  40. Reiterations and Matrices
  41. Solving Equations
  42. What-If Controls
  43. Syntax of Functions
  44. Worksheet Functions
  45. Why Statistics?
  46. Types of Distributions
  47. Simulating Distributions
  48. Sampling Techniques
  49. Test Conditions and Outliers
  50. Estimating Means
  51. Estimating Proportions
  52. Significant Means
  53. Significant Proportions
  54. Significant Frequencies
  55. More on Chi-Squared Testing and Box-Cox Power
  56. Analysis of Variance
https://packt.link/26hEg
PDF ISBN: 978-1-83702-972-3
Publisher: Packt Publishing Limited
Copyright owner: © 2024 Packt Publishing Limited
Publication date: 2024
Language: English
Pages: 321
Related subjects:
Computer sciences,
Databases and data mining

People also read

Guerrilla Data Analysis Using Microsoft Excel
Book

Guerrilla Data Analysis Using Microsoft Excel

Books, MrExcel's Holy Macro!, Soleil, Oz du, Jelen, Bill
Don't Fear the Spreadsheet
Book

Don't Fear the Spreadsheet

Books, MrExcel's Holy Macro!, Jones, Kevin, Nash, Tyler, Urtis, Tom, Jelen, Bill
Excel Outside the Box
Book

Excel Outside the Box

Books, MrExcel's Holy Macro!, Umlas, Bob
Your Excel Survival Kit
Book

Your Excel Survival Kit

Books, MrExcel's Holy Macro!, Walsh, Anne
Data Analysis and Business Modeling with Excel 2013
Book

Data Analysis and Business Modeling with Excel 2013

Microsoft 365 Excel: The Only App That Matters
Book

Microsoft 365 Excel: The Only App That Matters

Books, MrExcel's Holy Macro!, Girvin, Mike
More Excel Outside the Box
Book

More Excel Outside the Box

Books, MrExcel's Holy Macro!, Umlas, Bob
100 Excel Simulations
Book

100 Excel Simulations

Books, MrExcel's Holy Macro!, Verschuuren, Dr. Gerard
Excel 2022 Pro 100 + PivotTables, Charts & Reports
Book

Excel 2022 Pro 100 + PivotTables, Charts & Reports

Gottlieb, Dr. Isaac
Excel Basics
Book

Excel Basics

Hsu, Jeffrey, Bronson, Gary