Vai al contenuto principale della pagina
Autore: |
Verschuuren G. M. N (Geert M. N.)
![]() |
Titolo: |
Excel for scientists [[electronic resource] /] / by Gerard M. Verschuuren
![]() |
Pubblicazione: | Uniontown, Ohio, : Holy Macro Books, c2005 |
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.< |
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.: | 9910782762103321 |
Lo trovi qui: | Univ. Federico II |
Opac: | Controlla la disponibilità qui |