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 »

Tagged with: , , ,

The tutor shows an example of z vs t. From yesterday’s post, we have the following parameters: x: 14.4 sample standard deviation: 3.3 sample size: 25 We estimated the percent of the population between 10.2 and 12.9. Using the t-statistic …

Statistics: comparison between normal and t-distribution, df=24 Read more »

Tagged with:

The tutor continues about hypothesis testing and type II errors. In yesterday’s post I began about hypothesis testing, type I, and type II errors. Specifically, a type II error would be continuing to believe the mean loaf mass is 454g, …

Statistics: 1-β : type II error and the power of a test Read more »

Tagged with: , ,

The tutor explores the questions, from statistics, “What is a type I error? What is a type II error?”, with a couple of examples. In statistics, hypothesis testing is done when you think you know a value but want confirmation. …

Statistics: hypothesis testing: type I and type II errors Read more »

Tagged with: , ,

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 »

Tagged with: ,