Материалы сайта
Это интересно
Эконометрика
|EXP |SCH |TAR |LP |WG |QUAL |lnEXP |lnTAR |lnLP |lpWG | |5 |8 |5 |186 |214 |1 |1,6094|1,6094|5,2257|5,3659| | | | | | | |38 |38 |47 |76 | |3 |8 |4 |181 |170 |0 |1,0986|1,3862|5,1984|5,1357| | | | | | | |12 |94 |97 |98 | |4 |8 |4 |190 |200 |1 |1,3862|1,3862|5,2470|5,2983| | | | | | | |94 |94 |24 |17 | |5 |8 |3 |181 |205 |1 |1,6094|1,0986|5,1984|5,3230| | | | | | | |38 |12 |97 |1 | |3 |10 |4 |181 |194 |0 |1,0986|1,3862|5,1984|5,2678| | | | | | | |12 |94 |97 |58 | |3 |8 |4 |200 |218 |0 |1,0986|1,3862|5,2983|5,3844| | | | | | | |12 |94 |17 |95 | |5 |8 |4 |176 |212 |1 |1,6094|1,3862|5,1704|5,3565| | | | | | | |38 |94 |84 |86 | |5 |8 |5 |140 |175 |0 |1,6094|1,6094|4,9416|5,1647| | | | | | | |38 |38 |42 |86 | |3 |10 |4 |144 |154 |0 |1,0986|1,3862|4,9698|5,0369| | | | | | | |12 |94 |13 |53 | |5 |8 |5 |136 |172 |1 |1,6094|1,6094|4,9126|5,1474| | | | | | | |38 |38 |55 |94 | |4 |9 |5 |164 |180 |0 |1,3862|1,6094|5,0998|5,1929| | | | | | | |94 |38 |66 |57 | |5 |10 |3 |170 |180 |1 |1,6094|1,0986|5,1357|5,1929| | | | | | | |38 |12 |98 |57 | |1 |8 |3 |169 |182 |0 |0 |1,0986|5,1298|5,2040| | | | | | | | |12 |99 |07 | |2 |8 |4 |155 |180 |1 |0,6931|1,3862|5,0434|5,1929| | | | | | | |47 |94 |25 |57 | |2 |8 |4 |158 |185 |0 |0,6931|1,3862|5,0625|5,2203| | | | | | | |47 |94 |95 |56 | |2 |8 |3 |156 |150 |0 |0,6931|1,0986|5,0498|5,0106| | | | | | | |47 |12 |56 |35 | |4 |9 |4 |168 |175 |0 |1,3862|1,3862|5,1239|5,1647| | | | | | | |94 |94 |64 |86 | |1 |10 |4 |115 |143 |0 |0 |1,3862|4,7449|4,9628| | | | | | | | |94 |32 |45 | |2 |8 |4 |116 |144 |0 |0,6931|1,3862|4,7535|4,9698| | | | | | | |47 |94 |9 |13 | |3 |9 |3 |119 |140 |0 |1,0986|1,0986|4,7791|4,9416| | | | | | | |12 |12 |23 |42 | |3 |8 |3 |119 |132 |1 |1,0986|1,0986|4,7791|4,8828| | | | | | | |12 |12 |23 |02 | |2 |10 |4 |125 |150 |0 |0,6931|1,3862|4,8283|5,0106| | | | | | | |47 |94 |14 |35 | |2 |9 |4 |127 |142 |1 |0,6931|1,3862|4,8441|4,9558| | | | | | | |47 |94 |87 |27 | |2 |8 |4 |128 |150 |0 |0,6931|1,3862|4,8520|5,0106| | | | | | | |47 |94 |3 |35 | |1 |9 |4 |129 |143 |0 |0 |1,3862|4,8598|4,9628| | | | | | | | |94 |12 |45 | |1 |10 |4 |129 |147 |0 |0 |1,3862|4,8598|4,9904| | | | | | | | |94 |12 |33 | |4 |10 |5 |140 |170 |1 |1,3862|1,6094|4,9416|5,1357| | | | | | | |94 |38 |42 |98 | |1 |8 |4 |113 |135 |0 |0 |1,3862|4,7273|4,9052| | | | | | | | |94 |88 |75 | |2 |8 |4 |110 |125 |1 |0,6931|1,3862|4,7004|4,8283| | | | | | | |47 |94 |8 |14 | |2 |10 |4 |110 |129 |0 |0,6931|1,3862|4,7004|4,8598| | | | | | | |47 |94 |8 |12 | |1 |8 |3 |109 |130 |0 |0 |1,0986|4,6913|4,8675| | | | | | | | |12 |48 |34 | |3 |8 |4 |132 |155 |0 |1,0986|1,3862|4,8828|5,0434| | | | | | | |12 |94 |02 |25 | |5 |10 |4 |136 |160 |1 |1,6094|1,3862|4,9126|5,0751| | | | | | | |38 |94 |55 |74 | |3 |8 |3 |132 |150 |0 |1,0986|1,0986|4,8828|5,0106| | | | | | | |12 |12 |02 |35 | |5 |10 |4 |132 |170 |1 |1,6094|1,3862|4,8828|5,1357| | | | | | | |38 |94 |02 |98 | |3 |8 |3 |132 |155 |1 |1,0986|1,0986|4,8828|5,0434| | | | | | | |12 |12 |02 |25 | |2 |8 |5 |132 |185 |1 |0,6931|1,6094|4,8828|5,2203| | | | | | | |47 |38 |02 |56 | |1 |8 |4 |113 |128 |0 |0 |1,3862|4,7273|4,8520| | | | | | | | |94 |88 |3 | |3 |8 |4 |100 |131 |1 |1,0986|1,3862|4,6051|4,8751| | | | | | | |12 |94 |7 |97 | |1 |8 |4 |80 |102 |0 |0 |1,3862|4,3820|4,6249| | | | | | | | |94 |27 |73 | |3 |8 |3 |104 |131 |0 |1,0986|1,0986|4,6443|4,8751| | | | | | | |12 |12 |91 |97 | |3 |8 |3 |104 |125 |0 |1,0986|1,0986|4,6443|4,8283| | | | | | | |12 |12 |91 |14 | |1 |10 |4 |107 |137 |0 |0 |1,3862|4,6728|4,9199| | | | | | | | |94 |29 |81 | |2 |9 |3 |96 |110 |0 |0,6931|1,0986|4,5643|4,7004| | | | | | | |47 |12 |48 |8 | |5 |10 |4 |190 |210 |1 |1,6094|1,3862|5,2470|5,3471| | | | | | | |38 |94 |24 |08 | |2 |10 |5 |195 |233 |1 |0,6931|1,6094|5,273 |5,4510| | | | | | | |47 |38 | |38 | |3 |9 |3 |186 |220 |1 |1,0986|1,0986|5,2257|5,3936| | | | | | | |12 |12 |47 |28 | |4 |9 |4 |180 |192 |1 |1,3862|1,3862|5,1929|5,2574| | | | | | | |94 |94 |57 |95 | |2 |7 |4 |125 |132 |0 |0,6931|1,3862|4,8283|4,8828| | | | | | | |47 |94 |14 |02 | |1 |7 |3 |90 |115 |0 |0 |1,0986|4,4998|4,7449| | | | | | | | |12 |1 |32 | |5 |8 |4 |203 |231 |1 |1,6094|1,3862|5,3132|5,4424| | | | | | | |38 |94 |06 |18 | |5 |10 |3 |153 |167 |0 |1,6094|1,0986|5,0304|5,1179| | | | | | | |38 |12 |38 |94 | |5 |5 |4 |158 |172 |1 |1,6094|1,3862|5,0625|5,1474| | | | | | | |38 |94 |95 |94 | |2 |7 |4 |146 |162 |0 |0,6931|1,3862|4,9836|5,0875| | | | | | | |47 |94 |07 |96 | |3 |8 |4 |100 |120 |0 |1,0986|1,3862|4,6051|4,7874| | | | | | | |12 |94 |7 |92 | |3 |10 |4 |125 |132 |0 |1,0986|1,3862|4,8283|4,8828| | | | | | | |12 |94 |14 |02 | |4 |7 |4 |159 |184 |0 |1,3862|1,3862|5,0689|5,2149| | | | | | | |94 |94 |04 |36 | |2 |5 |3 |123 |148 |1 |0,6931|1,0986|4,8121|4,9972| | | | | | | |47 |12 |84 |12 | |4 |8 |4 |159 |173 |1 |1,3862|1,3862|5,0689|5,1532| | | | | | | |94 |94 |04 |92 | |3 |10 |4 |100 |132 |1 |1,0986|1,3862|4,6051|4,8828| | | | | | | |12 |94 |7 |02 | |3 |8 |5 |190 |215 |0 |1,0986|1,6094|5,2470|5,3706| | | | | | | |12 |38 |24 |38 | |1 |7 |4 |199 |220 |0 |0 |1,3862|5,2933|5,3936| | | | | | | | |94 |05 |28 | |3 |8 |4 |139 |166 |1 |1,0986|1,3862|4,9344|5,1119| | | | | | | |12 |94 |74 |88 | |2 |7 |5 |190 |210 |1 |0,6931|1,6094|5,2470|5,3471| | | | | | | |47 |38 |24 |08 | |1 |8 |5 |83 |120 |1 |0 |1,6094|4,4188|4,7874| | | | | | | | |38 |41 |92 | |1 |7 |3 |98 |115 |0 |0 |1,0986|4,5849|4,7449| | | | | | | | |12 |67 |32 | |2 |10 |4 |139 |155 |1 |0,6931|1,3862|4,9344|5,0434| | | | | | | |47 |94 |74 |25 | |1 |8 |4 |85 |106 |0 |0 |1,3862|4,4426|4,6634| | | | | | | | |94 |51 |39 | |4 |8 |5 |146 |166 |1 |1,3862|1,6094|4,9836|5,1119| | | | | | | |94 |38 |07 |88 | |5 |8 |4 |183 |205 |1 |1,6094|1,3862|5,2094|5,3230| | | | | | | |38 |94 |86 |1 | |1 |7 |3 |90 |115 |1 |0 |1,0986|4,4998|4,7449| | | | | | | | |12 |1 |32 | |3 |10 |4 |146 |160 |0 |1,0986|1,3862|4,9836|5,0751| | | | | | | |12 |94 |07 |74 | |2 |7 |3 |95 |113 |0 |0,6931|1,0986|4,5538|4,7273| | | | | | | |47 |12 |77 |88 | |1 |8 |4 |113 |115 |1 |0 |1,3862|4,7273|4,7449| | | | | | | | |94 |88 |32 | |1 |7 |4 |113 |138 |1 |0 |1,3862|4,7273|4,9272| | | | | | | | |94 |88 |54 | |2 |8 |4 |111 |130 |0 |0,6931|1,3862|4,7095|4,8675| | | | | | | |47 |94 |3 |34 | |1 |7 |4 |110 |129 |0 |0 |1,3862|4,7004|4,8598| | | | | | | | |94 |8 |12 | |1 |8 |4 |128 |145 |1 |0 |1,3862|4,8520|4,9767| | | | | | | | |94 |3 |34 | |2 |7 |4 |128 |143 |1 |0,6931|1,3862|4,8520|4,9628| | | | | | | |47 |94 |3 |45 | |5 |10 |4 |169 |180 |1 |1,6094|1,3862|5,1298|5,1929| | | | | | | |38 |94 |99 |57 | |5 |8 |5 |190 |250 |1 |1,6094|1,6094|5,2470|5,5214| | | | | | | |38 |38 |24 |61 | |5 |10 |5 |190 |235 |1 |1,6094|1,6094|5,2470|5,4595| | | | | | | |38 |38 |24 |86 | |5 |8 |5 |190 |260 |1 |1,6094|1,6094|5,2470|5,5606| | | | | | | |38 |38 |24 |82 | |1 |9 |5 |127 |158 |0 |0 |1,6094|4,8441|5,0625| | | | | | | | |38 |87 |95 | |5 |7 |4 |80 |102 |0 |1,6094|1,3862|4,3820|4,6249| | | | | | | |38 |94 |27 |73 | |2 |8 |5 |140 |175 |1 |0,6931|1,6094|4,9416|5,1647| | | | | | | |47 |38 |42 |86 | |1 |6 |3 |87 |100 |0 |0 |1,0986|4,4659|4,6051| | | | | | | | |12 |08 |7 | |2 |7 |3 |106 |120 |0 |0,6931|1,0986|4,6634|4,7874| | | | | | | |47 |12 |39 |92 | |3 |7 |4 |123 |150 |1 |1,0986|1,3862|4,8121|5,0106| | | | | | | |12 |94 |84 |35 | |4 |10 |5 |189 |240 |1 |1,3862|1,6094|5,2417|5,4806| | | | | | | |94 |38 |47 |39 | |3 |7 |4 |180 |200 |1 |1,0986|1,3862|5,1929|5,2983| | | | | | | |12 |94 |57 |17 | |4 |6 |3 |168 |164 |0 |1,3862|1,0986|5,1239|5,0998| | | | | | | |94 |12 |64 |66 | |2 |7 |4 |120 |128 |0 |0,6931|1,3862|4,7874|4,8520| | | | | | | |47 |94 |92 |3 | |1 |8 |4 |144 |159 |1 |0 |1,3862|4,9698|5,0689| | | | | | | | |94 |13 |04 | |3 |10 |4 |139 |160 |0 |1,0986|1,3862|4,9344|5,0751| | | | | | | |12 |94 |74 |74 | |2 |7 |4 |132 |165 |1 |0,6931|1,3862|4,8828|5,1059| | | | | | | |47 |94 |02 |45 | |1 |6 |4 |104 |94 |1 |0 |1,3862|4,6443|4,5432| | | | | | | | |94 |91 |95 | | |QUAL |lnEXP |lnSCH |lnTAR |lnLP |lpWG | |QUAL |1 | | | | | | |lnEXP |0,3006|1 | | | | | | |85 | | | | | | |lnSCH |-0,028|0,2031|1 | | | | | |57 |77 | | | | | |lnTAR |0,2665|0,1588|0,2219|1 | | | | |22 |69 |24 | | | | |lnLP |0,2964|0,5496|0,1948|0,3025|1 | | | |8 |93 |09 |05 | | | |lpWG |0,3675|0,5667|0,2402|0,4106|0,9442|1 | | |45 |96 |22 |54 |04 | | |ВЫВОД ИТОГОВ | | | | | | | | | | | |Регрессионная | | | | | |статистика | | | | | |Множественный R |0,955060108| | | | |R-квадрат |0,912139809| | | | |Нормированный |0,90930561 | | | | |R-квадрат | | | | | |Стандартная ошибка |0,06885987 | | | | |Наблюдения |97 | | | | | | | | | | |Дисперсионный | | | | | |анализ | | | | | | |df |SS |MS |F | |Регрессия |3 |4,578093015 |1,526031005|321,833289| | | | | |2 | |Остаток |93 |0,440976394 |0,004741682| | |Итого |96 |5,01906941 | | | | | | | | | | |Коэффициент|Стандартная |t-статистик|P-Значение| | |ы |ошибка |а | | |Y-пересечение |0,807401092|0,163012857 |4,952990251|3,25854E-0| | | | | |6 | |lnEXP |0,027776475|0,014615743 |2,100449018|0,06047165| | | | | |6 | |lnTAR |0,191968168|0,044798066 |4,28518877 |4,44891E-0| | | | | |5 | |lnLP |0,80739047 |0,03561839 |22,66779785|1,18496E-3| | | | | |9 | |Значимость | | |F | | |5,70774E-49| | | | | | | | | | | |Нижние 95% |Верхние 95%| |0,483690189|1,131111995| |0,001247466|0,056800415| |0,103008177|0,28092816 | |0,736659477|0,878121463| Аналитическая записка. 1. Анализ факторов. Необходимо было выяснить какие факторы влияют на формирование заработной платы рабочих – выпускников ПТУ. Были представлены следующие факторы: 1. EXP - стаж работы рабочего, лет 2. SCH - число классов, оконченных рабочим в средней школе 3. TAR - тарифный разряд, присвоенный рабочему на момент окончания ПТУ 4. QUAL - фиктивная переменная, отражающая прохождение рабочим повышения квалификации (=1, если рабочий проходил повышение квалификации; 0 - если нет) 5. LP - процент выполнения рабочим норм выработки,% 6. WG - заработная плата рабочего, р Для анализа были представлены данные по 100 рабочим. После проверки данных осталось 97. При отборе факторов в модели мы выявили, что такие факторы, как – 1) прохождение рабочим повышения квалификации и 2) число классов, оконченных рабочим в средней школе не влияют на результаты. Остальные же факторы влияют на результаты и могут быть включены в уравнение множественной регрессии. 2.Линейная модель множественной регрессии. ----------------------- [pic] [pic] [pic]