Excel for scientists / / by Gerard M. Verschuuren
(Visualizza in formato marc)
(Visualizza in BIBFRAME)
| Autore: |
Verschuuren G. M. N (Geert M. N.)
|
| Titolo: |
Excel for scientists / / by Gerard M. Verschuuren
|
| Pubblicazione: | Uniontown, Ohio, : Holy Macro Books, c2005 |
| Edizione: | 1st ed. |
| Descrizione fisica: | 1 online resource (180 p.) |
| Disciplina: | 005.36 |
| Soggetto topico: | Electronic spreadsheets |
| Engineering - Data processing | |
| Science - Data processing | |
| 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, generating random samples with various characteristics, and tips on when to use PEARSON instead of CORREL. Other science- and engineering-related Excel features such as making columns touch each other for a histogram, unlinking a chart from its data, and pivoting tables to create frequency distributions are also covered.< |
| Altri titoli varianti: | Excel for scientists & engineers |
| Excel for scientists and engineers | |
| Titolo autorizzato: | Excel for scientists |
| ISBN: | 1-61547-313-0 |
| 1-932802-62-2 | |
| Formato: | Materiale a stampa  |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione: | Inglese |
| Record Nr.: | 9910815944703321 |
| Lo trovi qui: | Univ. Federico II |
| Opac: | Controlla la disponibilità qui |
Serie:
Excel for Professionals series