Is it mathematically possible to calculate the total standard deviation of a daily list of numbers from their...












0












$begingroup$


Say I have the following list of numbers, each corresponding to a single day:



list = [1,   6,    7,    12,   5]


I can calculate the daily, rolling standard deviations between each as:



stds = [NaN, 3.54, 0.71, 3.54, 4.95]


Is it now possible to calculate the standard deviation across all values of list, using only the values of stds?






standard-deviation







share|cite|improve this question











$endgroup$












  • $begingroup$
    Not sure I understand the values in stds. The standard deviation of the values $1,2$ is not $3.54$, whether you divide by $n$ or by $n-1$. What exactly is the $3.54$? Also...regardless of what your numbers mean, why isn't the last term in stds the desired value for the entire list?
    $endgroup$
    – lulu
    Jan 16 at 13:09












  • $begingroup$
    @lulu Sorry, the second number was supposed to be 6, not 2. stds contains the standard deviations between each successive pair of numbers. The first value is blank, since there is no number before 1. The second value is std(1, 6), the third value is std(6, 7), etc.
    $endgroup$
    – KOB
    Jan 16 at 13:17










  • $begingroup$
    Ok, but then the answer is "obviously not". The list $[1,6,7,12,19]$ has the same pairwise standard deviations but not the same total standard deviation.
    $endgroup$
    – lulu
    Jan 16 at 13:22










  • $begingroup$
    Note that you can calculate standard deviation incrementally using just three stored values: the number of data observed, the sum of the data, and the sum of their squares. This seems to me a much more useful trick, since storing the list of "daily rolling standard deviations" takes about the same resources as storing the numbers themselves.
    $endgroup$
    – David K
    Jan 17 at 6:11












  • $begingroup$
    @DavidK unfortunately the only data I receive is the pairwise standard deviations, and this cannot be changed as of now.
    $endgroup$
    – KOB
    Jan 17 at 7:26
















0












$begingroup$


Say I have the following list of numbers, each corresponding to a single day:



list = [1,   6,    7,    12,   5]


I can calculate the daily, rolling standard deviations between each as:



stds = [NaN, 3.54, 0.71, 3.54, 4.95]


Is it now possible to calculate the standard deviation across all values of list, using only the values of stds?






standard-deviation







share|cite|improve this question











$endgroup$












  • $begingroup$
    Not sure I understand the values in stds. The standard deviation of the values $1,2$ is not $3.54$, whether you divide by $n$ or by $n-1$. What exactly is the $3.54$? Also...regardless of what your numbers mean, why isn't the last term in stds the desired value for the entire list?
    $endgroup$
    – lulu
    Jan 16 at 13:09












  • $begingroup$
    @lulu Sorry, the second number was supposed to be 6, not 2. stds contains the standard deviations between each successive pair of numbers. The first value is blank, since there is no number before 1. The second value is std(1, 6), the third value is std(6, 7), etc.
    $endgroup$
    – KOB
    Jan 16 at 13:17










  • $begingroup$
    Ok, but then the answer is "obviously not". The list $[1,6,7,12,19]$ has the same pairwise standard deviations but not the same total standard deviation.
    $endgroup$
    – lulu
    Jan 16 at 13:22










  • $begingroup$
    Note that you can calculate standard deviation incrementally using just three stored values: the number of data observed, the sum of the data, and the sum of their squares. This seems to me a much more useful trick, since storing the list of "daily rolling standard deviations" takes about the same resources as storing the numbers themselves.
    $endgroup$
    – David K
    Jan 17 at 6:11












  • $begingroup$
    @DavidK unfortunately the only data I receive is the pairwise standard deviations, and this cannot be changed as of now.
    $endgroup$
    – KOB
    Jan 17 at 7:26














0












0








0





$begingroup$


Say I have the following list of numbers, each corresponding to a single day:



list = [1,   6,    7,    12,   5]


I can calculate the daily, rolling standard deviations between each as:



stds = [NaN, 3.54, 0.71, 3.54, 4.95]


Is it now possible to calculate the standard deviation across all values of list, using only the values of stds?






standard-deviation







share|cite|improve this question











$endgroup$




Say I have the following list of numbers, each corresponding to a single day:



list = [1,   6,    7,    12,   5]


I can calculate the daily, rolling standard deviations between each as:



stds = [NaN, 3.54, 0.71, 3.54, 4.95]


Is it now possible to calculate the standard deviation across all values of list, using only the values of stds?






standard-deviation




standard-deviation






share|cite|improve this question















share|cite|improve this question













share|cite|improve this question




share|cite|improve this question








edited Jan 16 at 13:15







KOB

















asked Jan 16 at 12:56









KOBKOB

1919




1919












  • $begingroup$
    Not sure I understand the values in stds. The standard deviation of the values $1,2$ is not $3.54$, whether you divide by $n$ or by $n-1$. What exactly is the $3.54$? Also...regardless of what your numbers mean, why isn't the last term in stds the desired value for the entire list?
    $endgroup$
    – lulu
    Jan 16 at 13:09












  • $begingroup$
    @lulu Sorry, the second number was supposed to be 6, not 2. stds contains the standard deviations between each successive pair of numbers. The first value is blank, since there is no number before 1. The second value is std(1, 6), the third value is std(6, 7), etc.
    $endgroup$
    – KOB
    Jan 16 at 13:17










  • $begingroup$
    Ok, but then the answer is "obviously not". The list $[1,6,7,12,19]$ has the same pairwise standard deviations but not the same total standard deviation.
    $endgroup$
    – lulu
    Jan 16 at 13:22










  • $begingroup$
    Note that you can calculate standard deviation incrementally using just three stored values: the number of data observed, the sum of the data, and the sum of their squares. This seems to me a much more useful trick, since storing the list of "daily rolling standard deviations" takes about the same resources as storing the numbers themselves.
    $endgroup$
    – David K
    Jan 17 at 6:11












  • $begingroup$
    @DavidK unfortunately the only data I receive is the pairwise standard deviations, and this cannot be changed as of now.
    $endgroup$
    – KOB
    Jan 17 at 7:26


















  • $begingroup$
    Not sure I understand the values in stds. The standard deviation of the values $1,2$ is not $3.54$, whether you divide by $n$ or by $n-1$. What exactly is the $3.54$? Also...regardless of what your numbers mean, why isn't the last term in stds the desired value for the entire list?
    $endgroup$
    – lulu
    Jan 16 at 13:09












  • $begingroup$
    @lulu Sorry, the second number was supposed to be 6, not 2. stds contains the standard deviations between each successive pair of numbers. The first value is blank, since there is no number before 1. The second value is std(1, 6), the third value is std(6, 7), etc.
    $endgroup$
    – KOB
    Jan 16 at 13:17










  • $begingroup$
    Ok, but then the answer is "obviously not". The list $[1,6,7,12,19]$ has the same pairwise standard deviations but not the same total standard deviation.
    $endgroup$
    – lulu
    Jan 16 at 13:22










  • $begingroup$
    Note that you can calculate standard deviation incrementally using just three stored values: the number of data observed, the sum of the data, and the sum of their squares. This seems to me a much more useful trick, since storing the list of "daily rolling standard deviations" takes about the same resources as storing the numbers themselves.
    $endgroup$
    – David K
    Jan 17 at 6:11












  • $begingroup$
    @DavidK unfortunately the only data I receive is the pairwise standard deviations, and this cannot be changed as of now.
    $endgroup$
    – KOB
    Jan 17 at 7:26
















$begingroup$
Not sure I understand the values in stds. The standard deviation of the values $1,2$ is not $3.54$, whether you divide by $n$ or by $n-1$. What exactly is the $3.54$? Also...regardless of what your numbers mean, why isn't the last term in stds the desired value for the entire list?
$endgroup$
– lulu
Jan 16 at 13:09






$begingroup$
Not sure I understand the values in stds. The standard deviation of the values $1,2$ is not $3.54$, whether you divide by $n$ or by $n-1$. What exactly is the $3.54$? Also...regardless of what your numbers mean, why isn't the last term in stds the desired value for the entire list?
$endgroup$
– lulu
Jan 16 at 13:09














$begingroup$
@lulu Sorry, the second number was supposed to be 6, not 2. stds contains the standard deviations between each successive pair of numbers. The first value is blank, since there is no number before 1. The second value is std(1, 6), the third value is std(6, 7), etc.
$endgroup$
– KOB
Jan 16 at 13:17




$begingroup$
@lulu Sorry, the second number was supposed to be 6, not 2. stds contains the standard deviations between each successive pair of numbers. The first value is blank, since there is no number before 1. The second value is std(1, 6), the third value is std(6, 7), etc.
$endgroup$
– KOB
Jan 16 at 13:17












$begingroup$
Ok, but then the answer is "obviously not". The list $[1,6,7,12,19]$ has the same pairwise standard deviations but not the same total standard deviation.
$endgroup$
– lulu
Jan 16 at 13:22




$begingroup$
Ok, but then the answer is "obviously not". The list $[1,6,7,12,19]$ has the same pairwise standard deviations but not the same total standard deviation.
$endgroup$
– lulu
Jan 16 at 13:22












$begingroup$
Note that you can calculate standard deviation incrementally using just three stored values: the number of data observed, the sum of the data, and the sum of their squares. This seems to me a much more useful trick, since storing the list of "daily rolling standard deviations" takes about the same resources as storing the numbers themselves.
$endgroup$
– David K
Jan 17 at 6:11






$begingroup$
Note that you can calculate standard deviation incrementally using just three stored values: the number of data observed, the sum of the data, and the sum of their squares. This seems to me a much more useful trick, since storing the list of "daily rolling standard deviations" takes about the same resources as storing the numbers themselves.
$endgroup$
– David K
Jan 17 at 6:11














$begingroup$
@DavidK unfortunately the only data I receive is the pairwise standard deviations, and this cannot be changed as of now.
$endgroup$
– KOB
Jan 17 at 7:26




$begingroup$
@DavidK unfortunately the only data I receive is the pairwise standard deviations, and this cannot be changed as of now.
$endgroup$
– KOB
Jan 17 at 7:26










1 Answer
1






active

oldest

votes


















1












$begingroup$

The rolling pairwise standard deviations don't give you enough information to get the total standard deviation. The two lists $$[0,1,0,1]quad &quad [0,1,2,3]$$ both have the pairwise standard deviations $$Big[frac 1{sqrt 2},,frac 1{sqrt 2},,frac 1{sqrt 2}Big]$$



But the total standard deviation of the first is $.577$ and the standard deviation of the second is $1.29$.



Note: in all cases we are using the sample standard deviation (i.e. we divide by $n-1$ not $n$).






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%2f3075692%2fis-it-mathematically-possible-to-calculate-the-total-standard-deviation-of-a-dai%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$

    The rolling pairwise standard deviations don't give you enough information to get the total standard deviation. The two lists $$[0,1,0,1]quad &quad [0,1,2,3]$$ both have the pairwise standard deviations $$Big[frac 1{sqrt 2},,frac 1{sqrt 2},,frac 1{sqrt 2}Big]$$



    But the total standard deviation of the first is $.577$ and the standard deviation of the second is $1.29$.



    Note: in all cases we are using the sample standard deviation (i.e. we divide by $n-1$ not $n$).






    share|cite|improve this answer









    $endgroup$


















      1












      $begingroup$

      The rolling pairwise standard deviations don't give you enough information to get the total standard deviation. The two lists $$[0,1,0,1]quad &quad [0,1,2,3]$$ both have the pairwise standard deviations $$Big[frac 1{sqrt 2},,frac 1{sqrt 2},,frac 1{sqrt 2}Big]$$



      But the total standard deviation of the first is $.577$ and the standard deviation of the second is $1.29$.



      Note: in all cases we are using the sample standard deviation (i.e. we divide by $n-1$ not $n$).






      share|cite|improve this answer









      $endgroup$
















        1












        1








        1





        $begingroup$

        The rolling pairwise standard deviations don't give you enough information to get the total standard deviation. The two lists $$[0,1,0,1]quad &quad [0,1,2,3]$$ both have the pairwise standard deviations $$Big[frac 1{sqrt 2},,frac 1{sqrt 2},,frac 1{sqrt 2}Big]$$



        But the total standard deviation of the first is $.577$ and the standard deviation of the second is $1.29$.



        Note: in all cases we are using the sample standard deviation (i.e. we divide by $n-1$ not $n$).






        share|cite|improve this answer









        $endgroup$



        The rolling pairwise standard deviations don't give you enough information to get the total standard deviation. The two lists $$[0,1,0,1]quad &quad [0,1,2,3]$$ both have the pairwise standard deviations $$Big[frac 1{sqrt 2},,frac 1{sqrt 2},,frac 1{sqrt 2}Big]$$



        But the total standard deviation of the first is $.577$ and the standard deviation of the second is $1.29$.



        Note: in all cases we are using the sample standard deviation (i.e. we divide by $n-1$ not $n$).







        share|cite|improve this answer












        share|cite|improve this answer



        share|cite|improve this answer










        answered Jan 16 at 13:28









        lulululu

        43.3k25080




        43.3k25080






























            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%2f3075692%2fis-it-mathematically-possible-to-calculate-the-total-standard-deviation-of-a-dai%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

            Human spaceflight

            Image
            Human spaceflight From Wikipedia, the free encyclopedia Jump to navigation Jump to search "Space traveler" redirects here. For other uses, see Space traveler (disambiguation). @media all and (max-width:720px){.mw-parser-output .tmulti>.thumbinner{width:100%!important;max-width:none!important}.mw-parser-output .tmulti .tsingle{float:none!important;max-width:none!important;width:100%!important;text-align:center}} Apollo 11 crewmember Buzz Aldrin on the Moon, 1969 International Space Station crewmember Tracy Caldwell Dyson views the Earth, 2010 Space Shuttle Discovery heads into space with a crew aboard, STS-121 in 2006 Inside a space suit on the Canadarm, 1993 Human spaceflight (also referred to as crewed spaceflight or manned spaceflight ) is space travel with a crew or passengers aboard the spacecraft. Spacecraft carrying people may be operated directly, by human crew, or it may be e...
            Read more

            Can not write log (Is /dev/pts mounted?) - openpty in Ubuntu-on-Windows?

            Image
            0 1 What exactly does the error message beginning with E: mean? I assume it has to do with the file structure on Ubuntu-on-Windows, but what exactly? The following package was automatically installed and is no longer required: os-prober Use 'apt-get autoremove' to remove it. The following extra packages will be installed: libxslt1.1 The following NEW packages will be installed: libxslt1.1 xmlstarlet 0 upgraded, 2 newly installed, 0 to remove and 0 not upgraded. Need to get 435 kB of archives. After this operation, 1023 kB of additional disk space will be used. Get:1 http://archive.ubuntu.com/ubuntu/ trusty/main libxslt1.1 amd64 1.1.28-2build1 [145 kB] Get:2 http://archive.ubuntu.com/ubuntu/ trusty/universe xmlstarlet amd64 1.5.0-1 [290 kB] ...
            Read more

            張江高科駅

            Image
            張江高科駅 ちょうこうこうか Zhangjiang Hi-Tech Park 所在地 中国上海市浦東新区 所属事業者 上海地鉄運営有限公司（上海軌道交通・駅詳細） 上海浦東現代有軌交通有限公司（駅詳細） テンプレートを表示 張江高科駅 各種表記 繁体字： 張江高科站 簡体字： 张江高科站 拼音 ： Zhàngjiāng Gāokē Zhàn 発音： ヂャンジャン ガオクー ヂャン 英文： Zhangjiang Hi-Tech Park Station テンプレートを表示 張江高科駅 （ちょうこうこうか-えき）は中華人民共和国上海市浦東新区に位置する、上海軌道交通2号線の駅である。 なお、張江高科駅前にある張江軌道電車の 張江地鉄駅駅 についてもここで述べる。 目次 1 利用可能な鉄道路線 2 沿革 3 駅構造 3.1 上海軌道交通 3.2 張江軌道電車 4 駅周辺 5 隣の駅 6 注釈 7 関連項目 利用可能な鉄道路線 上海軌道交通 ■ 2号線 上海浦東現代有軌交通有限公司 ■ 張江軌道電車 沿革 高架駅時代の姿 2000年12月27日 - 2号線の駅が高架駅として開業。 2010年 1月1日 - 張江軌道電車の開業に伴い、張江地鉄駅駅（停留所）を設置。 2月13日 - 駅地下化に伴い高架駅の運用停止。 2月24日 - 10日間の閉鎖を経て地下新駅の開業。 2017年2月9日 - リニューアル工事を経て再開業。乗降客の増加に対応し、ホームへのエレベーター、エスカレーターを増設、券売機エリアを拡張した [1] 。 駅構造 上海軌道交通 上海軌道交通 張江高科駅 5号口 ちょうこうこうか Zhangjiang Hi-Tech Park ◄ 竜陽路 (2.60km) (1.61km) 金科路 ► 所在地 中国上海市浦東新区松涛路 祖冲之路 （中国語版） 北緯31度12分11秒 東経121度34分50秒  /  北緯31.2...
            Read more