Subject:
Statistics and Probability
Material Type:
Module
Level:
Community College / Lower Division, College / Upper Division
Provider:
Ohio Open Ed Collaborative
Tags:
Spreadsheets, Statistics
License:
Creative Commons Attribution-NonCommercial 4.0
Language:
English
Media Formats:
Text/HTML

Excel and Google Spreadsheets

Module Overview

This module contains Excel and Google Spreadsheets for all statistical procedures used in an Intro Stats course. The spreadsheets are self-explanatory. Students insert data in the indicated areas. Spreadsheets are designed to automatically complete all calculations and show the results.

  • One Variable Statistics 
  • Frequency Distribution
  • Discrete Probability Distribution
  • Normal Distribution
  • Confidence Intervals
  • Test of Hypothesis
  • Linear Regression
  • Independence