Ebooks

Excel 2007 for Scientists~tqw~ darksiderg

• 
• 
• Rate this torrent +  |  -

Torrent info

Torrent Files List

Torrent description

*******************************************************************************
Excel 2007 for Scientists
*******************************************************************************

-------------------------------------------------------------------------------
General Information
-------------------------------------------------------------------------------
Type.................: Ebook
Part Size............: 16,868,612 bytes




-------------------------------------------------------------------------------
Post Information
-------------------------------------------------------------------------------
Posted by............: ~tqw~

-------------------------------------------------------------------------------
Release Notes
-------------------------------------------------------------------------------
With examples from the world of science and engineering, this reference teaches
scientists how to create graphs, analyze statistics and regressions, and plot
and organize scientific data. Physicists and engineers can learn the tips and
techniques of Excel—and tailor them specifically to their experiments, designs,
and research. They will learn when to use NORMDIST vs NORMSDist and CONFIDENCE
vs Z, how to keep data-validation lists on a hidden worksheet, use pivot tables
to chart frequency distribution, generate random samples with various
characteristics, and much more. Ideal for students and professionals alike, this
handbook will enable greater productivity and efficiency.

Table Of Contents
About the Author ix
Introduction x
PART 1: General Techniques
Chapter 1 Navigation in Excel 2007 2
Chapter 2 The Fill Handle 6
Chapter 3 Relative Vs. Absolute Cell References 8
Chapter 4 Range Names 10
Chapter 5 Nested Functions 15
Excercises: Part-1
PART 2: Data Analysis
Chapter 6 Auto-numbering 24
Chapter 7 Subtotals 27
Chapter 8 Summary Functions 32
Chapter 9 Unique Lists 35
Chapter 10 Data Validation 38
Chapter 11 Conditional Formatting 41
Chapter 12 Filtering Tools 45
Chapter 13 Lookups 48
Chapter 14 Working with Trends 54
Chapter 15 Fixing Numbers 57
Chapter 16 Copying Formulas 62
Chapter 17 Multi-cell Arrays 64
Chapter 18 Single-cell Arrays 66
Chapter 19 Date Manipulation 70
Chapter 20 Time Manipulation 74
Excercises: Part-2 76
PART 3: Plotting Data
Chapter 21 Types of Graphs 84
Chapter 22 A Graph’s Data Source 92
Chapter 23 Combining Graph Types 96
Chapter 24 Changing Graph Locations 99
Chapter 25 Templates and Defaults 102
Chapter 26 Axis Scales 104
Chapter 27 More Axes 107
Chapter 28 Error Bars 110
Chapter 29 More Bars 113
Chapter 30 Line Markers 116
Chapter 31 Interpolation 119
Chapter 32 123
Graph Formulas
Excercises: Part-3 127
PART 4: Regression Analysis
Chapter 33 Linear Regression 138
Chapter 34 Nonlinear Regression 145
Chapter 35 Curve Fitting 151
Chapter 36 Sigmoid Curves 156
Chapter 37 Predictability 159
Chapter 38 Correlation 163
Chapter 39 Multiple Regression: Linear Estimates 167
Chapter 40 Reiterations and Matrixes 171
Chapter 41 Solving Equations 174
Chapter 42 What-If Controls 178
Chapter 43 Syntax of Functions 180
Chapter 44 Worksheet Functions 185
Excercises: Part-4 189
PART 5: Statistical Analysis
Chapter 45 Why Statistics? 198
Chapter 46 Types of Distributions 202
Chapter 47 Simulating Distributions 210
Chapter 48 Sampling Techniques 215
Chapter 49 Each Test Has Its Own Conditions 219
Chapter 50 Estimating Means 221
Chapter 51 Estimating Proportions 225
Chapter 52 Significant Means 228
Chapter 53 Significant Proportions 234
Chapter 54 Significant Frequencies 237
Chapter 55 More on the Chi-Squared Test 240
Chapter 56 Analysis of Variance242
Chapter 57 Power Curves 247
Excercises: Part-5 251
Index 259

Product Details

* ISBN: 1932802355
* ISBN-13: 9781932802351
* Format: Paperback, 262pp
* Publisher: Holy Macro! Books
* Pub. Date: June 2008
* Edition Number: 2

-------------------------------------------------------------------------------
Install Notes
-------------------------------------------------------------------------------
PDF Reader

related torrents