How to predict the next number in a series while having additional series of data that might affect it?












5












$begingroup$


Let's say we want to predict the price of Big Mac for the year 2020. We have 2 indexes that we think might make an influence to Big Mac price determination.



|----------------|----------------|----------------------|----------------|
|------Date------|-big_mac_price--|---burger_king_price--|---%inflation---|
|----------------|----------------|----------------------|----------------|
|------2020------|-------???------|---------1.8----------|------3---------|
|------2019------|-------1.5------|---------1.6----------|------2---------|
|------2018------|-------2.1------|---------2.5----------|------1---------|
|------2017------|-------2.2------|---------2.5----------|------0---------|
|----------------|----------------|----------------------|----------------|


Imagine that we don't have additional data. What kind of methodology would you use to estimate it? In ideal case scenario, after setting our prediction you will be able to set the weight of each of the index. For example:




  • Burger king price will affect it in 79%

  • Inflation will affect it in 21%


I know there might be missing information to this task, but the important thing here is the methodology used to get it, so feel free to invent more data if needed.










share|cite|improve this question







New contributor




Lukas is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.







$endgroup$








  • 1




    $begingroup$
    It really depends on the error distributions, their dependence structure, and the form of the relationship
    $endgroup$
    – Glen_b
    5 hours ago
















5












$begingroup$


Let's say we want to predict the price of Big Mac for the year 2020. We have 2 indexes that we think might make an influence to Big Mac price determination.



|----------------|----------------|----------------------|----------------|
|------Date------|-big_mac_price--|---burger_king_price--|---%inflation---|
|----------------|----------------|----------------------|----------------|
|------2020------|-------???------|---------1.8----------|------3---------|
|------2019------|-------1.5------|---------1.6----------|------2---------|
|------2018------|-------2.1------|---------2.5----------|------1---------|
|------2017------|-------2.2------|---------2.5----------|------0---------|
|----------------|----------------|----------------------|----------------|


Imagine that we don't have additional data. What kind of methodology would you use to estimate it? In ideal case scenario, after setting our prediction you will be able to set the weight of each of the index. For example:




  • Burger king price will affect it in 79%

  • Inflation will affect it in 21%


I know there might be missing information to this task, but the important thing here is the methodology used to get it, so feel free to invent more data if needed.










share|cite|improve this question







New contributor




Lukas is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.







$endgroup$








  • 1




    $begingroup$
    It really depends on the error distributions, their dependence structure, and the form of the relationship
    $endgroup$
    – Glen_b
    5 hours ago














5












5








5





$begingroup$


Let's say we want to predict the price of Big Mac for the year 2020. We have 2 indexes that we think might make an influence to Big Mac price determination.



|----------------|----------------|----------------------|----------------|
|------Date------|-big_mac_price--|---burger_king_price--|---%inflation---|
|----------------|----------------|----------------------|----------------|
|------2020------|-------???------|---------1.8----------|------3---------|
|------2019------|-------1.5------|---------1.6----------|------2---------|
|------2018------|-------2.1------|---------2.5----------|------1---------|
|------2017------|-------2.2------|---------2.5----------|------0---------|
|----------------|----------------|----------------------|----------------|


Imagine that we don't have additional data. What kind of methodology would you use to estimate it? In ideal case scenario, after setting our prediction you will be able to set the weight of each of the index. For example:




  • Burger king price will affect it in 79%

  • Inflation will affect it in 21%


I know there might be missing information to this task, but the important thing here is the methodology used to get it, so feel free to invent more data if needed.










share|cite|improve this question







New contributor




Lukas is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.







$endgroup$




Let's say we want to predict the price of Big Mac for the year 2020. We have 2 indexes that we think might make an influence to Big Mac price determination.



|----------------|----------------|----------------------|----------------|
|------Date------|-big_mac_price--|---burger_king_price--|---%inflation---|
|----------------|----------------|----------------------|----------------|
|------2020------|-------???------|---------1.8----------|------3---------|
|------2019------|-------1.5------|---------1.6----------|------2---------|
|------2018------|-------2.1------|---------2.5----------|------1---------|
|------2017------|-------2.2------|---------2.5----------|------0---------|
|----------------|----------------|----------------------|----------------|


Imagine that we don't have additional data. What kind of methodology would you use to estimate it? In ideal case scenario, after setting our prediction you will be able to set the weight of each of the index. For example:




  • Burger king price will affect it in 79%

  • Inflation will affect it in 21%


I know there might be missing information to this task, but the important thing here is the methodology used to get it, so feel free to invent more data if needed.







machine-learning time-series forecasting prediction






share|cite|improve this question







New contributor




Lukas is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.











share|cite|improve this question







New contributor




Lukas is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.









share|cite|improve this question




share|cite|improve this question






New contributor




Lukas is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.









asked 6 hours ago









LukasLukas

1283




1283




New contributor




Lukas is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.





New contributor





Lukas is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.






Lukas is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.








  • 1




    $begingroup$
    It really depends on the error distributions, their dependence structure, and the form of the relationship
    $endgroup$
    – Glen_b
    5 hours ago














  • 1




    $begingroup$
    It really depends on the error distributions, their dependence structure, and the form of the relationship
    $endgroup$
    – Glen_b
    5 hours ago








1




1




$begingroup$
It really depends on the error distributions, their dependence structure, and the form of the relationship
$endgroup$
– Glen_b
5 hours ago




$begingroup$
It really depends on the error distributions, their dependence structure, and the form of the relationship
$endgroup$
– Glen_b
5 hours ago










2 Answers
2






active

oldest

votes


















3












$begingroup$

Great Question!



The general approach is called a ARMAX model enter image description here



The reason for the generality of approach is that it is important to consider the following possible states of nature.




  1. The big mac price might be predicted better using previous big mac prices in conjunction with activity in the two causals

  2. There might be discernable trends in big mac prices due to historical pricing strategy

  3. The big mac price may be related to burger king prices OR changes in burger king prices or the history/trends of burger king prices

  4. The big mac price may be related to inflation , changes in inflation or trends in inflation

  5. There may be unusual values in the history of big mac prices or burger king prices or inflation that should be adjusted for in order to generate good coefficients. Sometimes unusual values are recording errors.

  6. There may be omitted variables (stochastic in nature ) that may be important such as the price of a Wendy's burger .

  7. There may have been one or mere variance changes suggesting the need for some
    sort of down-weighting to normalize the data.


The final model can be expressed as a Polynomial Distributed Lag model (PDL) or otherwise known as an ADL model (Autoregressive Distributed Lag).






share|cite|improve this answer











$endgroup$





















    0












    $begingroup$

    One of the possible solutions: classifier:



    var samples = [[2.5, 0], [2.5, 1], [1.6, 2]];
    var labels = ['2.2', '2.1', '1.5'];

    var classifier->train(samples, labels);

    result = var classifier->predict([1.8, 3]);
    return result;


    Classifier is a Machine learning function based on libsvm. This was my first approach, however it's not accurate as the labels are not participating as calculation. It would just return the label as text where the prediction numbers are closest to sample numbers.



    In this case the result would be 2.2.






    share|cite|improve this answer








    New contributor




    Lukas is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
    Check out our Code of Conduct.






    $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: "65"
      };
      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: false,
      noModals: true,
      showLowRepImageUploadWarning: true,
      reputationToPostImages: null,
      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
      },
      onDemand: true,
      discardSelector: ".discard-answer"
      ,immediatelyShowMarkdownHelp:true
      });


      }
      });






      Lukas is a new contributor. Be nice, and check out our Code of Conduct.










      draft saved

      draft discarded


















      StackExchange.ready(
      function () {
      StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstats.stackexchange.com%2fquestions%2f398489%2fhow-to-predict-the-next-number-in-a-series-while-having-additional-series-of-dat%23new-answer', 'question_page');
      }
      );

      Post as a guest















      Required, but never shown

























      2 Answers
      2






      active

      oldest

      votes








      2 Answers
      2






      active

      oldest

      votes









      active

      oldest

      votes






      active

      oldest

      votes









      3












      $begingroup$

      Great Question!



      The general approach is called a ARMAX model enter image description here



      The reason for the generality of approach is that it is important to consider the following possible states of nature.




      1. The big mac price might be predicted better using previous big mac prices in conjunction with activity in the two causals

      2. There might be discernable trends in big mac prices due to historical pricing strategy

      3. The big mac price may be related to burger king prices OR changes in burger king prices or the history/trends of burger king prices

      4. The big mac price may be related to inflation , changes in inflation or trends in inflation

      5. There may be unusual values in the history of big mac prices or burger king prices or inflation that should be adjusted for in order to generate good coefficients. Sometimes unusual values are recording errors.

      6. There may be omitted variables (stochastic in nature ) that may be important such as the price of a Wendy's burger .

      7. There may have been one or mere variance changes suggesting the need for some
        sort of down-weighting to normalize the data.


      The final model can be expressed as a Polynomial Distributed Lag model (PDL) or otherwise known as an ADL model (Autoregressive Distributed Lag).






      share|cite|improve this answer











      $endgroup$


















        3












        $begingroup$

        Great Question!



        The general approach is called a ARMAX model enter image description here



        The reason for the generality of approach is that it is important to consider the following possible states of nature.




        1. The big mac price might be predicted better using previous big mac prices in conjunction with activity in the two causals

        2. There might be discernable trends in big mac prices due to historical pricing strategy

        3. The big mac price may be related to burger king prices OR changes in burger king prices or the history/trends of burger king prices

        4. The big mac price may be related to inflation , changes in inflation or trends in inflation

        5. There may be unusual values in the history of big mac prices or burger king prices or inflation that should be adjusted for in order to generate good coefficients. Sometimes unusual values are recording errors.

        6. There may be omitted variables (stochastic in nature ) that may be important such as the price of a Wendy's burger .

        7. There may have been one or mere variance changes suggesting the need for some
          sort of down-weighting to normalize the data.


        The final model can be expressed as a Polynomial Distributed Lag model (PDL) or otherwise known as an ADL model (Autoregressive Distributed Lag).






        share|cite|improve this answer











        $endgroup$
















          3












          3








          3





          $begingroup$

          Great Question!



          The general approach is called a ARMAX model enter image description here



          The reason for the generality of approach is that it is important to consider the following possible states of nature.




          1. The big mac price might be predicted better using previous big mac prices in conjunction with activity in the two causals

          2. There might be discernable trends in big mac prices due to historical pricing strategy

          3. The big mac price may be related to burger king prices OR changes in burger king prices or the history/trends of burger king prices

          4. The big mac price may be related to inflation , changes in inflation or trends in inflation

          5. There may be unusual values in the history of big mac prices or burger king prices or inflation that should be adjusted for in order to generate good coefficients. Sometimes unusual values are recording errors.

          6. There may be omitted variables (stochastic in nature ) that may be important such as the price of a Wendy's burger .

          7. There may have been one or mere variance changes suggesting the need for some
            sort of down-weighting to normalize the data.


          The final model can be expressed as a Polynomial Distributed Lag model (PDL) or otherwise known as an ADL model (Autoregressive Distributed Lag).






          share|cite|improve this answer











          $endgroup$



          Great Question!



          The general approach is called a ARMAX model enter image description here



          The reason for the generality of approach is that it is important to consider the following possible states of nature.




          1. The big mac price might be predicted better using previous big mac prices in conjunction with activity in the two causals

          2. There might be discernable trends in big mac prices due to historical pricing strategy

          3. The big mac price may be related to burger king prices OR changes in burger king prices or the history/trends of burger king prices

          4. The big mac price may be related to inflation , changes in inflation or trends in inflation

          5. There may be unusual values in the history of big mac prices or burger king prices or inflation that should be adjusted for in order to generate good coefficients. Sometimes unusual values are recording errors.

          6. There may be omitted variables (stochastic in nature ) that may be important such as the price of a Wendy's burger .

          7. There may have been one or mere variance changes suggesting the need for some
            sort of down-weighting to normalize the data.


          The final model can be expressed as a Polynomial Distributed Lag model (PDL) or otherwise known as an ADL model (Autoregressive Distributed Lag).







          share|cite|improve this answer














          share|cite|improve this answer



          share|cite|improve this answer








          edited 2 hours ago

























          answered 5 hours ago









          IrishStatIrishStat

          21.2k42341




          21.2k42341

























              0












              $begingroup$

              One of the possible solutions: classifier:



              var samples = [[2.5, 0], [2.5, 1], [1.6, 2]];
              var labels = ['2.2', '2.1', '1.5'];

              var classifier->train(samples, labels);

              result = var classifier->predict([1.8, 3]);
              return result;


              Classifier is a Machine learning function based on libsvm. This was my first approach, however it's not accurate as the labels are not participating as calculation. It would just return the label as text where the prediction numbers are closest to sample numbers.



              In this case the result would be 2.2.






              share|cite|improve this answer








              New contributor




              Lukas is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
              Check out our Code of Conduct.






              $endgroup$


















                0












                $begingroup$

                One of the possible solutions: classifier:



                var samples = [[2.5, 0], [2.5, 1], [1.6, 2]];
                var labels = ['2.2', '2.1', '1.5'];

                var classifier->train(samples, labels);

                result = var classifier->predict([1.8, 3]);
                return result;


                Classifier is a Machine learning function based on libsvm. This was my first approach, however it's not accurate as the labels are not participating as calculation. It would just return the label as text where the prediction numbers are closest to sample numbers.



                In this case the result would be 2.2.






                share|cite|improve this answer








                New contributor




                Lukas is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
                Check out our Code of Conduct.






                $endgroup$
















                  0












                  0








                  0





                  $begingroup$

                  One of the possible solutions: classifier:



                  var samples = [[2.5, 0], [2.5, 1], [1.6, 2]];
                  var labels = ['2.2', '2.1', '1.5'];

                  var classifier->train(samples, labels);

                  result = var classifier->predict([1.8, 3]);
                  return result;


                  Classifier is a Machine learning function based on libsvm. This was my first approach, however it's not accurate as the labels are not participating as calculation. It would just return the label as text where the prediction numbers are closest to sample numbers.



                  In this case the result would be 2.2.






                  share|cite|improve this answer








                  New contributor




                  Lukas is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
                  Check out our Code of Conduct.






                  $endgroup$



                  One of the possible solutions: classifier:



                  var samples = [[2.5, 0], [2.5, 1], [1.6, 2]];
                  var labels = ['2.2', '2.1', '1.5'];

                  var classifier->train(samples, labels);

                  result = var classifier->predict([1.8, 3]);
                  return result;


                  Classifier is a Machine learning function based on libsvm. This was my first approach, however it's not accurate as the labels are not participating as calculation. It would just return the label as text where the prediction numbers are closest to sample numbers.



                  In this case the result would be 2.2.







                  share|cite|improve this answer








                  New contributor




                  Lukas is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
                  Check out our Code of Conduct.









                  share|cite|improve this answer



                  share|cite|improve this answer






                  New contributor




                  Lukas is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
                  Check out our Code of Conduct.









                  answered 4 hours ago









                  LukasLukas

                  1283




                  1283




                  New contributor




                  Lukas is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
                  Check out our Code of Conduct.





                  New contributor





                  Lukas is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
                  Check out our Code of Conduct.






                  Lukas is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
                  Check out our Code of Conduct.






















                      Lukas is a new contributor. Be nice, and check out our Code of Conduct.










                      draft saved

                      draft discarded


















                      Lukas is a new contributor. Be nice, and check out our Code of Conduct.













                      Lukas is a new contributor. Be nice, and check out our Code of Conduct.












                      Lukas is a new contributor. Be nice, and check out our Code of Conduct.
















                      Thanks for contributing an answer to Cross Validated!


                      • 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%2fstats.stackexchange.com%2fquestions%2f398489%2fhow-to-predict-the-next-number-in-a-series-while-having-additional-series-of-dat%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

                      How to reconfigure Docker Trusted Registry 2.x.x to use CEPH FS mount instead of NFS and other traditional...

                      is 'sed' thread safe

                      How to make a Squid Proxy server?