 |
Probability and Statistics with OOo Calc
A work in progress
Gilberto E. Urroz - ph. 435-797-3379 - gurro@engineering.usu.edu - ENGR 223 - fax 435-797-1185
INTRODUCTION
OpenOffice.org (OOo)'s Calc is a spreadsheet application within the free, open-source office suite OpenOffice.org. OOo Calc includes a number of probability and statistical calculations useful for calculations in my Uncertainty in Engineering class (e.g., CEE 3030 Fall 2007). Therefore, I am in the process of developing a book teaching the use of OOo Calc's functions for probability and statistical calculations in engineering at an elementary level.
The links below allows you to download the chapters and spreadsheets for this book. The spreadsheet links for Chapters 1-4, provide zip files containing the OOo CALC and MS Excel versions of the worksheets. For Chapter 5, only two Excel versions of the spreadsheets are provided.
BOOK CHAPTERS
-
Ch2 - Probability distributions for discrete random variables - spreadsheet
-
Ch3 - Probability distributions for continuous random variables - spreadsheet
-
Ch4 - Applications of probability distributions - spreadsheet
-
Ch5 - Statistics of samples - spreadsheets updated for OpenOffice.org 3.0 (Nov. 2008)
-
More chapters upcoming - November 2008
REFERENCES