Confidence interval of dependant variable individual value by R-squared value











up vote
0
down vote

favorite












From the physical experiment I've got a sample collection of values (unique Y for each unique X). The problem is to find the linear regresstion function of given values collection. Then, assuming that the model is correct, extrapolate found linear function to X=0 and find an appropriate Y value with the confidence interval.



Using MS Excel I've got a graph like this with automatically calculated regression function equation and an R-squared value, which is good. The bad is that I couldn't understand how can I find a confidence interval for Y(X=0) by R-squared value (if it's possible).



The only solution similar to what I need I've found in my coursebook is the way to find the confidence interval for distribution of the constant value measurement (mean of Y), which, I suppose, is not applicable to my problem.



P.S. I can't get more than one value for each unique X because X is actually time. As time rises, the chemical reaction undergoes and electrical conductivity of the solution (which is Y) changes.










share|cite|improve this question







New contributor




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
























    up vote
    0
    down vote

    favorite












    From the physical experiment I've got a sample collection of values (unique Y for each unique X). The problem is to find the linear regresstion function of given values collection. Then, assuming that the model is correct, extrapolate found linear function to X=0 and find an appropriate Y value with the confidence interval.



    Using MS Excel I've got a graph like this with automatically calculated regression function equation and an R-squared value, which is good. The bad is that I couldn't understand how can I find a confidence interval for Y(X=0) by R-squared value (if it's possible).



    The only solution similar to what I need I've found in my coursebook is the way to find the confidence interval for distribution of the constant value measurement (mean of Y), which, I suppose, is not applicable to my problem.



    P.S. I can't get more than one value for each unique X because X is actually time. As time rises, the chemical reaction undergoes and electrical conductivity of the solution (which is Y) changes.










    share|cite|improve this question







    New contributor




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






















      up vote
      0
      down vote

      favorite









      up vote
      0
      down vote

      favorite











      From the physical experiment I've got a sample collection of values (unique Y for each unique X). The problem is to find the linear regresstion function of given values collection. Then, assuming that the model is correct, extrapolate found linear function to X=0 and find an appropriate Y value with the confidence interval.



      Using MS Excel I've got a graph like this with automatically calculated regression function equation and an R-squared value, which is good. The bad is that I couldn't understand how can I find a confidence interval for Y(X=0) by R-squared value (if it's possible).



      The only solution similar to what I need I've found in my coursebook is the way to find the confidence interval for distribution of the constant value measurement (mean of Y), which, I suppose, is not applicable to my problem.



      P.S. I can't get more than one value for each unique X because X is actually time. As time rises, the chemical reaction undergoes and electrical conductivity of the solution (which is Y) changes.










      share|cite|improve this question







      New contributor




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











      From the physical experiment I've got a sample collection of values (unique Y for each unique X). The problem is to find the linear regresstion function of given values collection. Then, assuming that the model is correct, extrapolate found linear function to X=0 and find an appropriate Y value with the confidence interval.



      Using MS Excel I've got a graph like this with automatically calculated regression function equation and an R-squared value, which is good. The bad is that I couldn't understand how can I find a confidence interval for Y(X=0) by R-squared value (if it's possible).



      The only solution similar to what I need I've found in my coursebook is the way to find the confidence interval for distribution of the constant value measurement (mean of Y), which, I suppose, is not applicable to my problem.



      P.S. I can't get more than one value for each unique X because X is actually time. As time rises, the chemical reaction undergoes and electrical conductivity of the solution (which is Y) changes.







      statistics linear-regression confidence-interval






      share|cite|improve this question







      New contributor




      impulsgraw 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




      impulsgraw 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




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









      asked 2 days ago









      impulsgraw

      1




      1




      New contributor




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





      New contributor





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






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



























          active

          oldest

          votes











          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',
          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
          });


          }
          });






          impulsgraw 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%2fmath.stackexchange.com%2fquestions%2f3005368%2fconfidence-interval-of-dependant-variable-individual-value-by-r-squared-value%23new-answer', 'question_page');
          }
          );

          Post as a guest















          Required, but never shown






























          active

          oldest

          votes













          active

          oldest

          votes









          active

          oldest

          votes






          active

          oldest

          votes








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










           

          draft saved


          draft discarded


















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













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












          impulsgraw 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%2fmath.stackexchange.com%2fquestions%2f3005368%2fconfidence-interval-of-dependant-variable-individual-value-by-r-squared-value%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

          Wiesbaden

          Marschland

          Dieringhausen