Howard Hughes Medical Institute
Spreadsheet Tutorial 2: Autofill Data, Cell References, and Standard Deviation
If you've always wanted to know more about spreadsheets, here's a perfect resource for you. A self-paced tutorial introduces how to autofill and copy formulas in a Google sheet or Excel spreadsheet. It also shows users how to find range,...
Howard Hughes Medical Institute
Spreadsheet Tutorial 4: t-Test
The t-test tutorial will fit your needs to a T. After calculating the mean, sum of squares, standard deviation, and variance of two data sets on a spreadsheet, scholars learn to calculate the t-values. They then learn to use the TTEST...
Howard Hughes Medical Institute
Spreadsheet Tutorial 3: Column Graphs, Error Bars, and Standard Error of the Mean
There's absolutely no error in using the tutorial! Learners use spreadsheets to create column or bar graphs with error bars. They also learn how to calculate the standard error of the mean in the tutorial. This is the third installment...
Howard Hughes Medical Institute
Spreadsheet Tutorial 1: Formulae, Functions, and Averages
Spread your knowledge of spreadsheets. The first of five tutorials in the Spreadsheet Data Analysis unit introduces the basics of spreadsheets. It shows future data analysts how to organize and format tables, and how to use functions to...