Need to return a p value for a specified z score in PL/SQL

Posted on 2007-08-01
Last Modified: 2013-12-19
I need to return a p value for a specified z score in PL/SQL

is there a statistical function I can use to do this...for example

z score   (IN)         p value (OUT)
0.00                           .5
-0.67                          .25
-1.28                          .1
-1.65                          .05
-2.33                           .01

Question by:ohmetw
    LVL 3

    Expert Comment

    I don't think there is any statistical function for this.

    We can write a simple select statement similar to

    SELECT p_value
    INTO out_variable
    WHERE z_score = in_variable;


    Author Comment

    I need to derive the p value, there isn't a table to lookup the value
    LVL 3

    Expert Comment

    Can you provide more information like where these values are?

    Accepted Solution

    I have done more research now and confirmed tjere isn't a premade solution.  I have created a table with the necessary values and that will work for me just fine
    Thanks for trying to help!

    Featured Post

    PRTG Network Monitor: Intuitive Network Monitoring

    Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

    Join & Write a Comment

    Working with Network Access Control Lists in Oracle 11g (part 1) Part 2: So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
    How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
    This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…
    This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

    745 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now