Statistical Methods for Test and Evaluation, Volume 5

Statistical Methods for Test and Evaluation, Volume 5

Experimental Designs using Excel

ByJeffrey Strickland

Usually printed in 3 - 5 business days
One of the obstacles to testing a classified system under test (SUT) is the limited availability of analysis software. However, we often overlook the one “constant” across various classified computing platform, Microsoft Excel (or similar spreadsheet app). Excel is “everywhere” and we underestimate its capability of performing advanced statistical modeling and analysis. I have used Excel extensively in the field of operations research, operational testing, and modeling and simulation. I authored a book on the mathematical modeling of combat and other military operations using Excel exclusively, from direct fire Lanchester equations to Kolmogorov differential equations for attrition. Others have authored books that use Excel for management science, statistical analysis, and operations research. In this book, I demonstrate Excel’s capability to implement experimental designs and analysis. I use combat system examples for testing with full factorial designs, randomized complete blocked designs (RCBD), Lartin Squares, ART ANOVA, sample size computation, regression, follow-up and post ANOVA tests, Dunnett’s ad hoc test, Kruskal-Wallis H test, Tukey HSD Test, and more. I present over 40 applied examples including orbital element analysis, (two-line element set), WD-40 experimental testing, O-ring pressure tolerance, radiation degradation, space debris, satellite control, and more.

Details

Publication Date
Jul 6, 2024
Language
English
ISBN
9781387905478
Category
Engineering
Copyright
Creative Commons NonCommercial, ShareAlike (CC BY-NC-SA)
Contributors
By (author): Jeffrey Strickland

Specifications

Pages
290
Binding Type
Hardcover Case Wrap
Interior Color
Color
Dimensions
US Trade (6 x 9 in / 152 x 229 mm)

Ratings & Reviews