Introduction to Statistics Using OpenOffice Excel

When it comes to working with statistics, one common challenge that course alumni face is encountering default installations of spreadsheet software without additional statistical packages. Fortunately, this text does not rely on add-ins, add-ons, or separate dedicated statistical packages. Instead, it utilizes the built-in features of Gnumeric and Microsoft Excel (in particular, Calc) to perform statistical calculations.

In this text, we will explore various statistics concepts using Calc. We will examine how to apply statistical formulas and functions in OpenOffice's spreadsheet software, specifically Calc, which is similar to Microsoft Excel. Screen shots used throughout the text are primarily from Calc, with references to Microsoft Excel functions where they differ from Calc functions.

The following topics will be covered:

1. T-test for means for independent samples

2. Paired differences: Dependent samples

3. Confidence intervals for proportions

4. Confidence intervals for n ≥ 5 using sx

5. Introduction to confidence intervals for the mean

6. Inferences and confidence intervals for n ≥ 30 where σ is known

7. Central limit theorem and standard error

8. Introduction to the Normal Distribution

9. Mean and standard deviation from a distribution

10. Types of probabilities and distributions

11. Strength of the relationship: correlation

12. Differences in the Distribution of Data:

* Using OpenOffice or Excel to make charts

* Using the FREQUENCY function in a spreadsheet

By following this text, you will gain a comprehensive understanding of statistics using Calc, making it easy to apply these concepts in real-world scenarios. Whether you are working with large datasets or small samples, you will learn how to analyze and interpret data using OpenOffice's built-in statistical functions.

Open office excel