Triangle Test Calculator

[Silver_Is_Money]

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.

https://drive.google.com/file/d/19zMR8Mkagb5MsDCkzkdtNn2NJgiHslL2/view?usp=sharing
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.

 

[MaxStout]

I downloaded the new one, works fine in Excel 2013. Thanks for fixing!

 

[Silver_Is_Money]

I downloaded the new one, works fine in Excel 2013. Thanks for fixing!

OK, but it wasn't broken before.... Not fixed, just filtered through Google Sheets.

 

[marc1]

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 )

 

[MaxStout]

OK, but it wasn't broken before.... Not fixed, just filtered through Google Sheets.

Dammit...posted in wrong thread. Meant to post in the golden ratio calc thread.