Excel for Scientists and Engineers.

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 wi...

Descripción completa

Detalles Bibliográficos
Clasificación:Libro Electrónico
Autor principal: Verschuuren, Dr. Gerard
Formato: Electrónico eBook
Idioma:Inglés
Publicado: Chicago : Holy Macro! Books, 2005.
Temas:
Microsoft Excel (Computer file)
Science > Data processing.
Engineering > Data processing.
Sciences > Informatique.
Ingénierie > Informatique.
COMPUTERS > Desktop Applications > Spreadsheets.
Engineering > Data processing
Science > Data processing
Acceso en línea:Texto completo
Tabla de Contenidos:
  • 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.

Ejemplares similares