Tutorial 2: How To Determine w

From Panamath

Revision as of 07:46, 28 November 2010 by Panamath (Talk | contribs)
Jump to: navigation, search

Below are some Excel workbooks that will aid you in the process of generating statistics for Panamath:

Contents

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.

See also

Personal tools