Physical Sciences and Mathematics Commons^™

Lab Exercises For Statistics Using Excel, Julia Nebia, Steven Cosares, Milena Cuellar

Open Educational Resources

This document contains the text associated with a series of computer-based lab exercises to help students apply the concepts usually included in a first course in Statistics. A compressed file has been included that contains a separate folder for each lab. In each folder is an excel spreadsheet file and an editable word document providing the instructions for students to complete the exercise. The exercises are not numbered in the folders, so you can select any subset of these exercises to assign to your students. You are free to modify the instructions in any way you see fit, e.g., to …

Species In Vernal Pools: Anova, Lisa Manne

Open Educational Resources

A one-way analysis of variance exercise using data on species diversities from vernal pools.Data are from vernal pools in Willowbrook Park (adjacent to College of Staten Island's campus) in spring.

The typical ANOVA gives a straightforward result (significant anova, easily-interpreted Tukey-Kramer analysis). This data set requires more nuanced interpretation, as the ANOVA is marginally significant, and Tukey-Kramer yields one significant pairwise comparison between groups. Relative lack of variation within groups explains this apparent enigma.

Quan 201: Quantitative Reasoning And Society, Cuny School Of Professional Studies

Open Educational Resources

An interdisciplinary introduction to the ways in which data can be used to enhance thinking and decision-making capacities, including using simple statistical techniques, creating visual representations of quantitative data, deriving accurate conclusions from quantitative data, and using data effectively in analyses and arguments. Assignments build capacity to evaluate and write clearly about quantitative evidence using methods for analyzing and communicating about data that do not require complex mathematics.

Math 215: Introduction To Statistics, Cuny School Of Professional Studies

Open Educational Resources

Introduces the basic principles of statistics and probability, with an emphasis on understanding the underlying concepts, real-world applications, and the underlying story that the numbers tell. Uses Microsoft Excel’s statistical functions to analyze data. Provides an introduction to probability, descriptive statistics, hypothesis testing, and inferential statistics.