Excel Formulae for Sensation and Perception

Logarithms
 

=log(val,base)

Always use base = 10

Standard Deviation

=stdev(values)

or

=stdev.s(values)

Note: do not use in this case stdev.p - check with your stats professor.

95% Confidence Intervals

=1.96*Std_Dev/sqrt(number of values)

Note: Std_Dev uses the standard deviation equation listed above.

Linear Regression

Slope

=slope(yValues,xValues)