Эконометрика
|
EXP |
SCH |
TAR |
LP |
WG |
QUAL |
lnEXP |
lnTAR |
lnLP |
lpWG |
|
5 |
8 |
5 |
186 |
214 |
1 |
1,609438 |
1,609438 |
5,225747 |
5,365976 |
|
3 |
8 |
4 |
181 |
170 |
0 |
1,098612 |
1,386294 |
5,198497 |
5,135798 |
|
4 |
8 |
4 |
190 |
200 |
1 |
1,386294 |
1,386294 |
5,247024 |
5,298317 |
|
5 |
8 |
3 |
181 |
205 |
1 |
1,609438 |
1,098612 |
5,198497 |
5,32301 |
|
3 |
10 |
4 |
181 |
194 |
0 |
1,098612 |
1,386294 |
5,198497 |
5,267858 |
|
3 |
8 |
4 |
200 |
218 |
0 |
1,098612 |
1,386294 |
5,298317 |
5,384495 |
|
5 |
8 |
4 |
176 |
212 |
1 |
1,609438 |
1,386294 |
5,170484 |
5,356586 |
|
5 |
8 |
5 |
140 |
175 |
0 |
1,609438 |
1,609438 |
4,941642 |
5,164786 |
|
3 |
10 |
4 |
144 |
154 |
0 |
1,098612 |
1,386294 |
4,969813 |
5,036953 |
|
5 |
8 |
5 |
136 |
172 |
1 |
1,609438 |
1,609438 |
4,912655 |
5,147494 |
|
4 |
9 |
5 |
164 |
180 |
0 |
1,386294 |
1,609438 |
5,099866 |
5,192957 |
|
5 |
10 |
3 |
170 |
180 |
1 |
1,609438 |
1,098612 |
5,135798 |
5,192957 |
|
1 |
8 |
3 |
169 |
182 |
0 |
0 |
1,098612 |
5,129899 |
5,204007 |
|
2 |
8 |
4 |
155 |
180 |
1 |
0,693147 |
1,386294 |
5,043425 |
5,192957 |
|
2 |
8 |
4 |
158 |
185 |
0 |
0,693147 |
1,386294 |
5,062595 |
5,220356 |
|
2 |
8 |
3 |
156 |
150 |
0 |
0,693147 |
1,098612 |
5,049856 |
5,010635 |
|
4 |
9 |
4 |
168 |
175 |
0 |
1,386294 |
1,386294 |
5,123964 |
5,164786 |
|
1 |
10 |
4 |
115 |
143 |
0 |
0 |
1,386294 |
4,744932 |
4,962845 |
|
2 |
8 |
4 |
116 |
144 |
0 |
0,693147 |
1,386294 |
4,75359 |
4,969813 |
|
3 |
9 |
3 |
119 |
140 |
0 |
1,098612 |
1,098612 |
4,779123 |
4,941642 |
|
3 |
8 |
3 |
119 |
132 |
1 |
1,098612 |
1,098612 |
4,779123 |
4,882802 |
|
2 |
10 |
4 |
125 |
150 |
0 |
0,693147 |
1,386294 |
4,828314 |
5,010635 |
|
2 |
9 |
4 |
127 |
142 |
1 |
0,693147 |
1,386294 |
4,844187 |
4,955827 |
|
2 |
8 |
4 |
128 |
150 |
0 |
0,693147 |
1,386294 |
4,85203 |
5,010635 |
|
1 |
9 |
4 |
129 |
143 |
0 |
0 |
1,386294 |
4,859812 |
4,962845 |
|
1 |
10 |
4 |
129 |
147 |
0 |
0 |
1,386294 |
4,859812 |
4,990433 |
|
4 |
10 |
5 |
140 |
170 |
1 |
1,386294 |
1,609438 |
4,941642 |
5,135798 |
|
1 |
8 |
4 |
113 |
135 |
0 |
0 |
1,386294 |
4,727388 |
4,905275 |
|
2 |
8 |
4 |
110 |
125 |
1 |
0,693147 |
1,386294 |
4,70048 |
4,828314 |
|
2 |
10 |
4 |
110 |
129 |
0 |
0,693147 |
1,386294 |
4,70048 |
4,859812 |
|
1 |
8 |
3 |
109 |
130 |
0 |
0 |
1,098612 |
4,691348 |
4,867534 |
|
3 |
8 |
4 |
132 |
155 |
0 |
1,098612 |
1,386294 |
4,882802 |
5,043425 |
|
5 |
10 |
4 |
136 |
160 |
1 |
1,609438 |
1,386294 |
4,912655 |
5,075174 |
|
3 |
8 |
3 |
132 |
150 |
0 |
1,098612 |
1,098612 |
4,882802 |
5,010635 |
|
5 |
10 |
4 |
132 |
170 |
1 |
1,609438 |
1,386294 |
4,882802 |
5,135798 |
|
3 |
8 |
3 |
132 |
155 |
1 |
1,098612 |
1,098612 |
4,882802 |
5,043425 |
|
2 |
8 |
5 |
132 |
185 |
1 |
0,693147 |
1,609438 |
4,882802 |
5,220356 |
|
1 |
8 |
4 |
113 |
128 |
0 |
0 |
1,386294 |
4,727388 |
4,85203 |
|
3 |
8 |
4 |
100 |
131 |
1 |
1,098612 |
1,386294 |
4,60517 |
4,875197 |
|
1 |
8 |
4 |
80 |
102 |
0 |
0 |
1,386294 |
4,382027 |
4,624973 |
|
3 |
8 |
3 |
104 |
131 |
0 |
1,098612 |
1,098612 |
4,644391 |
4,875197 |
|
3 |
8 |
3 |
104 |
125 |
0 |
1,098612 |
1,098612 |
4,644391 |
4,828314 |
|
1 |
10 |
4 |
107 |
137 |
0 |
0 |
1,386294 |
4,672829 |
4,919981 |
|
2 |
9 |
3 |
96 |
110 |
0 |
0,693147 |
1,098612 |
4,564348 |
4,70048 |
|
5 |
10 |
4 |
190 |
210 |
1 |
1,609438 |
1,386294 |
5,247024 |
5,347108 |
|
2 |
10 |
5 |
195 |
233 |
1 |
0,693147 |
1,609438 |
5,273 |
5,451038 |
|
3 |
9 |
3 |
186 |
220 |
1 |
1,098612 |
1,098612 |
5,225747 |
5,393628 |
|
4 |
9 |
4 |
180 |
192 |
1 |
1,386294 |
1,386294 |
5,192957 |
5,257495 |
|
2 |
7 |
4 |
125 |
132 |
0 |
0,693147 |
1,386294 |
4,828314 |
4,882802 |
|
1 |
7 |
3 |
90 |
115 |
0 |
0 |
1,098612 |
4,49981 |
4,744932 |
|
5 |
8 |
4 |
203 |
231 |
1 |
1,609438 |
1,386294 |
5,313206 |
5,442418 |
|
5 |
10 |
3 |
153 |
167 |
0 |
1,609438 |
1,098612 |
5,030438 |
5,117994 |
|
5 |
5 |
4 |
158 |
172 |
1 |
1,609438 |
1,386294 |
5,062595 |
5,147494 |
|
2 |
7 |
4 |
146 |
162 |
0 |
0,693147 |
1,386294 |
4,983607 |
5,087596 |
|
3 |
8 |
4 |
100 |
120 |
0 |
1,098612 |
1,386294 |
4,60517 |
4,787492 |
|
3 |
10 |
4 |
125 |
132 |
0 |
1,098612 |
1,386294 |
4,828314 |
4,882802 |
|
4 |
7 |
4 |
159 |
184 |
0 |
1,386294 |
1,386294 |
5,068904 |
5,214936 |
|
2 |
5 |
3 |
123 |
148 |
1 |
0,693147 |
1,098612 |
4,812184 |
4,997212 |
|
4 |
8 |
4 |
159 |
173 |
1 |
1,386294 |
1,386294 |
5,068904 |
5,153292 |
|
3 |
10 |
4 |
100 |
132 |
1 |
1,098612 |
1,386294 |
4,60517 |
4,882802 |
|
3 |
8 |
5 |
190 |
215 |
0 |
1,098612 |
1,609438 |
5,247024 |
5,370638 |
|
1 |
7 |
4 |
199 |
220 |
0 |
0 |
1,386294 |
5,293305 |
5,393628 |
|
3 |
8 |
4 |
139 |
166 |
1 |
1,098612 |
1,386294 |
4,934474 |
5,111988 |
|
2 |
7 |
5 |
190 |
210 |
1 |
0,693147 |
1,609438 |
5,247024 |
5,347108 |
|
1 |
8 |
5 |
83 |
120 |
1 |
0 |
1,609438 |
4,418841 |
4,787492 |
|
1 |
7 |
3 |
98 |
115 |
0 |
0 |
1,098612 |
4,584967 |
4,744932 |
|
2 |
10 |
4 |
139 |
155 |
1 |
0,693147 |
1,386294 |
4,934474 |
5,043425 |
|
1 |
8 |
4 |
85 |
106 |
0 |
0 |
1,386294 |
4,442651 |
4,663439 |
|
4 |
8 |
5 |
146 |
166 |
1 |
1,386294 |
1,609438 |
4,983607 |
5,111988 |
|
5 |
8 |
4 |
183 |
205 |
1 |
1,609438 |
1,386294 |
5,209486 |
5,32301 |
|
1 |
7 |
3 |
90 |
115 |
1 |
0 |
1,098612 |
4,49981 |
4,744932 |
|
3 |
10 |
4 |
146 |
160 |
0 |
1,098612 |
1,386294 |
4,983607 |
5,075174 |
|
2 |
7 |
3 |
95 |
113 |
0 |
0,693147 |
1,098612 |
4,553877 |
4,727388 |
|
1 |
8 |
4 |
113 |
115 |
1 |
0 |
1,386294 |
4,727388 |
4,744932 |
|
1 |
7 |
4 |
113 |
138 |
1 |
0 |
1,386294 |
4,727388 |
4,927254 |
|
2 |
8 |
4 |
111 |
130 |
0 |
0,693147 |
1,386294 |
4,70953 |
4,867534 |
|
1 |
7 |
4 |
110 |
129 |
0 |
0 |
1,386294 |
4,70048 |
4,859812 |
|
1 |
8 |
4 |
128 |
145 |
1 |
0 |
1,386294 |
4,85203 |
4,976734 |
|
2 |
7 |
4 |
128 |
143 |
1 |
0,693147 |
1,386294 |
4,85203 |
4,962845 |
|
5 |
10 |
4 |
169 |
180 |
1 |
1,609438 |
1,386294 |
5,129899 |
5,192957 |
|
5 |
8 |
5 |
190 |
250 |
1 |
1,609438 |
1,609438 |
5,247024 |
5,521461 |
|
5 |
10 |
5 |
190 |
235 |
1 |
1,609438 |
1,609438 |
5,247024 |
5,459586 |
|
5 |
8 |
5 |
190 |
260 |
1 |
1,609438 |
1,609438 |
5,247024 |
5,560682 |
|
1 |
9 |
5 |
127 |
158 |
0 |
0 |
1,609438 |
4,844187 |
5,062595 |
|
5 |
7 |
4 |
80 |
102 |
0 |
1,609438 |
1,386294 |
4,382027 |
4,624973 |
|
2 |
8 |
5 |
140 |
175 |
1 |
0,693147 |
1,609438 |
4,941642 |
5,164786 |
|
1 |
6 |
3 |
87 |
100 |
0 |
0 |
1,098612 |
4,465908 |
4,60517 |
|
2 |
7 |
3 |
106 |
120 |
0 |
0,693147 |
1,098612 |
4,663439 |
4,787492 |
|
3 |
7 |
4 |
123 |
150 |
1 |
1,098612 |
1,386294 |
4,812184 |
5,010635 |
|
4 |
10 |
5 |
189 |
240 |
1 |
1,386294 |
1,609438 |
5,241747 |
5,480639 |
|
3 |
7 |
4 |
180 |
200 |
1 |
1,098612 |
1,386294 |
5,192957 |
5,298317 |
|
4 |
6 |
3 |
168 |
164 |
0 |
1,386294 |
1,098612 |
5,123964 |
5,099866 |
|
2 |
7 |
4 |
120 |
128 |
0 |
0,693147 |
1,386294 |
4,787492 |
4,85203 |
|
1 |
8 |
4 |
144 |
159 |
1 |
0 |
1,386294 |
4,969813 |
5,068904 |
|
3 |
10 |
4 |
139 |
160 |
0 |
1,098612 |
1,386294 |
4,934474 |
5,075174 |
|
2 |
7 |
4 |
132 |
165 |
1 |
0,693147 |
1,386294 |
4,882802 |
5,105945 |
|
1 |
6 |
4 |
104 |
94 |
1 |
0 |
1,386294 |
4,644391 |
4,543295 |
|
QUAL |
lnEXP |
lnSCH |
lnTAR |
lnLP |
lpWG |
|
|
QUAL |
1 |
|||||
|
lnEXP |
0,300685 |
1 |
||||
|
lnSCH |
-0,02857 |
0,203177 |
1 |
|||
|
lnTAR |
0,266522 |
0,158869 |
0,221924 |
1 |
||
|
lnLP |
0,29648 |
0,549693 |
0,194809 |
0,302505 |
1 |
|
|
lpWG |
0,367545 |
0,566796 |
0,240222 |
0,410654 |
0,944204 |
1 |
|
ВЫВОД ИТОГОВ |
||||
|
Регрессионная статистика |
||||
|
Множественный R |
0,955060108 |
|||
|
R-квадрат |
0,912139809 |
|||
|
Нормированный R-квадрат |
0,90930561 |
|||
|
Стандартная ошибка |
0,06885987 |
|||
|
Наблюдения |
97 |
|||
|
Дисперсионный анализ |
||||
|
df |
SS |
MS |
F |
|
|
Регрессия |
3 |
4,578093015 |
1,526031005 |
321,8332892 |
|
Остаток |
93 |
0,440976394 |
0,004741682 |
|
|
Итого |
96 |
5,01906941 |
||
|
Коэффициенты |
Стандартная ошибка |
t-статистика |
P-Значение |
|
|
Y-пересечение |
0,807401092 |
0,163012857 |
4,952990251 |
3,25854E-06 |
|
lnEXP |
0,027776475 |
0,014615743 |
2,100449018 |
0,060471656 |
|
lnTAR |
0,191968168 |
0,044798066 |
4,28518877 |
4,44891E-05 |
|
lnLP |
0,80739047 |
0,03561839 |
22,66779785 |
1,18496E-39 |
|
Значимость F |
|
|
5,70774E-49 |
|
|
Нижние 95% |
Верхние 95% |
|
0,483690189 |
1,131111995 |
|
0,001247466 |
0,056800415 |
|
0,103008177 |
0,28092816 |
|
0,736659477 |
0,878121463 |



Аналитическая записка.
Анализ факторов.
Необходимо было выяснить какие факторы влияют на формирование заработной платы рабочих – выпускников ПТУ. Были представлены следующие факторы:
1. EXP - стаж работы рабочего, лет
2. SCH - число классов, оконченных рабочим в средней школе
3. TAR - тарифный разряд, присвоенный рабочему на момент окончания ПТУ
4. QUAL - фиктивная переменная, отражающая прохождение рабочим повышения квалификации (=1, если рабочий проходил повышение квалификации; 0 - если нет)
5. LP - процент выполнения рабочим норм выработки,%
6. WG - заработная плата рабочего, р
Для анализа были представлены данные по 100 рабочим. После проверки данных осталось