Practical Spreadsheet Statistics And Curve Fitting For Scientists And Engineers

Introduction -- Lookup Tables -- Spreadsheet Templates -- Checking Distributions -- Descriptive Statistics -- Linear, Multiple, And Curvilinear Regression -- Macro Programming -- Fitting Nonlinear Data -- Interpolation -- Nonparametric Statistical Tests -- Analysis Of Variance (anova) -- Arithmetic, Relational, And Logical Operators -- Function Summary -- Macro Command Summary -- Critical Values For T-distribution -- Area Under The Normal (gaussian) Curve -- Critical Values Of The F-distribution -- Percentile Values For The Chi-square Distribution -- Cumulative Poisson Distribution -- Critical Values For The Sign Test -- Critical Values For The Run Test -- Critical Values For The Wilcoxon Signed-rank Test -- Critical Values For The Rank Sum Test -- Critical Values For The Kolmogorov-smirnov Goodness-of-fit Test. Louis M. Mezei. Includes Bibliographical References And Index.