Video Guides to Basic Data Analysis with Spreadsheets

Video Guides to basic Data Analysis with Spreadsheets

BAsic Statistics

The following concepts/skills are covered in the following video.

  1. Calculating mean, standard deviation, and standard error mean (SEM).
  2. Interpreting mean, standard deviation, and SEM statistics.

Working with Scatterplots

The following concepts/skills are covered in the following video.

  1. Creating a scatterplot.
  2. Adding constant error bars to a scatterplot.
  3. Applying a trendline (fit function) to a scatterplot.
  4. Displaying the fit equation and R2 value.

Advanecd Error BArs

The following concepts/skills are covered in the following video.

  1. Adding constant error bars
  2. Adding percentage error bars
  3. Adding custom error bars

Interpreting R2 Values

The following concepts are covered in the following video.

  1. Supports a hypothesized model
    • Sufficient data + high R2 for the hypothesized model function
  2. Refutes a hypothesized model
    • Sufficient data + low R2 for hypothesized model function
  3. Inconclusive
    • Insufficient/noisy data + high R2 for hypothesized model function
    • Insufficient/noisy data + low R2 for hypothesized model function
    • Similar R2 for hypothesized model function and one or more other functions with the same number of free parameters.

 

License

Icon for the Creative Commons Attribution-NonCommercial 4.0 International License

General Physics Remote Lab Manual Copyright © by Lawrence Davis is licensed under a Creative Commons Attribution-NonCommercial 4.0 International License, except where otherwise noted.

Share This Book