Spreadsheet Data Analysis Tutorial Series
Author(s): HHMI BioInteractive
1942 total view(s), 349 download(s)
Summary:
This series of self-paced tutorials show how to analyze data using a spreadsheet program.
Contents:
- Spreadsheet Data Analysis Tutorials | HHMI BioInteractive
- Spreadsheet Tutorial 1 -- Formulae, Functions, and Averages | HHMI BioInteractive (v1.0)
- Spreadsheet Tutorial 2 - Autofill Data, Cell References, and Standard Deviation (v1.0)
- Spreadsheet Tutorial 3 - Column Graphs, Error Bars, and Standard Error of the Mean (v1.0)
- Spreadsheet Tutorial 4: t-Test (v1.0)
- Spreadsheet Tutorial 5: Histogram (v1.0)
- License terms
Description
These tutorials are designed to show essential data analysis techniques using a spreadsheet program such as Excel. Follow the tutorials in sequence to learn the fundamentals of using a spreadsheet program to organize data, use formulae and functions to calculate statistical values including mean, standard deviation, standard error of the mean, 95% confidence intervals, plot graphs with error bars, perform t-tests, and plot the data as histograms.
Cite this work
Researchers should cite this work as follows:
- HHMI BioInteractive (2018). Spreadsheet Data Analysis Tutorial Series. HHMI BioInteractive, QUBES Educational Resources. doi:10.25334/Q4ST0R