We're sorry! Resource content is currently unavailable.
This series of self-paced tutorials show how to analyze data using a spreadsheet program.
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.
- Spreadsheet Data Analysis Tutorials | HHMI BioInteractive
This introduction to spreadsheet programs describes the basic organization of a worksheet, how to organize and format your data, how to perform simple mathematical calculations, how to use built-in mathematical functions, and how to select and...
Generate a table with autofill, and use absolute cell reference to calculate variance and standard deviation.
Generate a column or bar graph with standard error bars.
Calculate t-values and perform t-tests using built-in functions.
Generate a histogram using a variety of methods.
- License terms
Cite this work
Researchers should cite this work as follows: