Closed Thread
Results 1 to 2 of 2

Is it Possible to use Bayes' theorem

  1. #1
    Registered User
    Join Date
    11-13-2015
    Location
    Toronto
    MS-Off Ver
    MAC 2016
    Posts
    6

    Is it Possible to use Bayes' theorem

    This may not be the right approach. With the help of other experts I have built an Excel sheet that provides the likelihood of a project finishing on a given particular day. My inputs are:

    best/availability/productivity
    worst/availability/productivity
    best guess/availability/productivity


    Once they are all divided and summarized a Cart. Product of 3 sets is used with Standard Dev and Var to determine the probability of the project ending on the dates estimated. This is working well. What I want to do is add a list of questions on the sheet where the values required will either be y/n or numbers (questions will be weighted according to importance) then see if Bayes can be applied to the sheet to improve the overall accuracy of the probability of completion.

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,929

    Re: Is it Possible to use Bayes' theorem

    OP has posted in Commercial Forum, so I will now close this thread-
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Bayes Theorem with formulas and ranking
    By mloffredo in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 07-01-2015, 09:18 PM
  2. Using Pythagoras theorem to count results
    By demongeeks in forum Excel General
    Replies: 3
    Last Post: 05-19-2010, 03:32 PM
  3. 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