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 Non-Commercial
    Language:
    English
    Media Formats:
    Text/HTML

    Excel and Google Spreadsheets

    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

    Section 1

    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