Environmental Data Analysis EESC BC 3017

---

Textbook:

Berk K.N. and Carey, P. (2010) Data Analysis with Microsoft Excel™: Updated for Office 2007 (Paperback) Brooks/Cole, Boson, MA  596pp.
ISBN 0495391786
 

• purchase strongly suggested
  
• reading will be assigned every week
• Amazon web site
• publishers website
• Statplus download website

• download the Statplus zip file from the website to a USB drive.
  
• rightclick on the downloaded file and'extract all', go through the various screens of the wizzard popping up
•  don't move the unzipped files on teh USB drive 
• Open Excel and add the addin as is on the USB drive (go to Excel options/Add-ins/Manage Excel Add-ins)
  
• Use statplus
• when you are done, unclick the Statplus Version 3.0 box under Excel options/Add-ins/Manage Excel Add-ins
• this shoudl work!
  

	Table of Contents
Part I: EXCEL. 1. Getting Started with Excel. (1-37) The Windows Operating System. Special Files for this Book. Excel and Spreadsheets. Excel Workbooks and Worksheets. Worksheet Cells. Printing from Excel. Saving Your Work. Excel Add-Ins. Features of Statplus. Exiting Excel. 2. Working with Data.  (38-77) Data entry. Data Formats. Formulas and Functions. Cell references. Range Names. Sorting Data. Querying Data. Importing Data from Text Files. Importing Data from Databases. Exercises. 3. Working with Charts.  (78-114) Working with Excel Charts. Introducing Scatterplots. Creating Charts with the Chart Wizard. Editing a Chart. Identifying Data Points. Creating Bubble Plots. Breaking a Scatterplot into Categories. Plotting Several Variables. Exercises. Part II: FUNDAMENTALS OF STATISTICS. 4. Describing Your Data.  (115-167) Variables and Descriptive Statistics. Looking at Distributions with Frequency Tables. Working with Histograms. Working with Stem and Leaf Plots. Distribution Statistics. Working with Boxplots. Exercises. 5. Probability Distributions.  (168-207) Probability. Probability Distributions. Random Variables and Random Samples. The Normal Distribution. Parameters and Estimators. The Sampling Distribution. The Central Limit Theorem. Exercises. 6. Statistical Inference.  (208-256) Confidence Intervals. Hypothesis Testing. The t-Distribution. Applying the t-Test to Paired Data. Applying a Non-parametric Test to Paired Data. The Two-Sample t-Test. Applying the t-Test to Two-Sample Data. Applying a Nonparametric Test to Two-Sample Data. Final Thoughts about Statistical Inference. Exercises. 7. Tables.  (257-292) Pivot tables. Two-Way Tables. Computing Expected Counts. The Pearson Chi-Square Statistic. Other Table Statistics. Validity of the Chi-Square Test with Small Frequencies. Tables with Ordinal Variables. Exercises. Part III: STATISTICAL METHODS. 8. Regression and Correlation.  (293-331) Simple Linear Regression. Regression Functions in Excel. Performing a Regression on Analysis. Checking the Regression Model. Correlation. Creating a Correlation Matrix. Creating a Scatterplot Matrix. Exercises. 9. Multiple Regression.  (332-367) Regression Models with Multiple Parameters. Regression Example: Predicting Grades. Testing Regression Assumptions. Plotting Residuals s. Predicted Values. Regression Example: Sex Discrimination. Exercises. 10. Analysis of Variance. (368-406) One-Way Analysis of Variance. Analysis of Variance Example: Comparing Hotel Prices. Comparing Means. Using the Bonferroni Correction Factor. When to Use Bonferroni. One-Way Analysis of Variance and Regression. Two-Way Analysis of Variance. A Two-Factor Example. Two-Way Analysis Example: Comparing Soft Drinks. Exercises. 11. Time Series.  (407-466) Time Series Concepts. Time Series Example: The Dow in the 1980s. The Autocorrelation Function. Moving Averages. Simple Exponential Smoothing. Two-Parameter Exponential Smoothing. Seasonality. Seasonal Example: Beer Production. Three-Parameter Exponential. Smoothing. Optimizing the Exponential. Smoothing Constant (optional). Exercises. 12. Quality Control. (467-499) Statistical Quality Control. Control Charts. The Chi [overbar] Chart. The Range Chart. The C-Chart. The P-Chart. Control Charts for Individual Observations. The Pareto Chart. Exercises. Appendix. Excel Reference. Bibliography. Index.