worksheet function 'NORMSINV' in MS Access

S

Stephen

Hi all.

I have the follwing caculated field;
sigma: NORMSINV(([errors])-([all])/1000000)+1.5

In Access this provide the following error message
Undefined function 'NORMSINV' in expression.

This does work in excell and advises is a worksheet
function.

Why is this not in access and how can I overcome this
problem?

------- Taken from MS Help --------------------------------
NORMSINV
Returns the inverse of the standard normal cumulative
distribution (has a mean of 0 [zero] and a standard
deviation of 1).

If this function returns the #NAME? error value, you may
need to install msowcf.dll.

Syntax

NORMSINV(probability)

Probability is a probability that corresponds to the
normal distribution, a number between 0 and 1 inclusive.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sigma Calculation in Access 3
IS there a mathematical formula for NORMSINV? 1
Attempting to create a function that i can use in a query. 1
What does Excel's RAND function really do 4
[Statistical functions] Function to return result from Z table? 4
t-distribution puzzle in Excel 8
undefined function 'xxx' in expression - user function 2
0 Decimal places/round function. 4

Top