Tutorial 2: How To Determine w
Below are some Excel workbooks that will aid you in the process of generating statistics for Panamath:
Creating a Gaussian function
An explanation of what a Gaussian or normal distribution is and how it can be calculated from generated Panamath data. This excel sheet provides two ways of plotting the Gaussian function by using the typical formula and by using the NORMDIST feature in Excel. The document also specifies how the Gaussians of idealized subjects change when they have differing Weber fractions.
Weber curve fitting
How to generate the Weber fraction and fit a curve model to the data generated. This worksheet also includes a form whereby you can enter your data and generate your own results. Before downloading this, please make sure you have the Analysis Toolpack in Excel activated. It is, by default, turned off. To turn it on, go to "Tools" and then "Add-ins." Then click on "Analysis ToolPak" and, for good measure, "Analysis ToolPak VBA." Close Excel and reopen the workbook. The formula should be operational and editable.
Varying p(GUESS) and the Weber fraction
An illustration of how varying p(GUESS) -- the probability of the user guessing because they missed the stimulus -- and the Weber fraction can affect the resulting ogival curve. The latter is also known as the "Percent Correct" curve, which increases linearly and smoothly to different extents depending on these two variables.