The tutor covers the tdist() function, which seems to work the same on Excel and LibreOffice Calc. The tdist() function is in the statistics category of functions. Its entry scheme is =tdist(t-value, degrees_of_freedom, number_of_tails) Perhaps surprisingly, the t-value itself must …

Statistics: Spreadsheets: tdist() function Read more »

The tutor comments about why the t-distribution can be used for the matched-pairs test. The matched-pairs t-test is used to determine if two samples come from the same distribution. The data is collected in pairs, one to each sample, and …

Statistics: the matched-pairs t-test: justification of the use of the t-distribution Read more »