High School

  • In this activity, students will perform a two-way ANOVA to determine if there is a difference in the amount of pressure (in Mpa) it takes to break two different types of laminated composites under wet or dry conditions. Questions about the exercise and links to Excel and TI-83 instructions are given. The data exist in Excel, TI-83, and text formats.
    0
    No votes yet
  • In this activity, students will perform a t-test to determine if there is a significant difference between the kicking distances of a football filled with helium and one filled with regular air. Questions about the exercise and links to Excel and TI-83 instructions are given. The data exist in Excel, TI-83, and text formats.
    0
    No votes yet
  • In this activity, students will calculate the correlation between the ratio of doctors to people and the average lifespan for 40 countries. The dataset contains the name of the country, the number of citizens per doctor, and the average female lifespan (in years). Questions about the exercise and a link to Excel instructions are given. The data exist in Excel data format and text format.
    0
    No votes yet
  • In this activity, students will perform a chi-squared test on the number of people with health insurance by age to determine whether there is a relationship between age and insurance coverage. Questions about the exercise and a link to the DIG Stats Online Chi-Squared Calculator are given. The data exist in Excel and text formats.
    0
    No votes yet
  • In this activity, students will calculate the correlation between college enrollment at University of New Mexico and unemployment data in the state of New Mexico. They will also generate a scatterplot of the data. Questions about the exercise and links to Excel and TI-83 instructions are given. The data exist in Excel, TI-83, and text formats.
    0
    No votes yet
  • In this activity, students will perform a one sample t-test to see if the pH level of rain collected by the EPA is less than the pH standard for acid rain (5.6). Questions about the exercise and links to a t-test applet and TI-83 instructions are given. The data exist in Excel, TI-83, and text formats.
    0
    No votes yet
  • In this activity, students will perform a two-way ANOVA on a dataset containing rainfall amounts for seeded and unseeded clouds in each of the 4 seasons. Questions about the exercise are given as well as a link to Excel instructions. The data exist in Excel and text formats.
    0
    No votes yet
  • In this activity, students will calculate the correlation and generate a scatterplot of the number of passengers flying and the number of performed departures from 135 airports in the US. Questions about the exercise and links to Excel and TI-83 instructions are given. The data exist in Excel, TI-83, and text formats.
    0
    No votes yet
  • In this activity, students will generate scatterplots and use regression and logarithms to explore a dataset with time and temperature data for an insulation pack. Questions about the exercise are given at the bottom of the page as well as links to instructions for Excel and the TI-83 calculator. The data exists in TI-83 group, Excel, and text formats.
    0
    No votes yet
  • This tutorial explains in detail how to perform an ANOVA in Excel.
    0
    No votes yet

Pages