+ Reply to Thread
Results 1 to 3 of 3

Statistics Help Requested - Bayes' Theorem posterior odds > 1

  1. #1
    Registered User
    Join Date
    01-08-2014
    Location
    San Francisco
    MS-Off Ver
    Excel 2007
    Posts
    34

    Statistics Help Requested - Bayes' Theorem posterior odds > 1

    Hi All,

    I took an antigen test yesterday and was trying to create a tool to help me interpret the results via Bayes' Theorem. I used actual sensitivity and specificity numbers from the CDC, calculated odds of test results given presence of condition, true/false positive/negative rates, and finally presence of disease given test result. One of the posterior odds is greater than 1, which doesn't make sense to me. Can anyone help me understand if this is a valid result or if I've made a mistake in my calculations or methodology? I think I've attached my workbook, please refer to the "Duplicate" tab.

    Best,

    Scott

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS 365 Family 64-bit 2502
    Posts
    26,995

    Re: Statistics Help Requested - Bayes' Theorem posterior odds > 1

    No file attached. The paper clip icon does not work for attachments. To attach a file:

    1. Under the text box where you type your reply click the Go Advanced button.
    2. On the next screen scroll down and under the Attachments section click the Manage Attachments link, which will show a pop-up window.
    3. Click the Choose File button to select a file to attached.
    4. Click the Upload button to upload the file.
    5. Then click the Close This Window button. Your file is now attached to your post.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Registered User
    Join Date
    01-08-2014
    Location
    San Francisco
    MS-Off Ver
    Excel 2007
    Posts
    34

    Re: Statistics Help Requested - Bayes' Theorem posterior odds > 1

    Hi, I tried to attach it originally matching your steps but it doesn't seem to have worked. I just did the same thing - please let me know if the file is now available.

    Best,

    Scott
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Help using Bayes Theorem for Project Threats Analysis
    By pmcleod in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 10-19-2019, 09:10 PM
  2. Is it Possible to use Bayes' theorem
    By pmcleod in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-13-2015, 11:24 PM
  3. Bayes Theorem with formulas and ranking
    By mloffredo in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 07-01-2015, 09:18 PM
  4. How to calculate Bookmaker real odds (odds less commission) in Excel 2013 ?
    By sbeekallan in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 04-09-2015, 08:43 AM
  5. Replies: 1
    Last Post: 07-20-2012, 06:55 AM
  6. Replies: 3
    Last Post: 08-31-2011, 09:11 AM
  7. pythagoras theorem help needed
    By matrix in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 04-10-2006, 10:50 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1