The inverse error function (erfinv)

H

I need to use the inverse error function

erf(x)=0.8  <=>  x=inverf(0.8)   <=>   x=0,90469

Currently i am using the goal seeker, but i know that matlab has a erfinv function - does excell have one? if not - does anybody know about som java-coding that can do it

Best regard

morten
0
mgs8696 (1)
4/1/2004 1:26:17 PM
excel.misc 78881 articles. 5 followers. Follow

3 Replies
22005 Views

Similar Articles

[PageSpeed] 30

inverf(p) = SQRT(GAMMAINV(p,0.5,1))
inverfc(p) = -NormSInv(p/2)/Sqrt(2)

Mathemetically exact, but not necessarily numerically good in versions 
prior to 2003.

Jerry

Morten wrote:

> Hi
> 
> I need to use the inverse error function:
> 
> erf(x)=0.8  <=>  x=inverf(0.8)   <=>   x=0,904696
> 
> Currently i am using the goal seeker, but i know that matlab has a erfinv function - does excell have one? if not - does anybody know about som java-coding that can do it?
> 
> Best regards
> 
> morten

0
post_a_reply (1395)
4/2/2004 2:39:33 AM
Thats works perfect... Thank you for solving my problem

Best regard

Morten, Denmark
0
anonymous (74722)
4/2/2004 8:26:03 AM
Glad it helped

Jerry

Morten wrote:

> Thats works perfect... Thank you for solving my problem.
> 
> Best regards
> 
> Morten, Denmark

0
post_a_reply (1395)
4/2/2004 1:15:59 PM
Reply:

Similar Artilces:

Slow responce of cash drawer OR printer error
Hi every one. Some time the cash drawer response is very slow. Sometimes the cash drawer opens, but the receipt doesn't print. The computer searches for a while and then at the end it displays an error message. I have TM88IV & APG Cash Drawer, using OPOS driver, using Microsoft RMS 2.0 with Windows Vista. if any body have some idea please help me Thanks in advance I have the same experience but with a SureMark 4610 - TF6 Any ideas? Kyle "Akbar Mian" <AkbarMian@discussions.microsoft.com> wrote in message news:22EF9D16-A753-4FEF-A199-A232F571EFFD@microsoft...

Testing a range of cells in an IF FUNCTION
Trying to test a range of cells in an IF Function. I would like the function to look at 15 cells in a single row, find a value within those cells, and then return another value if TRUE/FALSE. As of now, I can only apply the "logical test" in the IF formula for ONE CELL ONLY. I would like it to test a RANGE of cells in one row, find if any of the values match my logical test, and then return a value. Anyone understand or know how to do this? I tried apply "lookup" function, but I don't think it will work Please help Aaro aaronplange at hotmail.com Hi maybe someth...

Foreground locking error running scheduled integration
I have a scheduled integration setup that first runs the login to GP, then an integration group (2 AR integrations). I have them set at 5 minutes apart. The TK article for this particular error says that the error is because "Great Plains is still in the process of launching when the Integration Manager starts running." I then increased the time to 15 minutes apart and finally at 30 minutes apart, but the first record of both integrations still fails with this error "could not set foreground locking value to 0." How can I get rid of this error? It only takes les...

Error 1100009
After pushing out SP2, I've got about 700 Vista machines that are throwing an error "Publisher cannot open the file." when trying to open Publisher documents. Ctrl+Shift+I gives error 1100009 Any solutions other than removing Office and reinstalling without SP2 on 700 PCs? Patrick S wrote: > After pushing out SP2, I've got about 700 Vista machines that are throwing an > error "Publisher cannot open the file." when trying to open Publisher > documents. Ctrl+Shift+I gives error 1100009 > > Any solutions other than removing Office and reinsta...

OWA 302 error for inbox
I have two 2003 (sp2) front-end servers that are in DMZ. We have had this problem even before installing sp2. We use Network Load Balancing. After login, during OWA tries to display Inbox, I get login screen on right pane, prompting me to enter user id and pwd. In IIS Logs I see 302 error in logs when accessing frontend-02 (please see below the comparision between frontend-01 and 02 ; frontend-01 is working server). Secondly, I notice in the logs, on frontend-02, under cs-username field, there is '-', whereas on 01 server i see the username, henry. Any reason wy? To view prop...

Exchange OMA error message. Please read...
When our i-700's with Pocket PC 2003 attempts to access our mail exchange server, all we receive is the following error message: " A System error has occurred while processing your request. Please try again. If the problem persists, contact your administrator. Home" mail.domain.com/exchange works fine though. We've installed the service pack 1 for exchange 2003 to attempt to fix this issue and are having the same results. Does anyone care to share how they may have overcome this exchange problem with their compatible PDAs and Exchange's OMA (Outlook Mobile Access...

Third request for help with Payables Error message!
Ok I have posted this for the third time with no response! I need help to know if there is any kind of issue on the back end of our environment. If someone could help it would be greatly appreciated! We are currently running GP 10 SP1 and apparently since version 8 (we did not upgrade to 9) there has been the following error message while launching a transaction out of Smartlist, when we go to inquiry for AP documents, and drill down of PMTRX & PMCHK from the JE inquiry view: Unhandeled Script Exception: Index 0 array of 'PM_Transaction_Inquiry_Fill' Script terminated We ran a ...

Amazing Problem in AllocPhysMem wince 6.0
Hi I am writing a Port Driver for x86 platform in WinCE 6.0. I want to allocate virtual and equivalent physical memory in driver and mapped it to USER mode to use application. For that I used AllocPhysMem in driver and passed that address through IOCTL calls but i cant use that virtual and physical address in application side. Because AllocPhysMem returns Error Code as 0x57 (meaning Parameter incorrect). But the same code is working in WinCe 5.0. My code snippet is, VirAddress = (LPVOID)AllocPhysMem(32, PAGE_READWRITE|PAGE_NOCACHE, 0, ...

Creating a CFormView application produces errors
Using Visual Studio.Net 2003 I have created a C++ MFC application with Single Document Interface and Document/View support, and have changed the base class for the derived View class to CFormView. All other settings are their defaults. When I compile the source code generated, I get an error stating that the base class CRichEditCntrItem is undefined in the declaration of the CRichEditCntrItem derived class. According to the Help, CRichEditCntrItem requires the header afxrich.h If I add this include into the stdafx.H file and recompile, I get a syntax error in the constructor for the CRic...

Should unimplmented pure function throw a compile error?
It's been a while since I have written anything with abstract classes. If I derive a class from my abstract class and do not implement a pure virtual function of the base class in the derived class, shouldn't the compiler throw an error? -- Bruce E. Stemplewski GarXface OCX and C++ Class Library for the Garmin GPS www.stempsoft.com yes, if you try to instantiate the class in your code it should. "Bruce E. Stemplewski " <BruceStemplewski@hotmail.com> wrote in message news:uaGJZhYCFHA.3732@TK2MSFTNGP14.phx.gbl... > It's been a while since I have written anyt...

getting the error when updating file xls file.
Hi. We are using exchange 2003 server and office XP but know we start to Upgrade our office to office 2003 Know we are face problem. When our user try to make changes to file in public folder there can not make the changes it say “file is read only” but that user can make the changes or edit that same file from the P.C were office XP is installed. Do I have to install some patch if yes can you please send that patch because in trying from last two day and I can not find it. Note: If possible can you reply on parag.lopes@madinatjumeirah.com Just a guess... Are you s...

function keys
Hello, Is there a site where I can get a recap of RMS function keys? Not that I know of, but F1 - Help is a really good place to start! Glenn Adams Tiber Creek Consulting http://www.tibercreek.com glenn@tibercreek.com ---------------------------------------------- Please DO NOT respond to me directly but post all responses here in the newsgroup so that all can share the information. newbie wrote: > Hello, > Is there a site where I can get a recap of RMS function keys? This is a multi-part message in MIME format. ------=_NextPart_000_02DF_01C6B6FC.B3481FA0 Content-Type: text/plain; ...

Re: Function to copy data from a variable range?
I have a sheet with about 20,000 lines of data. From that sheet I am looking to group the data based on a parameter, into multiple different sheets. ie: If the category is "1" copy all that lines data into sheet A, If the category is "2", copy all the lines into sheet B. The problem is, the number of lines for each acatgeory type is not always the same. Some categories may only have 1 or two lines, other may have 200-300. Is there any type of function for this? Thanks! Doable but why not just use data>filter>autofilter -- Don Guillett Microsoft MVP Excel SalesA...

Term ID Error
Ok, for the last week, I have been trying to get my PinPad (Verifone 1000se) to work. I have done all of the test and the issue seems to be when it goes out and gets the authorization, I get the Status as FAILED and Result 3: Term ID Error. I have contacted both Paymentech and Vital and they both tell me that things are correct on their end. Paymentech is the one that sent me the PinPad and was supposed to be injected. What else could be the issue? Bill, What did Vital say when you told them that error message? Sounds like one of the two of you have the wrong Terminal ID #. -- = ...

Spontaneous 'Compile Error' In Queries
I've got a half-dozen queries that contain this expression: IssuerName: IIf(IsNull([tblIssuer].[IssuerID]),"[Issuer Unknown]",[tblIssuer].[IssuerName]) Haven't touched any of them, but suddenly they were all throwing "Compile error. in query expression 'IssuerName: IIf(IsNull([tblIssuer].[IssuerID]),"[Issuer Unknown]",[tblIssuer].[IssuerName])'." tblIssuer.IssuerID is still there in a link. My kneejerk was to somehow force recompiles of all the queries, so I did a Compact/Repair. After the compact/repair, all was well: the errors went away. C...

Payables Transaction Edit List
Our customer had the following error print on the Payables Transaction Edit List: **ERROR: One of more landed costs need to be apportioned.Document Total. This prevented the user from posting the batch. The batch went into Batch Recovery. However, the error message did not appear when logged in as 'sa' and 'sa' was able to post the batch. This customer does not even own the landed cost module. Plus, this was an A/P invoice, not a POP invoice. Why was this message appearing? ...

Attach Trigger to Save Function of Form
I am in the processes of trying to attach a trigger to the Save function of an already existing GP form using Dex. In one of the documents, it states that the CM_Checkbook_Maitenance has a SaveRecord function. I am trying to acces the function that is similar to this on the PM_Vendor_Maitenance form. I tried using SaveRecord and when I tried to compile it it says that it is an unknown reference. Is there some documentation with a list of the functions for each form? Mike, PM_Vendor_Maintenance is an older form and probably doesn't have a SaveRecord function. Try running t...

Exchange error
Hello, for one week now, my exchange 2000 server crashes nearly every night at random time, the only solution to have it all restart is to restart the entire server. In the application log, multiple error events are reported like these : Event Type: Error Event Source: Userenv Event Category: None Event ID: 1000 Date: 26/07/2005 Time: 01:27:39 User: NT AUTHORITY\SYSTEM Computer: BELLINI Description: Windows cannot establish a connection to *domain name* with (1364). Event Type: Error Event Source: Userenv Event Category: None Event ID: 1000 Date: 26/07/2005 Time: 01:37:41 User: ...

Pub98 +WEBBBOT-SELF 404 error
This is a multi-part message in MIME format. ------=_NextPart_000_000A_01C430F5.D4ADD7A0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi All,=20 Just published a web site-using publisher 98. I have to say the results = are pretty good and I found it fast and easy to use. One BIG problem!!.. I have included a simple reply form and when SUBMIT is pressed I get the = 404 page not found -WEBBOT-SELF-error. I know the problem is down to = FrontPage extensions, but how do I fix the fault.=20 Many Thanks. John. Bewlay51@yahoo.co.uk ----...

Range error
Why does this return an error? Dim Unknown As Range Unknown = Range("K24") oldjay Range is an object and so you need to use the Set Statement which assigns an object reference to a variable or property. Refer help on Set statement.... Dim rngTemp As Range Set rngTemp = Range("K24") 'will refer to the activesheet cell K24 -- Jacob "oldjay" wrote: > Why does this return an error? > > Dim Unknown As Range > Unknown = Range("K24") > > oldjay Thanks I never know where to look in help. I think Help is...

Exchange error: 0x8004050a
When accessing an exchange server via mozilla or dtmail on a solaris machine, I get this error: 0x8004050a. The text is "unrecognized internal error". In mozilla, it gives me this error but fetches the mail anyway. dtmail simply doesnt work at all. If I switch to a W2K machine on the same network, outlook works just fine. Does anyone know what this error means? How can it be fixed? It just "started" one day... Joe Check this out... http://support.microsoft.com/default.aspx?scid=kb;en-us;892397 j.wetstein@gmail.com wrote: > When accessing an exchange server via mozi...

Setting up Exchange 2003
I had this problem the other day while extending the schema in preparation for an upgrade to Exchange 2003. I searched through a lot of databases and search engines, and found that a lot of people have had this problem, but none of the forums led to a clear cut answer to the issue. So, I thought I'd share my solution to try and help others out, and save them some time and frustration. I was ready to call Microsoft support right before I figured this out. While running forest prep (setup /forestprep), setup failed with Error code 0XC103798A. It then specified to check the Exchange inst...

Re-exporting functions from dynamically linked DLL
Hi, I have the following situation: I have a 3rd party DLL which does not include a LIB file, just a header file with typedef declarations for exported functions (It is intended for dynamic linking) I need to wrap the DLL to allow for callbacks to my own code (in Lisp), and to do this I need to load the DLL using LoadLibrary and access each function that I need using GetProcAddress. So for example: The third party header will say: typedef INT (WINAPI * lp_function)(); Then in my c wrapper file: #include "3rdparty.h" #ifdef _WIN32 #define DllExport __declspec(dllexport) #else #...

how can i use countif function inside a filtered range
How can I use countif function inside a filtered range Hi, Not much detail here, so this is the general idea: =SUMPRODUCT(SUBTOTAL(3,OFFSET(C13:C18,ROW(13:18)-13,0,1)),--(C13:C18="Red")) -- If this helps, please click the Yes button Cheers, Shane Devenshire "jayin" wrote: > How can I use countif function inside a filtered range Shane Devenshire wrote on 02/24/2009 02:05 ET : > Hi, > > Not much detail here, so this is the general idea: > > =SUMPRODUCT(SUBTOTAL(3,OFFSET(C13:C18,ROW(13:18)-13,0,1)),--(C13:C18=&quot;Red&quot;)) > > ...

SLbuild.dic Error on Startup
We are running GP Ver 7.5 SP 5. I recently loaded a new client workstation all went well witht the exception that every time this person starts GP, he gets an error "Can Not find Slbuild.dic", he can click OK and carry on as normal. This is more of a nuisance error than anything. Does anyone have any idea as to what may cause this and how to get rid of it??? -- Patrick Matthews Systems Administrator Potawatomi Bingo Casino As you seem to only get this on startup, my guess is that the dynamics.set file is slightly "messed up". Meaning that somehow and for some reason...