Triangle Test Calculator

Homebrew Talk - Beer, Wine, Mead, & Cider Brewing Discussion Forum

Help Support Homebrew Talk:

Silver_Is_Money

Larry Sayre, Developer of 'Mash Made Easy'
Joined
Dec 31, 2016
Messages
5,742
Reaction score
1,755
Location
N/E Ohio
A simple spreadsheet based calculator for those wishing to undertake their own Triangle Tests. Computes P-Value.

Download the calculator/spreadsheet at the "Google Drive" link seen below (by pressing the "down arrow" seen within the linked page, located next to the printer icon in the upper right hand corner) and then launch and run it within either Excel or LibreOffice Calc.


Note: Please let me know if this one works in Excel, or if I will need to modify it as was done for the "Golden Ratio" calculator.
 

marc1

Well-Known Member
Joined
Jun 19, 2010
Messages
727
Reaction score
398
Location
OH
Cool!
An interesting (but admittedly much more complex) component would be to incorporate statistical power into it so that you could say that if there was a difference, there would be x% chance of detecting it.
Defining the "size" of the difference detectable would be a big issue for it.
But it would cover the other side of the triangle test: with what confidence could you say that there is no difference between the samples.

Currently these calculations are done to "prove" with a certain statistical confidence that the samples are different. Not proving that they are different is not the same as proving that they are the same (that was a complicated statement o_O )
 
Top