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.
- Calculating mean, standard deviation, and standard error mean (SEM).
- Interpreting mean, standard deviation, and SEM statistics.
Working with Scatterplots
The following concepts/skills are covered in the following video.
- Creating a scatterplot.
- Adding constant error bars to a scatterplot.
- Applying a trendline (fit function) to a scatterplot.
- Displaying the fit equation and R2 value.
Advanecd Error BArs
The following concepts/skills are covered in the following video.
- Adding constant error bars
- Adding percentage error bars
- Adding custom error bars
Interpreting R2 Values
The following concepts are covered in the following video.
- Supports a hypothesized model
- Sufficient data + high R2 for the hypothesized model function
- Refutes a hypothesized model
- Sufficient data + low R2 for hypothesized model function
- 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.
-