Главная страница Случайная страница
КАТЕГОРИИ:
АвтомобилиАстрономияБиологияГеографияДом и садДругие языкиДругоеИнформатикаИсторияКультураЛитератураЛогикаМатематикаМедицинаМеталлургияМеханикаОбразованиеОхрана трудаПедагогикаПолитикаПравоПсихологияРелигияРиторикаСоциологияСпортСтроительствоТехнологияТуризмФизикаФилософияФинансыХимияЧерчениеЭкологияЭкономикаЭлектроника
Висновок. Оскільки – робимо висновок, що в масиві змінних існує мультиколінеарний зв'язок.
|
|
Оскільки 
– робимо висновок, що в масиві змінних існує мультиколінеарний зв'язок.
t12 > tтабл – між змінними Х1 і X2 (продуктивністю праці та чисельністю працівників) існує мультиколінеарність.
t13 > tтабл – між змінними Х1 і X3 (продуктивністю праці та фондовіддачею) існує мультиколінеарність.
А це означає, що метод найменших квадратів застосувати в цьому разі не можна.
Додаток 7
Вихідні дані для лабораторної роботи № 8
| Варіант 1 | Варіант 2 | Варіант 3 | Варіант 4 | Варіант 5 | |||||||||||||||||||
| x1 | x2 | x3 | Y | x1 | x2 | x3 | Y | x1 | x2 | x3 | Y | x1 | x2 | x3 | Y | x1 | x2 | x3 | Y | ||||
| 21, 1 | 90, 3 | 5, 7 | 300, 7 | 23, 1 | 90, 0 | 5, 8 | 24, 2 | 90, 7 | 5, 6 | 301, 1 | 20, 5 | 90, 0 | 5, 8 | 401, 8 | 23, 1 | 90, 8 | 5, 8 | 301, 1 | |||||
| 24, 2 | 92, 6 | 5, 8 | 25, 0 | 90, 2 | 6, 0 | 303, 1 | 26, 8 | 94, 3 | 5, 8 | 301, 8 | 21, 9 | 90, 2 | 5, 9 | 25, 0 | 93, 0 | 6, 0 | 301, 8 | ||||||
| 25, 9 | 93, 5 | 5, 8 | 303, 2 | 27, 0 | 90, 3 | 6, 1 | 303, 5 | 29, 9 | 95, 9 | 6, 0 | 304, 4 | 22, 1 | 90, 3 | 5, 8 | 400, 7 | 27, 0 | 94, 2 | 6, 1 | 304, 4 | ||||
| 26, 6 | 93, 8 | 5, 9 | 305, 2 | 28, 7 | 90, 8 | 6, 1 | 305, 4 | 32, 3 | 96, 1 | 6, 1 | 304, 9 | 22, 2 | 90, 8 | 5, 8 | 398, 3 | 28, 7 | 94, 6 | 6, 1 | 304, 9 | ||||
| 26, 7 | 95, 2 | 5, 9 | 305, 9 | 29, 8 | 92, 4 | 6, 3 | 33, 6 | 97, 7 | 6, 2 | 305, 4 | 22, 6 | 92, 4 | 5, 8 | 397, 6 | 29, 8 | 97, 2 | 6, 3 | 305, 4 | |||||
| 27, 1 | 97, 9 | 6, 0 | 306, 1 | 30, 3 | 94, 0 | 6, 6 | 307, 8 | 33, 7 | 100, 3 | 6, 3 | 305, 8 | 23, 6 | 94, 0 | 6, 0 | 394, 9 | 30, 3 | 97, 3 | 6, 6 | 305, 8 | ||||
| 28, 1 | 98, 3 | 6, 1 | 306, 9 | 30, 3 | 95, 1 | 6, 6 | 33, 6 | 100, 7 | 6, 6 | 306, 7 | 24, 2 | 95, 1 | 5, 9 | 30, 3 | 99, 1 | 6, 6 | 306, 7 | ||||||
| 28, 6 | 99, 0 | 8, 3 | 307, 7 | 30, 4 | 98, 4 | 8, 8 | 33, 7 | 99, 7 | 6, 7 | 309, 1 | 24, 5 | 98, 4 | 9, 5 | 307, 7 | 30, 4 | 99, 9 | 8, 8 | 309, 1 | |||||
| 29, 2 | 101, 1 | 8, 4 | 30, 5 | 99, 4 | 8, 9 | 393, 9 | 32, 1 | 102, 4 | 6, 8 | 393, 1 | 27, 5 | 99, 4 | 9, 6 | 306, 9 | 30, 5 | 101, 5 | 8, 9 | 393, 1 | |||||
| 29, 6 | 101, 8 | 8, 4 | 394, 9 | 30, 8 | 101, 4 | 9, 2 | 395, 3 | 31, 9 | 102, 0 | 7, 2 | 395, 7 | 28, 5 | 101, 4 | 9, 5 | 306, 1 | 30, 8 | 101, 7 | 9, 2 | 395, 7 | ||||
| 30, 4 | 102, 2 | 8, 5 | 397, 6 | 32, 0 | 104, 4 | 9, 3 | 397, 5 | 33, 7 | 101, 0 | 7, 9 | 398, 1 | 28, 6 | 104, 4 | 9, 2 | 305, 9 | 32, 0 | 103, 1 | 9, 3 | 398, 1 | ||||
| 31, 4 | 103, 0 | 8, 5 | 398, 3 | 33, 9 | 104, 5 | 9, 3 | 397, 7 | 35, 8 | 102, 4 | 8, 1 | 399, 2 | 29, 8 | 104, 5 | 9, 0 | 305, 2 | 33, 9 | 104, 2 | 9, 3 | 399, 2 | ||||
| 31, 4 | 104, 3 | 8, 7 | 400, 7 | 36, 2 | 104, 7 | 9, 3 | 398, 2 | 38, 5 | 105, 5 | 8, 3 | 399, 5 | 30, 3 | 104, 7 | 9, 2 | 303, 2 | 36, 2 | 108, 6 | 9, 3 | 399, 5 | ||||
| 33, 6 | 110, 0 | 9, 2 | 38, 1 | 106, 4 | 9, 4 | 400, 6 | 38, 3 | 112, 2 | 8, 6 | 400, 2 | 35, 6 | 106, 4 | 9, 7 | 38, 1 | 109, 4 | 9, 4 | 400, 2 | ||||||
| 34, 8 | 118, 4 | 9, 2 | 401, 8 | 39, 5 | 110, 0 | 9, 5 | 403, 1 | 38, 9 | 122, 8 | 8, 7 | 401, 8 | 38, 1 | 110, 0 | 9, 6 | 300, 7 | 39, 5 | 114, 7 | 9, 5 | 401, 8 |
Продовження додатку 7
| Варіант 6 | Варіант 7 | Варіант 8 | Варіант 9 | Варіант 10 | |||||||||||||||||||
| x1 | x2 | x3 | Y | x1 | x2 | x3 | Y | x1 | x2 | x3 | Y | x1 | x2 | x3 | Y | x1 | x2 | x3 | Y | ||||
| 20, 0 | 90, 0 | 6, 1 | 301, 1 | 21, 1 | 90, 0 | 5, 6 | 300, 7 | 25, 6 | 90, 8 | 6, 2 | 21, 1 | 90, 0 | 5, 8 | 301, 1 | 23, 1 | 5, 8 | 401, 8 | ||||||
| 15, 0 | 90, 2 | 6, 2 | 301, 8 | 24, 2 | 90, 2 | 5, 8 | 25, 0 | 93, 0 | 6, 2 | 303, 1 | 24, 2 | 90, 2 | 6, 0 | 301, 8 | 90, 2 | ||||||||
| 20, 0 | 90, 3 | 5, 8 | 304, 4 | 25, 9 | 90, 3 | 6, 0 | 303, 2 | 27, 0 | 94, 2 | 6, 1 | 303, 5 | 25, 9 | 90, 3 | 6, 1 | 304, 4 | 90, 3 | 6, 1 | 400, 7 | |||||
| 32, 3 | 90, 8 | 6, 0 | 304, 9 | 26, 6 | 90, 8 | 6, 1 | 305, 2 | 28, 7 | 94, 6 | 5, 2 | 305, 4 | 26, 6 | 90, 8 | 6, 1 | 304, 9 | 28, 7 | 90, 8 | 6, 1 | 398, 3 | ||||
| 33, 6 | 92, 4 | 6, 2 | 305, 4 | 26, 7 | 92, 4 | 6, 2 | 305, 9 | 29, 8 | 98, 2 | 6, 3 | 26, 7 | 92, 4 | 6, 3 | 305, 4 | 29, 8 | 92, 4 | 6, 3 | 397, 6 | |||||
| 33, 7 | 94, 0 | 5, 0 | 305, 8 | 27, 1 | 94, 0 | 6, 3 | 306, 1 | 22, 3 | 97, 3 | 5, 4 | 307, 8 | 27, 1 | 94, 0 | 6, 6 | 305, 8 | 30, 3 | 6, 6 | 394, 9 | |||||
| 34, 5 | 95, 1 | 6, 6 | 306, 7 | 28, 1 | 95, 1 | 6, 6 | 306, 9 | 16, 3 | 100, 2 | 6, 6 | 28, 1 | 95, 1 | 6, 6 | 306, 7 | 30, 3 | 95, 1 | 6, 6 | ||||||
| 33, 7 | 98, 4 | 6, 4 | 309, 1 | 28, 6 | 98, 4 | 6, 7 | 307, 7 | 22, 6 | 99, 9 | 8, 8 | 28, 6 | 98, 4 | 8, 8 | 309, 1 | 30, 4 | 98, 4 | 8, 8 | 307, 7 | |||||
| 32, 1 | 99, 4 | 6, 8 | 393, 1 | 29, 2 | 99, 4 | 6, 8 | 15, 8 | 105, 0 | 6, 5 | 393, 9 | 29, 2 | 99, 4 | 8, 9 | 393, 1 | 30, 5 | 99, 4 | 8, 9 | 306, 9 | |||||
| 31, 9 | 98, 0 | 7, 2 | 395, 7 | 29, 6 | 101, 4 | 7, 2 | 394, 9 | 30, 8 | 101, 7 | 9, 2 | 395, 3 | 29, 6 | 101, 4 | 9, 2 | 395, 7 | 30, 8 | 9, 2 | 306, 1 | |||||
| 33, 7 | 92, 0 | 7, 9 | 398, 1 | 30, 4 | 104, 4 | 7, 9 | 397, 6 | 17, 0 | 99, 5 | 9, 6 | 397, 5 | 30, 4 | 104, 4 | 9, 3 | 398, 1 | 104, 4 | 9, 3 | 305, 9 | |||||
| 35, 0 | 94, 2 | 8, 1 | 399, 2 | 31, 4 | 104, 5 | 8, 1 | 398, 3 | 18, 9 | 102, 0 | 9, 9 | 397, 7 | 31, 4 | 104, 5 | 9, 3 | 399, 2 | 33, 9 | 104, 5 | 9, 3 | 305, 2 | ||||
| 38, 5 | 93, 0 | 8, 0 | 399, 5 | 31, 4 | 104, 7 | 8, 3 | 400, 7 | 22, 3 | 98, 0 | 9, 5 | 398, 2 | 31, 4 | 104, 7 | 9, 3 | 399, 5 | 36, 2 | 104, 7 | 9, 3 | 303, 2 | ||||
| 38, 3 | 98, 8 | 8, 0 | 400, 2 | 33, 6 | 106, 4 | 8, 6 | 30, 6 | 110, 0 | 8, 9 | 400, 6 | 33, 6 | 106, 4 | 9, 4 | 400, 2 | 38, 1 | 106, 4 | 9, 4 | ||||||
| 38, 9 | 110, 0 | 8, 7 | 401, 8 | 34, 8 | 110, 0 | 8, 7 | 401, 8 | 32, 0 | 100, 0 | 9, 9 | 403, 1 | 34, 8 | 110, 0 | 9, 5 | 401, 8 | 39, 5 | 9, 5 | 300, 7 |
Продовження додатку 7
| Варіант 11 | Варіант 12 | Варіант 13 | Варіант 14 | Варіант 15 | |||||||||||||||||||
| x1 | x2 | x3 | Y | x1 | x2 | x3 | Y | x1 | x2 | x3 | Y | x1 | x2 | x3 | Y | x1 | x2 | x3 | Y | ||||
| 21, 1 | 8, 5 | 403, 1 | 20, 5 | 5, 8 | 401, 8 | 22, 7 | 90, 3 | 7, 5 | 300, 7 | 38, 1 | 114, 7 | 9, 5 | 23, 1 | 90, 3 | 6, 2 | 301, 1 | |||||||
| 24, 2 | 5, 8 | 400, 6 | 21, 9 | 90, 2 | 400, 2 | 24, 2 | 5, 8 | 35, 6 | 109, 4 | 9, 4 | 303, 1 | 118, 4 | 5, 8 | 301, 8 | |||||||||
| 25, 9 | 398, 2 | 22, 1 | 90, 3 | 6, 1 | 399, 5 | 22, 9 | 97, 5 | 9, 2 | 303, 2 | 22, 1 | 94, 2 | 6, 1 | 303, 5 | 304, 4 | |||||||||
| 26, 6 | 6, 1 | 397, 7 | 22, 2 | 90, 8 | 6, 1 | 399, 2 | 26, 6 | 93, 8 | 5, 9 | 305, 2 | 22, 2 | 94, 6 | 6, 1 | 305, 4 | 28, 7 | 104, 3 | 6, 1 | 304, 9 | |||||
| 26, 7 | 6, 2 | 397, 5 | 22, 6 | 92, 4 | 6, 3 | 398, 1 | 10, 8 | 305, 9 | 22, 6 | 97, 2 | 6, 3 | 29, 8 | 6, 2 | 305, 4 | |||||||||
| 27, 1 | 6, 3 | 395, 3 | 23, 6 | 6, 6 | 395, 7 | 30, 4 | 97, 9 | 306, 1 | 23, 6 | 97, 3 | 6, 6 | 307, 8 | 30, 3 | 102, 2 | 6, 3 | 305, 8 | |||||||
| 28, 1 | 6, 6 | 393, 9 | 24, 2 | 95, 1 | 6, 6 | 393, 1 | 22, 6 | 98, 3 | 6, 1 | 306, 9 | 24, 2 | 99, 1 | 6, 6 | 33, 5 | 95, 8 | 6, 6 | 306, 7 | ||||||
| 28, 6 | 98, 4 | 7, 9 | 24, 5 | 98, 4 | 8, 8 | 309, 1 | 28, 6 | 7, 3 | 307, 7 | 24, 5 | 99, 9 | 8, 8 | 30, 4 | 101, 1 | 11, 8 | 309, 1 | |||||||
| 29, 2 | 95, 1 | 6, 8 | 27, 5 | 99, 4 | 8, 9 | 306, 7 | 22, 3 | 8, 4 | 27, 5 | 101, 5 | 8, 9 | 393, 9 | 20, 8 | 6, 8 | 393, 1 | ||||||||
| 29, 6 | 7, 2 | 307, 8 | 28, 5 | 101, 4 | 9, 2 | 305, 8 | 25, 6 | 101, 8 | 8, 4 | 394, 9 | 28, 5 | 101, 7 | 9, 2 | 395, 3 | 23, 1 | 92, 3 | 7, 2 | 395, 7 | |||||
| 25, 3 | 92, 4 | 8, 7 | 28, 6 | 104, 4 | 9, 3 | 305, 4 | 30, 4 | 9, 5 | 397, 6 | 28, 6 | 103, 1 | 9, 3 | 397, 5 | 97, 9 | 7, 9 | 398, 1 | |||||||
| 26, 5 | 90, 8 | 6, 2 | 305, 4 | 29, 8 | 104, 5 | 9, 3 | 304, 9 | 38, 6 | 12, 5 | 398, 3 | 29, 8 | 104, 2 | 9, 3 | 397, 7 | 26, 7 | 95, 2 | 8, 1 | 399, 2 | |||||
| 31, 4 | 7, 2 | 303, 5 | 30, 3 | 104, 7 | 9, 3 | 304, 4 | 35, 4 | 11, 1 | 400, 7 | 30, 3 | 108, 6 | 9, 3 | 398, 2 | 36, 2 | 93, 8 | 8, 3 | 399, 5 | ||||||
| 33, 6 | 90, 2 | 8, 6 | 303, 1 | 35, 6 | 106, 4 | 9, 4 | 301, 8 | 38, 5 | 8, 2 | 35, 6 | 109, 4 | 9, 4 | 400, 6 | 38, 1 | 93, 5 | 8, 6 | 400, 2 | ||||||
| 34, 8 | 7, 5 | 38, 1 | 9, 5 | 301, 1 | 36, 8 | 120, 4 | 9, 2 | 401, 8 | 38, 1 | 114, 7 | 9, 5 | 403, 1 | 39, 5 | 92, 6 | 12, 5 | 401, 8 |
Закінчення додатку 7
| Варіант 16 | Варіант 17 | Варіант 18 | Варіант 19 | Варіант 20 | |||||||||||||||||||
| x1 | x2 | x3 | Y | x1 | x2 | x3 | Y | x1 | x2 | x3 | Y | x1 | x2 | x3 | Y | x1 | x2 | x3 | Y | ||||
| 20, 5 | 5, 8 | 400, 2 | 21, 1 | 90, 8 | 5, 7 | 403, 1 | 22, 1 | 98, 5 | 5, 7 | 401, 8 | 20, 5 | 66, 9 | 7, 5 | 300, 7 | 20, 5 | 90, 3 | 5, 9 | ||||||
| 21, 9 | 90, 2 | 399, 5 | 24, 2 | 5, 8 | 400, 6 | 24, 6 | 100, 4 | 5, 8 | 400, 2 | 21, 9 | 65, 2 | 5, 8 | 92, 6 | 10, 2 | 303, 1 | ||||||||
| 22, 1 | 90, 3 | 6, 1 | 399, 2 | 25, 9 | 94, 2 | 5, 8 | 398, 2 | 5, 8 | 399, 5 | 22, 1 | 63, 3 | 5, 8 | 303, 2 | 93, 5 | 8, 7 | 303, 5 | |||||||
| 22, 2 | 90, 8 | 6, 1 | 398, 1 | 26, 6 | 94, 6 | 5, 9 | 397, 7 | 28, 7 | 104, 3 | 5, 9 | 399, 2 | 22, 2 | 62, 1 | 5, 2 | 305, 2 | 32, 8 | 93, 8 | 8, 5 | 305, 4 | ||||
| 22, 6 | 92, 4 | 6, 3 | 395, 7 | 26, 7 | 97, 2 | 5, 9 | 397, 5 | 29, 8 | 5, 9 | 398, 1 | 22, 6 | 62, 6 | 5, 9 | 305, 9 | 29, 8 | 95, 2 | 8, 5 | ||||||
| 23, 6 | 6, 6 | 393, 1 | 27, 1 | 97, 3 | 395, 3 | 30, 3 | 102, 2 | 9, 3 | 395, 7 | 23, 6 | 63, 7 | 11, 2 | 306, 1 | 30, 3 | 97, 9 | 9, 5 | 307, 8 | ||||||
| 24, 2 | 95, 1 | 6, 6 | 309, 1 | 28, 1 | 99, 1 | 6, 1 | 393, 9 | 33, 5 | 95, 8 | 6, 1 | 393, 1 | 24, 2 | 64, 8 | 6, 1 | 306, 9 | 30, 3 | 98, 3 | 12, 9 | |||||
| 24, 5 | 98, 4 | 8, 8 | 306, 7 | 28, 6 | 99, 9 | 8, 3 | 16, 3 | 101, 1 | 8, 3 | 309, 1 | 24, 5 | 8, 3 | 307, 7 | 38, 5 | 8, 3 | ||||||||
| 27, 5 | 99, 4 | 8, 9 | 305, 8 | 29, 2 | 101, 5 | 8, 4 | 20, 8 | 8, 4 | 306, 7 | 27, 5 | 68, 9 | 8, 4 | 25, 8 | 101, 1 | 14, 1 | 393, 9 | |||||||
| 28, 5 | 101, 4 | 9, 2 | 305, 4 | 29, 6 | 101, 7 | 8, 4 | 307, 8 | 23, 1 | 92, 3 | 8, 4 | 305, 8 | 28, 5 | 70, 6 | 7, 5 | 394, 9 | 30, 8 | 101, 8 | 8, 4 | 395, 3 | ||||
| 28, 6 | 104, 4 | 9, 3 | 304, 9 | 30, 4 | 103, 1 | 8, 5 | 36, 2 | 100, 4 | 8, 5 | 305, 4 | 28, 6 | 72, 4 | 10, 4 | 397, 6 | 102, 2 | 5, 3 | 397, 5 | ||||||
| 29, 8 | 104, 5 | 9, 3 | 304, 4 | 31, 4 | 104, 2 | 8, 5 | 305, 4 | 26, 7 | 95, 2 | 304, 9 | 29, 8 | 70, 6 | 8, 5 | 398, 3 | 32, 9 | 12, 5 | 397, 7 | ||||||
| 30, 3 | 104, 7 | 9, 3 | 301, 8 | 31, 4 | 108, 6 | 8, 7 | 303, 5 | 36, 2 | 93, 8 | 8, 7 | 304, 4 | 30, 3 | 68, 5 | 11, 7 | 400, 7 | 36, 2 | 104, 3 | 8, 7 | 398, 2 | ||||
| 35, 6 | 106, 4 | 9, 4 | 301, 1 | 33, 6 | 109, 4 | 9, 2 | 303, 1 | 9, 2 | 301, 8 | 35, 6 | 68, 3 | 9, 2 | 21, 6 | 9, 2 | 400, 6 | ||||||||
| 38, 1 | 9, 5 | 401, 8 | 34, 8 | 114, 7 | 9, 2 | 40, 1 | 92, 6 | 12, 5 | 301, 1 | 38, 1 | 70, 5 | 12, 5 | 401, 8 | 39, 5 | 118, 4 | 12, 8 | 403, 1 |