NCSI Talks

   

Problematic Patterns In Random Noise


Shodor > NCSI Talks > Excel > Problematic Patterns In Random Noise

Problematic Paterns in Random Noise Model

What is this model?

This is system model that calculates a series of random numbers and plots them on a graph with a line of best fit. The y-coordinate of the regression line, also known as y-hat or ŷ, and the deviation from the observed value are also calculated and displayed on the spreadsheet. The model attempts to teach students the idea of error in any experiment and how to calculate how far detached the actual results are from hypothetical values. Students will learn how to interpret a residuals graph and apply these ideas to different experiments. In addition, they will learn when to use and when not to use a linear fit graph and how to infer from results whether linear regression was the right choice.

What can this Model be used to teach?

  • Learn how a regression works and what its purpose is
  • Understand the coefficient of determination and how it helps to tell how close a fit the linear model is for the data
  • Understand residuals and how they help to tell how close a fit the linear model is for the data
  • Related Models

    Histogram (Interactivate)

    Diffusion in a Box Model (NetLogo)