Валентин Юльевич Арьков

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


Скачать книгу

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

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

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

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

      Безопасно оплатить книгу можно банковской картой 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+Iz94kBXAAAAAAABIrnt6j7P23+2sBXAAAAAAABJf7qIf0J/02wFYAAfy44202p11aUIQRqUpR5Eki5TM+8A6sw60pdH7Fm8Z2H+HeKdFrdfpxOG9CjunrqJtWSzbNREThEfKaDPZt5NokujtUUAEiDtuSqnlyMxiz/0WArgAAAAAAAAAAAAADGMSO42d85j75Al6O2TFyCjkAAAAAASK9+fpP09HoLAVwAAAAAAASJXdRA5Paj/pIAVwAAAAAAASIR+uWpl/6eN/1gK4AAAAAAAJNA9nVNv+0HfRSArAAAAAADg+QBKtTufifuV6RgKwAAAAAAkXV+hHtpl27XJ/ESArgAAAAAAAkVz29R/pv9tYCuAAAAAAACS/3UQ/oT/ptgKwAAhX3azd8WRcNlPTXYbdfpUumKkNezZJ9pTZrT8Za2ZfuDn4fy84tDXsXWLWBWkZTsU7+vGgrotsOSHKeVMecW/PUtC20a6VISTSdVWsos1e58YD06AAEiB3R1X+FG/osBXAAAAAAAAAYRcmNWGNpYgW9hXX7sixrrulSipdM1VLdeJKVKNR6pGSE5IVkajIj1TIgXLmoEjSjwLh31Kw7mX2xHq8N96I+t6O8iIiQy0brrG+lJJk3UtkajQS9Ysj2bDCcpeO3yUjS40f63b1buiJfiG4NvsR5UzfMKQw8bEg9VhxppxBOPJcV2qDQlRKPYW0TVz6zXDbFOx8WqI/X7ErO/o0SW5AltuMOMPxZLeWu0604lK21FmR5KIthkfIYqfNftiR3GzvnM/fIEvQyUuQUcgAAAAACRXs93pP09HoLAVwAAAAAAASJXdRA2/sj/pIAVwAAAAAAASIfdNU/o8b+rgCuAAAAAAACTQPZ1T/ADB30UgKwAAAAAA4PkASrU7n4n7lemYCsAAAAAAJF1foR7+I194kBXAAAAAAABIrnt6jfTf7awFcAAAEu6LkpFnW3VLtuCTvemUaG9PmOkk1ajLSDWtWRbTyIj2EA1J0aeydYTaSWLqsI6XZ9coMyYl5dHlTFocROJolKNKko2tKNtJqIjMy2GWeeWYblAJL/dTD+hP+m2ArAAAAAAAAkQO6OrF//lG/osBXAAAAAAAAAa7aR9v4nV3FLCetWRhVJuCBZdfOuVCc1Uokc1Nqivx9xQl1ZKNRG6Sz5E5EffGduq6O0iNDG+Mb7tqN