# Tutorial 2: How To Determine w

### From Panamath

(→See also) |
(add workbook link) |
||

Line 1: | Line 1: | ||

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

+ | |||

+ | [http://panamath.org/tutorials/panamath_weber_curve_fitting.xls Weber curve fitting workbook (.xls)] | ||

== Creating a Gaussian function == | == Creating a Gaussian function == |

## Latest revision as of 14:35, 21 May 2013

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

Weber curve fitting workbook (.xls)

## 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.