Статистический анализ взаимосвязи в Excel. Учебное пособие. Валентин Юльевич Арьков

Чтение книги онлайн.

СКАЧАТЬ Когда мы строим разброс вокруг линии, в роли среднего значения будет точка на линии.

      В нулевом варианте случайный разброс равен 50 · Е. Случайная составляющая Е имеет единичную дисперсию. Сигма Е тоже будет равна единице, потому что сигма – это квадратный корень из дисперсии. Если умножить случайную величину Е на 50, то её сигма тоже увечивается в 50 раз. Стало быть, сигма равна 50, а три сигмы равно

      3 · 50 = 150.

      Вокруг первой и последней точек на графике строим разброс «плюс-минус три сигмы».

      Конец ознакомительного фрагмента.

      Текст предоставлен ООО «ЛитРес».

      Прочитайте эту книгу целиком, купив полную легальную версию на ЛитРес.

      Безопасно оплатить книгу можно банковской картой Visa, MasterCard, Maestro, со счета мобильного телефона, с платежного терминала, в салоне МТС или Связной, через PayPal, WebMoney, Яндекс.Деньги, QIWI Кошелек, бонусными картами или другим удобным Вам способом.

/9j/4AAQSkZJRgABAQAAAQABAAD/4gxYSUNDX1BST0ZJTEUAAQEAAAxITGlubwIQAABtbnRyUkdCIFhZWiAHzgACAAkABgAxAABhY3NwTVNGVAAAAABJRUMgc1JHQgAAAAAAAAAAAAAAAAAA9tYAAQAAAADTLUhQICAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAABFjcHJ0AAABUAAAADNkZXNjAAABhAAAAGx3dHB0AAAB8AAAABRia3B0AAACBAAAABRyWFlaAAACGAAAABRnWFlaAAACLAAAABRiWFlaAAACQAAAABRkbW5kAAACVAAAAHBkbWRkAAACxAAAAIh2dWVkAAADTAAAAIZ2aWV3AAAD1AAAACRsdW1pAAAD+AAAABRtZWFzAAAEDAAAACR0ZWNoAAAEMAAAAAxyVFJDAAAEPAAACAxnVFJDAAAEPAAACAxiVFJDAAAEPAAACAx0ZXh0AAAAAENvcHlyaWdodCAoYykgMTk5OCBIZXdsZXR0LVBhY2thcmQgQ29tcGFueQAAZGVzYwAAAAAAAAASc1JHQiBJRUM2MTk2Ni0yLjEAAAAAAAAAAAAAABJzUkdCIElFQzYxOTY2LTIuMQAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAWFlaIAAAAAAAAPNRAAEAAAABFsxYWVogAAAAAAAAAAAAAAAAAAAAAFhZWiAAAAAAAABvogAAOPUAAAOQWFlaIAAAAAAAAGKZAAC3hQAAGNpYWVogAAAAAAAAJKAAAA+EAAC2z2Rlc2MAAAAAAAAAFklFQyBodHRwOi8vd3d3LmllYy5jaAAAAAAAAAAAAAAAFklFQyBodHRwOi8vd3d3LmllYy5jaAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAABkZXNjAAAAAAAAAC5JRUMgNjE5NjYtMi4xIERlZmF1bHQgUkdCIGNvbG91ciBzcGFjZSAtIHNSR0IAAAAAAAAAAAAAAC5JRUMgNjE5NjYtMi4xIERlZmF1bHQgUkdCIGNvbG91ciBzcGFjZSAtIHNSR0IAAAAAAAAAAAAAAAAAAAAAAAAAAAAAZGVzYwAAAAAAAAAsUmVmZXJlbmNlIFZpZXdpbmcgQ29uZGl0aW9uIGluIElFQzYxOTY2LTIuMQAAAAAAAAAAAAAALFJlZmVyZW5jZSBWaWV3aW5nIENvbmRpdGlvbiBpbiBJRUM2MTk2Ni0yLjEAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAHZpZXcAAAAAABOk/gAUXy4AEM8UAAPtzAAEEwsAA1yeAAAAAVhZWiAAAAAAAEwJVgBQAAAAVx/nbWVhcwAAAAAAAAABAAAAAAAAAAAAAAAAAAAAAAAAAo8AAAACc2lnIAAAAABDUlQgY3VydgAAAAAAAAQAAAAABQAKAA8AFAAZAB4AIwAoAC0AMgA3ADsAQABFAEoATwBUAFkAXgBjAGgAbQByAHcAfACBAIYAiwCQAJUAmgCfAKQAqQCuALIAtwC8AMEAxgDLANAA1QDbAOAA5QDrAPAA9gD7AQEBBwENARMBGQEfASUBKwEyATgBPgFFAUwBUgFZAWABZwFuAXUBfAGDAYsBkgGaAaEBqQGxAbkBwQHJAdEB2QHhAekB8gH6AgMCDAIUAh0CJgIvAjgCQQJLAlQCXQJnAnECegKEAo4CmAKiAqwCtgLBAssC1QLgAusC9QMAAwsDFgMhAy0DOANDA08DWgNmA3IDfgOKA5YDogOuA7oDxwPTA+AD7AP5BAYEEwQgBC0EOwRIBFUEYwRxBH4EjASaBKgEtgTEBNME4QTwBP4FDQUcBSsFOgVJBVgFZwV3BYYFlgWmBbUFxQXVBeUF9gYGBhYGJwY3BkgGWQZqBnsGjAadBq8GwAbRBuMG9QcHBxkHKwc9B08HYQd0B4YHmQesB78H0gflB/gICwgfCDIIRghaCG4IggiWCKoIvgjSCOcI+wkQCSUJOglPCWQJeQmPCaQJugnPCeUJ+woRCicKPQpUCmoKgQqYCq4KxQrcCvMLCwsiCzkLUQtpC4ALmAuwC8gL4Qv5DBIMKgxDDFwMdQyODKcMwAzZDPMNDQ0mDUANWg10DY4NqQ3DDd4N+A4TDi4OSQ5kDn8Omw62DtIO7g8JDyUPQQ9eD3oPlg+zD88P7BAJECYQQxBhEH4QmxC5ENcQ9RETETERTxFtEYwRqhHJEegSBxImEkUSZBKEEqMSwxLjEwMTIxNDE2MTgxOkE8UT5RQGFCcUSRRqFIsUrRTOFPAVEhU0FVYVeBWbFb0V4BYDFiYWSRZsFo8WshbWFvoXHRdBF2UXiReuF9IX9xgbGEAYZRiKGK8Y1Rj6GSAZRRlrGZEZtxndGgQaKhpRGncanhrFGuwbFBs7G2MbihuyG9ocAhwqHFIcexyjHMwc9R0eHUcdcB2ZHcMd7B4WHkAeah6UHr4e6R8THz4faR+UH78f6iAVIEEgbCCYIMQg8CEcIUghdSGhIc4h+yInIlUigiKvIt0jCiM4I2YjlCPCI/AkHyRNJHwkqyTaJQklOCVoJZclxyX3JicmVyaHJrcm6CcYJ0kneierJ9woDSg/KHEooijUKQYpOClrKZ0p0CoCKjUqaCqbKs8rAis2K2krnSvRLAUsOSxuLKIs1y0MLUEtdi2rLeEuFi5MLoIuty7uLyQvWi+RL8cv/jA1MGwwpDDbMRIxSjGCMbox8jIqMmMymzLUMw0zRjN/M7gz8TQrNGU0njTYNRM1TTWHNcI1/TY3NnI2rjbpNyQ3YDecN9c4FDhQOIw4yDkFOUI5fzm8Ofk6Njp0OrI67zstO2s7qjvoPCc8ZTykPOM9Ij1hPaE94D4gPmA+oD7gPyE/YT+iP+JAI0BkQKZA50EpQWpBrEHuQjBCckK1QvdDOkN9Q8BEA0RHRIpEzkUSRVVFmkXeRiJGZ0arRvBHNUd7R8BIBUhLSJFI10kdSWNJqUnwSjdKfUrESwxLU0uaS+JMKkxyTLpNAk1KTZNN3E4lTm5Ot08AT0lPk0/dUCdQcVC7UQZRUFGbUeZSMVJ8UsdTE1NfU6pT9lRCVI9U21UoVXVVwlYPVlxWqVb3V0RXklfgWC9YfVjLWRpZaVm4WgdaVlqmWvVbRVuVW+VcNVyGXNZdJ114XcleGl5sXr1fD19hX7NgBWBXYKpg/GFPYaJh9WJJYpxi8GNDY5dj62RAZJRk6WU9ZZJl52Y9ZpJm6Gc9Z5Nn6Wg/aJZo7GlDaZpp8WpIap9q92tPa6dr/2xXbK9tCG1gbbluEm5rbsRvHm94b9FwK3CGcOBxOnGVcfByS3KmcwFzXXO4dBR0cHTMdSh1hXXhdj52m3b4d1Z3s3gReG54zHkqeYl553pGeqV7BHtje8J8IXyBfOF9QX2hfgF+Yn7CfyN/hH/lgEeAqIEKgWuBzYIwgpKC9INXg7qEHYSAhOOFR4Wrhg6GcobXhzuHn4gEiGmIzokziZmJ/opkisqLMIuWi/yMY4zKjTGNmI3/jmaOzo82j56QBpBukNaRP5GokhGSepLjk02TtpQglIqU9JVflcmWNJaflwqXdZfgmEyYuJkkmZCZ/JpomtWbQpuvnByciZz3nWSd0p5Anq6fHZ+Ln/qgaaDYoUehtqImopajBqN2o+akVqTHpTilqaYapoum/adup+CoUqjEqTepqaocqo+rAqt1q+msXKzQrUStuK4trqGvFq+LsACwdbDqsWCx1rJLssKzOLOutCW0nLUTtYq2AbZ5tvC3aLfguFm40blKucK6O7q1uy67p7whvJu9Fb2Pvgq+hL7/v3q/9cBwwOzBZ8Hjwl/C28NYw9TEUcTOxUvFyMZGxsPHQce/yD3IvMk6ybnKOMq3yzbLtsw1zLXNNc21zjbOts83z7jQOdC60TzRvtI/0sHTRNPG1EnUy9VO1dHWVdbY11zX4Nhk2OjZbNnx2nba+9uA3AXcit0Q3ZbeHN6i3ynfr+A24L3hROHM4lPi2+Nj4+vkc+T85YTmDeaW5x/nqegy6LzpRunQ6lvq5etw6/vshu0R7ZzuKO6070DvzPBY8OXxcvH/8ozzGfOn9DT0wvVQ9d72bfb794r4Gfio+Tj5x/pX+uf7d/wH/Jj9Kf26/kv+3P9t////2wBDAAMCAgICAgMCAgIDAwMDBAYEBAQEBAgGBgUGCQgKCgkICQkKDA8MCgsOCwkJDRENDg8QEBEQCgwSExIQEw8QEBD/2wBDAQMDAwQDBAgEBAgQCwkLEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBD/wAARCAGJAk8DAREAAhEBAxEB/8QAHgABAQACAwEBAQEAAAAAAAAAAAUGCAEHCQQDAgr/xABdEAAABQICAwgJDwoDBQgDAQAAAQIDBAUGBxEIEiETFBUWMZTR0gkiNkFUVVajshcmMjRRUlNhZXJ0kZOz0yMzNUJEcXOiscMkdYFFYoKhwhglQ0Zkg4TBGZLhY//EABcBAQEBAQAAAAAAAAAAAAAAAAABAgP/xAAmEQEBAQACAwACAQQDAQAAAAAAAREhMQISQVFhcSKBofATMtHB/9oADAMBAAIRAxEAPwD1TAAAAAdYYiaRWHOFt0RLYvAq5H3ycZL1SapD7tOhKkObmwmRJSnUbNayyLb+/LMg+4vrxr9ZGkThNExAr2Gk25FRqxbNFdr9UU/FdbjR4bSiJxW7KSSFGnWSZkkzyJRAjE6VppYFVK3K1cb9TrNLTRIsSccGpUh6NNmxpatSI7FYUWu+l5ZklGqWZqPI8gm1q+OWcuwsLMXLOxgo02r2m7Nacpc1ym1Kn1CKuLNgSkZazT7K+2QrIyUWewyMjIE8p63GaAgAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAADXDSKs7HjEHEW16LR7GpNfwspTzFUqsFVfTAkVSc25rNIe1ml5x2jJLmoWRrWlOZkRBZ1jXGfti2OuCONWMOMVecZsykwbSrFh1GxkVZVfSb7e+XW30yzjE1nqpW3qG3rZmR5594T7sSeV8bvj2xC4dFrHzEiswMWLooFtUS6rFptvwLeoseq74jVVdPllIeW+9uSdyS7lqtpMlbme08wu279Xx8r4+N8Z9d+6OWGF52fU8Q8RMQ4MCl1/Ee4E1d6kwJRSWaew0whhlvdiQjdXDSg1KVqkRmoi7wu29pfK2ZXZV+y5UG1J0mHIcYdTuSUuIMyUnNxJHkZfEZieXSPq4uRPDqnz53pFDi3E8OqfPnekA4txPDqnz53pAOLcTw6p8+d6QDi3E8OqfPnekA4uRPDqnz53pAT6rRm4r0BLNQqZE/LS05/jXdqTSo8uXZyEAocXInh1T5870gHFyJ4dUufO9IBxbieHVPnzvSAcW4nh1T5870gHFuJ4dU+fO9IBxcieHVPnzvSAnv0ZtFdiQ01Cpky6w84pO/nNqkmjLv8AxmAocW4nh1T5870gHFuJ4dU+fO9IBxbieHVPnzvSAcW4nh1T5870gHFuJ4dU+fO9IBxbieHVPnzvSAnxqO25W5sJVRqRtMMsqQnfrmw1a+ff+IgFDi3E8OqfPnekA4txPDqnz53pAOLkTw6p8+d6QDi5E8OqXPnekA4txPDqnz53pAOLcTw6p8+d6QE+kUZqUqcT1RqStwmLaR/jXNiSJORcvxgKHFuJ4dU+fO9IBxbieHVPnzvSAcW4nh1T5870gHFyJ4dU+fO9IBxbieHVPnzvSAHbcTL29U+fO9ICfQKM3Oo8eVJqNSU44R6yt+uFn2xl7oChxcieHVPnzvSAcW4nh1T5870gHFuJ4dU+fO9IBxbieHVPnzvSAcW4nh1T5870gJ9eo7cGmOSo9RqaXErbIj344eWa0kff9wzAUOLcTw6p8+d6QDi3E8OqfPnekA4uRPDqnz53pAOLkTw6p8+d6QDi3E8OqfPnekA4txPDqnz53pAT6pRm40qnNs1GppTIlbm5/jXNqdRR5cvukQChxbieHVPnzvSAcXInh1S5870gHFyJ4dUufO9IBxcieHVPnzvSAcW4nh1T5870gHFuJ4dUufO9ID4HaM2muxoSahUtxcjOuKTv1z2SVIIj5f8AeMB9/FyJ4dUufO9IBxbieHVPnzvSAcW4nh1T5870gHFyJ4dU+fO9IBxbieHVLnzvSAcW4nh1S5870gPzo7S4lWqMEpEh1lpDC0E86pwyNRKz2qPPvEAtAAAAAAAAAAAAAADGcR+46d85n75Al6GSlyCjkAAAAAASK9lu9JzL9vR6CwFcAAAAAAAEiV3UQOT2o/8Av9kgBXAAAAAAABIhd0tT2n7Xjf8AWArgAAAAAAAk0D2dU/zB30UgKwAAAAAA4PkASrU7n4nzVekYCsAAAAAAJF1foR7+Iz94kBXAAAA СКАЧАТЬ