Portfolio
nirmak
PROJ.C.MAKWANA.xlsxSheet1
| State FIPS | State | 116th Congressional District | 2017 NAICS Code | NAICS Description | Number of Establishments | Employment | Employment Noise Flag | 1st Quarter Payroll ($1,000) | 1st Quarter Payroll Noise Flag | Annual Payroll ($1,000) | Annual Payroll Noise Flag |
| 01 | Alabama | 01 | 0 | Total for all sectors | 15,921 | 244,615 | G | 2,492,282 | G | 10,417,508 | G |
| 01 | Alabama | 01 | 11---- | Agriculture, forestry, fishing and hunting | 142 | 1,127 | G | 10,591 | G | 44,855 | G |
| 01 | Alabama | 01 | 21---- | Mining, quarrying, and oil and gas extraction | 34 | 500 | G | 10,491 | H | 41,785 | H |
| 01 | Alabama | 01 | 22---- | Utilities | 56 | 1,618 | G | 46,260 | H | 151,722 | H |
| 01 | Alabama | 01 | 23---- | Construction | 1,367 | 16,277 | G | 194,035 | G | 855,500 | G |
| 01 | Alabama | 01 | 31---- | Manufacturing | 568 | 27,761 | G | 477,179 | G | 1,897,405 | G |
| 01 | Alabama | 01 | 42---- | Wholesale trade | 857 | 10,723 | G | 152,635 | G | 607,774 | G |
| 01 | Alabama | 01 | 44---- | Retail trade | 2,811 | 37,463 | G | 248,940 | G | 1,015,434 | G |
| 01 | Alabama | 01 | 48---- | Transportation and warehousing | 574 | 9,862 | G | 114,653 | G | 487,821 | G |
| 01 | Alabama | 01 | 51---- | Information | 284 | 4,229 | G | 64,288 | G | 254,116 | G |
| 01 | Alabama | 01 | 52---- | Finance and insurance | 1,184 | 9,273 | G | 139,135 | G | 589,963 | G |
| 01 | Alabama | 01 | 53---- | Real estate and rental and leasing | 867 | 4,411 | G | 39,547 | G | 172,784 | G |
| 01 | Alabama | 01 | 54---- | Professional, scientific, and technical | 1,432 | 12,406 | G | 201,202 | G | 828,587 | G |
| 01 | Alabama | 01 | 55---- | Management of companies and enterprises | 105 | 3,216 | G | 67,676 | G | 326,639 | H |
| 01 | Alabama | 01 | 56---- | Administrative and support and waste | 776 | 20,049 | G | 142,193 | H | 624,241 | H |
| 01 | Alabama | 01 | 61---- | Educational services | 149 | 5,247 | H | 35,641 | H | 151,186 | H |
| 01 | Alabama | 01 | 62---- | Health care and social assistance | 1,418 | 32,773 | G | 336,896 | G | 1,468,707 | G |
| 01 | Alabama | 01 | 71---- | Arts, entertainment, and recreation | 207 | 3,514 | G | 12,609 | G | 55,387 | G |
| 01 | Alabama | 01 | 72---- | Accommodation and food services | 1,408 | 31,656 | G | 122,659 | G | 533,285 | G |
| 01 | Alabama | 01 | 81---- | Other services (except public administration) | 1,663 | 12,472 | G | 75,566 | G | 309,828 | G |
Sheet1 (2)
| State FIPS | State | 116th Congressional District | Number of Establishments | Employment | 1st Quarter Payroll ($1,000) | Annual Payroll ($1,000) | 2017 NAICS Code |
| 01 | Alabama | 01 | 15,921 | 244,615 | 2,492,282 | 10,417,508 | 0.00 |
| 01 | Alabama | 01 | 142 | 1,127 | 10,591 | 44,855 | 11.00 |
| 01 | Alabama | 01 | 34 | 500 | 10,491 | 41,785 | 21.00 |
| 01 | Alabama | 01 | 56 | 1,618 | 46,260 | 151,722 | 22.00 |
| 01 | Alabama | 01 | 1,367 | 16,277 | 194,035 | 855,500 | 23.00 |
| 01 | Alabama | 01 | 568 | 27,761 | 477,179 | 1,897,405 | 31.00 |
| 01 | Alabama | 01 | 857 | 10,723 | 152,635 | 607,774 | 42.00 |
| 01 | Alabama | 01 | 2,811 | 37,463 | 248,940 | 1,015,434 | 44.00 |
| 01 | Alabama | 01 | 574 | 9,862 | 114,653 | 487,821 | 48.00 |
| 01 | Alabama | 01 | 284 | 4,229 | 64,288 | 254,116 | 51.00 |
| 01 | Alabama | 01 | 1,184 | 9,273 | 139,135 | 589,963 | 52.00 |
| 01 | Alabama | 01 | 867 | 4,411 | 39,547 | 172,784 | 53.00 |
| 01 | Alabama | 01 | 1,432 | 12,406 | 201,202 | 828,587 | 54.00 |
| 01 | Alabama | 01 | 105 | 3,216 | 67,676 | 326,639 | 55.00 |
| 01 | Alabama | 01 | 776 | 20,049 | 142,193 | 624,241 | 56.00 |
| 01 | Alabama | 01 | 149 | 5,247 | 35,641 | 151,186 | 61.00 |
| 01 | Alabama | 01 | 1,418 | 32,773 | 336,896 | 1,468,707 | 62.00 |
| 01 | Alabama | 01 | 207 | 3,514 | 12,609 | 55,387 | 71.00 |
| 01 | Alabama | 01 | 1,408 | 31,656 | 122,659 | 533,285 | 72.00 |
| 01 | Alabama | 01 | 1,663 | 12,472 | 75,566 | 309,828 | 81.00 |
Sheet3
| SUMMARY OUTPUT | ||||||||
| Regression Statistics | ||||||||
| Multiple R | 0.9895121661 | |||||||
| R Square | 0.9791343269 | |||||||
| Adjusted R Square | 0.9735701474 | |||||||
| Standard Error | 560.3777872896 | |||||||
| Observations | 20 | |||||||
| ANOVA | ||||||||
| df | SS | MS | F | Significance F | ||||
| Regression | 4 | 221035973.582687 | 55258993.3956717 | 175.97101758 | 2.08E-12 | |||
| Residual | 15 | 4710348.96731308 | 314023.264487539 | |||||
| Total | 19 | 225746322.55 | ||||||
| Coefficients | Standard Error | t Stat | P-value | Lower 95% | Upper 95% | Lower 95.0% | Upper 95.0% | |
| Intercept | 80.1812524867 | 402.4223749589 | 0.1992465068 | 0.8447456304 | -777.5617357425 | 937.924240716 | -777.5617357425 | 937.924240716 |
| Emplyment | 0.0710855628 | 0.0194623813 | 3.6524596782 | 0.0023579281 | 0.0296024791 | 0.1125686465 | 0.0296024791 | 0.1125686465 |
| 1st Quarter payroll | -0.0062043841 | 0.0169697307 | -0.3656147653 | 0.719757128 | -0.0423745089 | 0.0299657407 | -0.0423745089 | 0.0299657407 |
| Annual Payroll | 0.0013176372 | 0.0041993812 | 0.3137693604 | 0.7580174014 | -0.007633132 | 0.0102684063 | -0.007633132 | 0.0102684063 |
| 2017 NAICS | -1.1888401206 | 7.5379254169 | -0.1577144977 | 0.8767852627 | -17.2555478248 | 14.8778675837 | -17.2555478248 | 14.8778675837 |
| RESIDUAL OUTPUT | ||||||||
| Observation | Predicted Y | Residuals | ||||||
| 1 | 15732.1969819386 | 188.8030180614 | ||||||
| 2 | 140.609423001 | 1.390576999 | ||||||
| 3 | 80.7256662623 | -46.7256662623 | ||||||
| 4 | 81.94294631 | -25.94294631 | ||||||
| 5 | 1133.2685523069 | 233.7314476931 | ||||||
| 6 | 1556.22304232 | -988.22304232 | ||||||
| 7 | 646.3198941673 | 210.6801058327 | ||||||
| 8 | 2484.4049149115 | 326.5950850885 | ||||||
| 9 | 655.5825711891 | -81.5825711891 | ||||||
| 10 | 256.1364895511 | 27.8635104489 | ||||||
| 11 | 591.6481769154 | 592.3518230846 | ||||||
| 12 | 313.0329837227 | 553.9670162773 | ||||||
| 13 | 741.3139053409 | 690.6860946591 | ||||||
| 14 | 253.9100000144 | -148.9100000144 | ||||||
| 15 | 1379.1038010068 | -603.1038010068 | ||||||
| 16 | 358.7257902888 | -209.7257902888 | ||||||
| 17 | 2181.1510412901 | -763.1510412901 | ||||||
| 18 | 240.3171615744 | -33.3171615744 | ||||||
| 19 | 2186.5219204997 | -778.5219204997 | ||||||
| 20 | 809.8647373892 | 853.1352626108 |
X Variable 1 Residual Plot
244615 1127 500 1618 16277 27761 10723 37463 9862 4229 9273 4411 12406 3216 20049 5247 32773 3514 31656 12472 188.80301806139869 1.3905769990236934 -46.725666262320033 -25.942946309955914 233.73144769309874 -988.22304232001602 210.68010583273372 326.59508508850968 -81.58257118908125 27.863510448865441 592.35182308463391 553.96701627734069 690.68609465912243 -148.91000001437516 -603.10380100682869 -209.72579028879449 -763.15104129008796 -33.317161574355936 -778.52192049966879 853.13526261075128X Variable 1
Residuals
X Variable 2 Residual Plot
2492282 10591 10491 46260 194035 477179 152635 248940 114653 64288 139135 39547 201202 67676 142193 35641 336896 12609 122659 75566 188.80301806139869 1.3905769990236934 -46.725666262320033 -25.942946309955914 233.73144769309874 -988.22304232001602 210.68010583273372 326.59508508850968 -81.58257118908125 27.863510448865441 592.35182308463391 553.96701627734069 690.68609465912243 -148.91000001437516 -603.10380100682869 -209.72579028879449 -763.15104129008796 -33.317161574355936 -778.52192049966879 853.13526261075128X Variable 2
Residuals
X Variable 3 Residual Plot
10417508 44855 41785 151722 855500 1897405 607774 1015434 487821 254116 589963 172784 828587 326639 624241 151186 1468707 55387 533285 309828 188.80301806139869 1.3905769990236934 -46.725666262320033 -25.942946309955914 233.73144769309874 -988.22304232001602 210.68010583273372 326.59508508850968 -81.58257118908125 27.863510448865441 592.35182308463391 553.96701627734069 690.68609465912243 -148.91000001437516 -603.10380100682869 -209.72579028879449 -763.15104129008796 -33.317161574355936 -778.52192049966879 853.13526261075128X Variable 3
Residuals
X Variable 4 Residual Plot
0 11 21 22 23 31 42 44 48 51 52 53 54 55 56 61 62 71 72 81 188.80301806139869 1.3905769990236934 -46.725666262320033 -25.942946309955914 233.73144769309874 -988.22304232001602 210.68010583273372 326.59508508850968 -81.58257118908125 27.863510448865441 592.35182308463391 553.96701627734069 690.68609465912243 -148.91000001437516 -603.10380100682869 -209.72579028879449 -763.15104129008796 -33.317161574355936 -778.52192049966879 853.13526261075128X Variable 4
Residuals
X Variable 1 Line Fit Plot
Y 244615 1127 500 1618 16277 27761 10723 37463 9862 4229 9273 4411 12406 3216 20049 5247 32773 3514 31656 12472 15921 142 34 56 1367 568 857 2811 574 284 1184 867 1432 105 776 149 1418 207 1408 1663 Predicted Y 244615 1127 500 1618 16277 27761 10723 37463 9862 4229 9273 4411 12406 3216 20049 5247 32773 3514 31656 12472 15732.196981938601 140.60942300097631 80.725666262320033 81.942946309955914 1133.2685523069013 1556.223042320016 646.31989416726628 2484.4049149114903 655.58257118908125 256.13648955113456 591.64817691536609 313.03298372265925 741.31390534087757 253.91000001437516 1379.1038010068287 358.72579028879449 2181.151041290088 240.31716157435594 2186.5219204996688 809.86473738924872X Variable 1
Y
X Variable 2 Line Fit Plot
Y 2492282 10591 10491 46260 194035 477179 152635 248940 114653 64288 139135 39547 201202 67676 142193 35641 336896 12609 122659 75566 15921 142 34 56 1367 568 857 2811 574 284 1184 867 1432 105 776 149 1418 207 1408 1663 Predicted Y 2492282 10591 10491 46260 194035 477179 152635 248940 114653 64288 139135 39547 201202 67676 142193 35641 336896 12609 122659 75566 15732.196981938601 140.60942300097631 80.725666262320033 81.942946309955914 1133.2685523069013 1556.223042320016 646.31989416726628 2484.4049149114903 655.58257118908125 256.13648955113456 591.64817691536609 313.03298372265925 741.31390534087757 253.91000001437516 1379.1038010068287 358.72579028879449 2181.151041290088 240.31716157435594 2186.5219204996688 809.86473738924872X Variable 2
Y
X Variable 3 Line Fit Plot
Y 10417508 44855 41785 151722 855500 1897405 607774 1015434 487821 254116 589963 172784 828587 326639 624241 151186 1468707 55387 533285 309828 15921 142 34 56 1367 568 857 2811 574 284 1184 867 1432 105 776 149 1418 207 1408 1663 Predicted Y 10417508 44855 41785 151722 855500 1897405 607774 1015434 487821 254116 589963 172784 828587 326639 624241 151186 1468707 55387 533285 309828 15732.196981938601 140.60942300097631 80.725666262320033 81.942946309955914 1133.2685523069013 1556.223042320016 646.31989416726628 2484.4049149114903 655.58257118908125 256.13648955113456 591.64817691536609 313.03298372265925 741.31390534087757 253.91000001437516 1379.1038010068287 358.72579028879449 2181.151041290088 240.31716157435594 2186.5219204996688 809.86473738924872X Variable 3
Y
X Variable 4 Line Fit Plot
Y 0 11 21 22 23 31 42 44 48 51 52 53 54 55 56 61 62 71 72 81 15921 142 34 56 1367 568 857 2811 574 284 1184 867 1432 105 776 149 1418 207 1408 1663 Predicted Y 0 11 21 22 23 31 42 44 48 51 52 53 54 55 56 61 62 71 72 81 15732.196981938601 140.60942300097631 80.725666262320033 81.942946309955914 1133.2685523069013 1556.223042320016 646.31989416726628 2484.4049149114903 655.58257118908125 256.13648955113456 591.64817691536609 313.03298372265925 741.31390534087757 253.91000001437516 1379.1038010068287 358.72579028879449 2181.151041290088 240.31716157435594 2186.5219204996688 809.86473738924872X Variable 4
Y
Sheet4
| SUMMARY OUTPUT | ||||||||
| Regression Statistics | ||||||||
| Multiple R | 0.9892610141 | |||||||
| R Square | 0.978637354 | |||||||
| Adjusted R Square | 0.9774505403 | |||||||
| Standard Error | 517.6087530797 | |||||||
| Observations | 20 | |||||||
| ANOVA | ||||||||
| df | SS | MS | F | Significance F | ||||
| Regression | 1 | 220923783.767235 | 220923783.767235 | 824.5922504599 | 1.73534838926834E-16 | |||
| Residual | 18 | 4822538.7827648 | 267918.821264711 | |||||
| Total | 19 | 225746322.55 | ||||||
| Coefficients | Standard Error | t Stat | P-value | Lower 95% | Upper 95% | Lower 95.0% | Upper 95.0% | |
| Intercept | 19.1818814787 | 128.0338831091 | 0.1498187903 | 0.8825735356 | -249.8073254428 | 288.1710884002 | -249.8073254428 | 288.1710884002 |
| X Variable 1 | 0.0642679405 | 0.0022380756 | 28.715714347 | 1.7353483892683E-16 | 0.0595659181 | 0.068969963 | 0.0595659181 | 0.068969963 |
| RESIDUAL OUTPUT | ||||||||
| Observation | Predicted Y | Residuals | ||||||
| 1 | 15740.0841575621 | 180.9158424379 | ||||||
| 2 | 91.6118504714 | 50.3881495286 | ||||||
| 3 | 51.3158517505 | -17.3158517505 | ||||||
| 4 | 123.1674092783 | -67.1674092783 | ||||||
| 5 | 1065.2711497076 | 301.7288502924 | ||||||
| 6 | 1803.3241789108 | -1235.3241789108 | ||||||
| 7 | 708.3270079282 | 148.6729920718 | ||||||
| 8 | 2426.8517380652 | 384.1482619348 | ||||||
| 9 | 652.9923111201 | -78.9923111201 | ||||||
| 10 | 290.9710020378 | -6.9710020378 | ||||||
| 11 | 615.1384941399 | 568.8615058601 | ||||||
| 12 | 302.6677672167 | 564.3322327833 | ||||||
| 13 | 816.4899518631 | 615.5100481369 | ||||||
| 14 | 225.8675782671 | -120.8675782671 | ||||||
| 15 | 1307.6898214382 | -531.6898214382 | ||||||
| 16 | 356.3957655112 | -207.3957655112 | ||||||
| 17 | 2125.4350969155 | -707.4350969155 | ||||||
| 18 | 245.0194245491 | -38.0194245491 | ||||||
| 19 | 2053.6478073283 | -645.6478073283 | ||||||
| 20 | 820.731635939 | 842.268364061 |
X Variable 1 Residual Plot
244615 1127 500 1618 16277 27761 10723 37463 9862 4229 9273 4411 12406 3216 20049 5247 32773 3514 31656 12472 180.91584243790385 50.388149528620602 -17.315851750514803 -67.167409278308455 301.72885029241866 -1235.3241789107856 148.67299207181566 384.14826193478348 -78.992311120107047 -6.9710020377621618 568.8615058600991 564.33223278329478 615.51004813686336 -120.86757826705107 -531.6898214382054 -207.39576551119143 -707.43509691552799 -38.019424549056907 -645.64780732827785 842.26836406098289X Variable 1
Residuals
X Variable 1 Line Fit Plot
Y 244615 1127 500 1618 16277 27761 10723 37463 9862 4229 9273 4411 12406 3216 20049 5247 32773 3514 31656 12472 15921 142 34 56 1367 568 857 2811 574 284 1184 867 1432 105 776 149 1418 207 1408 1663 Predicted Y 244615 1127 500 1618 16277 27761 10723 37463 9862 4229 9273 4411 12406 3216 20049 5247 32773 3514 31656 12472 15740.084157562096 91.611850471379398 51.315851750514803 123.16740927830845 1065.2711497075813 1803.3241789107856 708.32700792818434 2426.8517380652165 652.99231112010705 290.97100203776216 615.1384941399009 302.66776721670527 816.48995186313664 225.86757826705107 1307.6898214382054 356.39576551119143 2125.435096915528 245.01942454905691 2053.6478073282778 820.73163593901711X Variable 1
Y
