Calculations in Excel and by Hand
A blog post that walks through calculations of the mean, median, and mode by hand and using Excel.
A quick video going over the calculations of central tendency and the conceptual reasoning behind using each one.
A "How To" article outlining the hand calculation of Z-scores with a simple, thorough example.
A 2-minute video on calculating a Z-score when given the mean and standard deviation.
A 3-minute video on calculating Z-scores in Excel.
An 8-minute video of a by-hand demonstration of calculating a one-sample t-statistic.
A great article on one-sample t-test calculations in Excel, including helpful Excel functions.
A 10-minute video walking through an example of a dependent (paired) t-test calculation by hand.
A great Excel tutorial demonstrating how to calculate a paired-sample t-test. It also includes suggestions for how to report the results!
A 12-minute video walking through a fun example of an independent t-test calculation.
A quick walkthrough article going over Independent t-test calculations by hand (scroll halfway down the page to reach this), providing the relevant formulas.
A short 3-minute video calculating an independent t-statistic in Excel.
An article on calculating a Chi-square value in Excel (provides a video as well!).
A great website reviewing Chi-square calculations in Excel, including both Chi square test for goodness of fit and for independence of two variables.
A 7-minute video demonstrating a calculation of a Chi-square test of goodness of fit by hand.