One sample t-test in Excel
Recently I needed to quickly perform a one sample t-test in an Excel spreadsheet. Unfortunately, this functionality is not implemented in Excel by default. However, I found a very nice post by Zach at Statology on how to calculate this test using some build-in Excel functions and objects.
For my convenience what I did was to put the whole procedure in a single cell:
Below I attach Excel file that is complementary to the example used by Zach:
Source of the cover picture: https://www.potterybarn.com/products/oversized-abacus/