Weight the probability of a prediction based on historical accuracy












0












$begingroup$


I have six predictions from six different sources. Each prediction has a percent probability that the prediction will happen, as well as a historical accuracy percentage.



Here's a table of my problem:



enter image description here



This is the link to the table:
https://docs.google.com/spreadsheets/d/1fioSBZiucRwsyeUD4foi2Bt2tBAUXSpv9Esvgksm_mk/edit?usp=sharing



An example of how to read this would be TF predicts the likelihood of a 0 is 63% and has been historically correct 43% of the time.



I want to find if the prediction should be 1 or 0 by weighting predictions with more historical accuracy. For example, TF predicts 0 with a probability of 63%. It has a historical accuracy of 43%. In contrast, LINE predicts 1 with a 81% probability and the same 73% historical accuracy. I want the overall prediction between these two sources to be 1 because LINE has a higher probability than TF and a higher historical accuracy.



So, my question is: how can I mathematically find the average prediction weighted by probability and historical accuracy?



Thanks in advance!










share|cite|improve this question









$endgroup$

















    0












    $begingroup$


    I have six predictions from six different sources. Each prediction has a percent probability that the prediction will happen, as well as a historical accuracy percentage.



    Here's a table of my problem:



    enter image description here



    This is the link to the table:
    https://docs.google.com/spreadsheets/d/1fioSBZiucRwsyeUD4foi2Bt2tBAUXSpv9Esvgksm_mk/edit?usp=sharing



    An example of how to read this would be TF predicts the likelihood of a 0 is 63% and has been historically correct 43% of the time.



    I want to find if the prediction should be 1 or 0 by weighting predictions with more historical accuracy. For example, TF predicts 0 with a probability of 63%. It has a historical accuracy of 43%. In contrast, LINE predicts 1 with a 81% probability and the same 73% historical accuracy. I want the overall prediction between these two sources to be 1 because LINE has a higher probability than TF and a higher historical accuracy.



    So, my question is: how can I mathematically find the average prediction weighted by probability and historical accuracy?



    Thanks in advance!










    share|cite|improve this question









    $endgroup$















      0












      0








      0





      $begingroup$


      I have six predictions from six different sources. Each prediction has a percent probability that the prediction will happen, as well as a historical accuracy percentage.



      Here's a table of my problem:



      enter image description here



      This is the link to the table:
      https://docs.google.com/spreadsheets/d/1fioSBZiucRwsyeUD4foi2Bt2tBAUXSpv9Esvgksm_mk/edit?usp=sharing



      An example of how to read this would be TF predicts the likelihood of a 0 is 63% and has been historically correct 43% of the time.



      I want to find if the prediction should be 1 or 0 by weighting predictions with more historical accuracy. For example, TF predicts 0 with a probability of 63%. It has a historical accuracy of 43%. In contrast, LINE predicts 1 with a 81% probability and the same 73% historical accuracy. I want the overall prediction between these two sources to be 1 because LINE has a higher probability than TF and a higher historical accuracy.



      So, my question is: how can I mathematically find the average prediction weighted by probability and historical accuracy?



      Thanks in advance!










      share|cite|improve this question









      $endgroup$




      I have six predictions from six different sources. Each prediction has a percent probability that the prediction will happen, as well as a historical accuracy percentage.



      Here's a table of my problem:



      enter image description here



      This is the link to the table:
      https://docs.google.com/spreadsheets/d/1fioSBZiucRwsyeUD4foi2Bt2tBAUXSpv9Esvgksm_mk/edit?usp=sharing



      An example of how to read this would be TF predicts the likelihood of a 0 is 63% and has been historically correct 43% of the time.



      I want to find if the prediction should be 1 or 0 by weighting predictions with more historical accuracy. For example, TF predicts 0 with a probability of 63%. It has a historical accuracy of 43%. In contrast, LINE predicts 1 with a 81% probability and the same 73% historical accuracy. I want the overall prediction between these two sources to be 1 because LINE has a higher probability than TF and a higher historical accuracy.



      So, my question is: how can I mathematically find the average prediction weighted by probability and historical accuracy?



      Thanks in advance!







      probability average






      share|cite|improve this question













      share|cite|improve this question











      share|cite|improve this question




      share|cite|improve this question










      asked Dec 2 '18 at 22:04









      Malachi BazarMalachi Bazar

      1033




      1033






















          1 Answer
          1






          active

          oldest

          votes


















          1












          $begingroup$

          https://en.wikipedia.org/wiki/Weighted_arithmetic_mean
          Above is reference. The basic formula is $p=frac{sum p_ia_i}{sum a_i}$. Where $p$ is the probability you want and $p_i,a_i$ are the individual probabilities and accuracy.






          share|cite|improve this answer









          $endgroup$













            Your Answer





            StackExchange.ifUsing("editor", function () {
            return StackExchange.using("mathjaxEditing", function () {
            StackExchange.MarkdownEditor.creationCallbacks.add(function (editor, postfix) {
            StackExchange.mathjaxEditing.prepareWmdForMathJax(editor, postfix, [["$", "$"], ["\\(","\\)"]]);
            });
            });
            }, "mathjax-editing");

            StackExchange.ready(function() {
            var channelOptions = {
            tags: "".split(" "),
            id: "69"
            };
            initTagRenderer("".split(" "), "".split(" "), channelOptions);

            StackExchange.using("externalEditor", function() {
            // Have to fire editor after snippets, if snippets enabled
            if (StackExchange.settings.snippets.snippetsEnabled) {
            StackExchange.using("snippets", function() {
            createEditor();
            });
            }
            else {
            createEditor();
            }
            });

            function createEditor() {
            StackExchange.prepareEditor({
            heartbeatType: 'answer',
            autoActivateHeartbeat: false,
            convertImagesToLinks: true,
            noModals: true,
            showLowRepImageUploadWarning: true,
            reputationToPostImages: 10,
            bindNavPrevention: true,
            postfix: "",
            imageUploader: {
            brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
            contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
            allowUrls: true
            },
            noCode: true, onDemand: true,
            discardSelector: ".discard-answer"
            ,immediatelyShowMarkdownHelp:true
            });


            }
            });














            draft saved

            draft discarded


















            StackExchange.ready(
            function () {
            StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmath.stackexchange.com%2fquestions%2f3023276%2fweight-the-probability-of-a-prediction-based-on-historical-accuracy%23new-answer', 'question_page');
            }
            );

            Post as a guest















            Required, but never shown

























            1 Answer
            1






            active

            oldest

            votes








            1 Answer
            1






            active

            oldest

            votes









            active

            oldest

            votes






            active

            oldest

            votes









            1












            $begingroup$

            https://en.wikipedia.org/wiki/Weighted_arithmetic_mean
            Above is reference. The basic formula is $p=frac{sum p_ia_i}{sum a_i}$. Where $p$ is the probability you want and $p_i,a_i$ are the individual probabilities and accuracy.






            share|cite|improve this answer









            $endgroup$


















              1












              $begingroup$

              https://en.wikipedia.org/wiki/Weighted_arithmetic_mean
              Above is reference. The basic formula is $p=frac{sum p_ia_i}{sum a_i}$. Where $p$ is the probability you want and $p_i,a_i$ are the individual probabilities and accuracy.






              share|cite|improve this answer









              $endgroup$
















                1












                1








                1





                $begingroup$

                https://en.wikipedia.org/wiki/Weighted_arithmetic_mean
                Above is reference. The basic formula is $p=frac{sum p_ia_i}{sum a_i}$. Where $p$ is the probability you want and $p_i,a_i$ are the individual probabilities and accuracy.






                share|cite|improve this answer









                $endgroup$



                https://en.wikipedia.org/wiki/Weighted_arithmetic_mean
                Above is reference. The basic formula is $p=frac{sum p_ia_i}{sum a_i}$. Where $p$ is the probability you want and $p_i,a_i$ are the individual probabilities and accuracy.







                share|cite|improve this answer












                share|cite|improve this answer



                share|cite|improve this answer










                answered Dec 2 '18 at 22:59









                herb steinbergherb steinberg

                2,5732310




                2,5732310






























                    draft saved

                    draft discarded




















































                    Thanks for contributing an answer to Mathematics Stack Exchange!


                    • Please be sure to answer the question. Provide details and share your research!

                    But avoid



                    • Asking for help, clarification, or responding to other answers.

                    • Making statements based on opinion; back them up with references or personal experience.


                    Use MathJax to format equations. MathJax reference.


                    To learn more, see our tips on writing great answers.




                    draft saved


                    draft discarded














                    StackExchange.ready(
                    function () {
                    StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmath.stackexchange.com%2fquestions%2f3023276%2fweight-the-probability-of-a-prediction-based-on-historical-accuracy%23new-answer', 'question_page');
                    }
                    );

                    Post as a guest















                    Required, but never shown





















































                    Required, but never shown














                    Required, but never shown












                    Required, but never shown







                    Required, but never shown

































                    Required, but never shown














                    Required, but never shown












                    Required, but never shown







                    Required, but never shown







                    Popular posts from this blog

                    Plaza Victoria

                    In PowerPoint, is there a keyboard shortcut for bulleted / numbered list?

                    How to put 3 figures in Latex with 2 figures side by side and 1 below these side by side images but in...