Inverse Error Function In Excel
Contents |
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? inverse erfc calculator if not - does anybody know about som java-coding that can do it Best
Erfcinv Excel
regard morten Morten, Apr 1, 2004 #1 Advertisements Jerry W. Lewis Guest inverf(p) = SQRT(GAMMAINV(p,0.5,1)) inverfc(p) = -NormSInv(p/2)/Sqrt(2) Mathemetically exact, but inverse error function matlab 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 inverse complementary error function 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 Jerry W. Lewis, Apr 2, 2004 #2 Advertisements Morten Guest Thats works perfect... Thank you for solving my problem Best regard Morten, Denmark Morten, Apr 2, 2004 #3 Jerry W. Lewis
Erf Function Excel
Guest Glad it helped Jerry Morten wrote: > Thats works perfect... Thank you for solving my problem. > > Best regards > > Morten, Denmark Jerry W. Lewis, Apr 2, 2004 #4 Advertisements Show Ignored Content Want to reply to this thread or ask your own question? It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum. Sign Up Now! Similar Threads formula for inverse tan of a number with answer in degrees Gord Dibben, Jul 4, 2005, in forum: Excel Misc Replies: 0 Views: 86 Gord Dibben Jul 4, 2005 log inverse Az, Nov 28, 2005, in forum: Excel Misc Replies: 1 Views: 83 Nov 28, 2005 Inverse rank SteveC, May 3, 2006, in forum: Excel Misc Replies: 6 Views: 134 SteveC May 3, 2006 binary inverse boardmaker, Jun 13, 2006, in forum: Excel Misc Replies: 4 Views: 88 daddylonglegs Jun 13, 2006 Excel should support a proper inverse to "Text to columns" johndog, Oct 4, 2006, in forum: Excel Misc Replies: 0 Views: 121 johndog Oct 4, 2006 inverse matrices Chey, Jan 30, 2007, in forum: Excel Misc Replies: 6 Views: 122 Mike Middleton Jan 31, 2007 FFT INVER
Error
Erf Function Calculator
Function Free Statistics Calculators: Home > Inverse Error Function Calculator http://www.office-forums.com/threads/the-inverse-error-function-erfinv.862363/ Inverse Error Function Calculator This calculator will compute the value of the inverse error function, given the limit of integration http://www.danielsoper.com/statcalc/calculator.aspx?id=73 x. The inverse error function is also known as the Gauss inverse error function.Please enter the necessary parameter values, and then click 'Calculate'. x: Related Resources Calculator Formulas References Related Calculators Search Free Statistics Calculators version 4.0 The Free Statistics Calculators index now contains 106 free statistics calculators! Copyright © 2006 - 2016 by Dr. Daniel Soper. All rights reserved.
Forums Excel Questions code for inverse erf function Results 1 to 7 of 7 code for inverse erf functionThis is a discussion on code for inverse erf function within the Excel Questions http://www.mrexcel.com/forum/excel-questions/234208-code-inverse-erf-function.html forums, part of the Question Forums category; I am doing work with confidence intervals for normally distributed data and I want to be able to calculate specific ... LinkBack LinkBack URL About LinkBacks Bookmark & Share Digg this Thread!Add Thread to del.icio.usBookmark in TechnoratiTweet this thread Thread Tools Show Printable Version Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode Nov 16th, 2006,12:38 PM #1 pete6982 error function New Member Join Date Aug 2006 Location Louisville, KY Posts 19 code for inverse erf function I am doing work with confidence intervals for normally distributed data and I want to be able to calculate specific intervals (such as .92, etc). If x is the mean and y is the std dev I know that CI=(x-ny,x+ny), where n=sqrt(2)*inverseERF(CI). I tried to make a vba function to calculate the inverse error function invERF, but I'm off by a bit. Does anyone know of an existing invERF funcion? I can't find actual code for one anywhere. Thanks, Pete Share Share this post on Digg Del.icio.us Technorati Twitter Reply With Quote Nov 16th, 2006,01:31 PM #2 Andrew Poulsom MrExcel MVPModerator Join Date Jul 2002 Posts 73,092 There are ERF and ERFC functions in the Analysis ToolPak, but I don't know if those are what you want. There is also a CONFIDENCE function. Share Share this post on Digg Del.icio.us Technorati Twitter Reply With Quote Nov 16th, 2006,01:52 PM #3 pgc01 MrExcel MVP Join Date Apr 2006 Posts 18,226 Hi Pete Look at the function CONFIDENCE() as Andrew said. If, however, you really need to compute the value of the invERF there is a small code (posted by JJ 05-18-06 09:20). It is in Pascal and so should be very easy to port to vba. The name of the function is invErf http://les-mathematiques.u-strasbg.f...86277&t=286277 Hope this helps PGC Share Share this post on Digg Del.icio.us Technorati Twitter Reply With Quote Nov 17th, 2006,01:34 PM #4 pete6982 New Member Join Date Aug 2006 Location Louisville, KY Posts 19 thanks guys. i was able to recode the pascal invERF function into vba.