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 R² 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 R² Values

The following concepts are covered in the following video.

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