|
|
|
|
|
|
|
|
1. |
Record Nr. |
UNINA9910782762103321 |
|
|
Autore |
Verschuuren G. M. N (Geert M. N.) |
|
|
Titolo |
Excel for scientists [[electronic resource] /] / by Gerard M. Verschuuren |
|
|
|
|
|
Pubbl/distr/stampa |
|
|
Uniontown, Ohio, : Holy Macro Books, c2005 |
|
|
|
|
|
|
|
ISBN |
|
1-61547-313-0 |
1-932802-62-2 |
|
|
|
|
|
|
|
|
Descrizione fisica |
|
1 online resource (180 p.) |
|
|
|
|
|
|
Collana |
|
Excel for Professionals series |
|
|
|
|
|
|
Disciplina |
|
|
|
|
|
|
Soggetti |
|
Electronic spreadsheets |
Engineering - Data processing |
Science - Data processing |
|
|
|
|
|
|
|
|
Lingua di pubblicazione |
|
|
|
|
|
|
Formato |
Materiale a stampa |
|
|
|
|
|
Livello bibliografico |
Monografia |
|
|
|
|
|
Note generali |
|
"Designed by scientists for scientists." |
Includes index. |
|
|
|
|
|
|
|
|
Nota di contenuto |
|
Title Page; Copyright Page; Table of Contents; About the Author; Prologue; Chapter I: General Techniques; Making Copies and Trends; Understanding Relative versus Absolute; Telling Appearance from Reality; Managing Dates; Putting Functions Inside Functions; Chapter II: Statistical Analysis; Understanding Sampling Distributions; Estimating with Confidence; Testing with Significance; Chapter III: Plotting Graphs; Types of Charts; Manipulating Graphs; Adding an extra axis; Line Charts versus XY Charts; Using Error Bars; Using Histograms; Configuring Default Graphs; Putting Inserts in Graphs |
Adding Special EffectsWorking with Dynamic Ranges; Chapter IV: Regression Analysis; Mono-factorial and Linear; Curve Fitting; Multiple Regression; Chapter V: Complex Functions; Fancy Functions; Array Formulas; Homemade Functions; Solving Equations; Chapter VI: Data Analysis; Validation; Sorting Records; Creating Subtotals; Using Data Filters; Database Functions; Calculated Criteria; Marked Records; Appendix A: Answers to Exercises |
|
|
|
|
|
|
|
|
Sommario/riassunto |
|
For scientists and engineers tired of trying to learn Excel with examples from accounting, this self-paced tutorial is loaded with informative samples from the world of science and engineering. Techniques covered include creating a multifactorial or polynomial trendline, |
|
|
|
|