stateio: US State Input-Output (stateio) R modeling software

This document presents validation results of 2015 summary-level state IO model.

0. Load data

2015 US IO data for states successfully loaded.

2015 single-region IO data for states successfully loaded.

2015 two region IO data for states successfully loaded.

1. Check if industry output from state Make and Use are almost equal (\<= 0.01).

There are no failures.

2. Sum of each cell across all state Make tables must almost equal (\<= 0.001) the same cell in US Make table.

There are no failures.

3. There should not be any negative values in state Make table, unless they are negative in US Make table.

Note: only exception being Overseas, which isn’t used for further calculations, and if the same cell in US Make table is also negative. There are no failures.

4. Sum of each industry’s output across all states must almost equal (\<= 1E7, or \$10 million by industry) the industry output in US Make Table.

The threshold is set to 1E7 because there are differences (within +/- \$10 million) between US industry output summed from Make and that summed from Use, comparing sum of state industry output (summed from state Use) to US industry output summed from US Make should account for those inherent differences at the national level. There are no failures.

5. Sum of each commodity’s output across all states must almost equal (\<= 1E7, or \$10 million by commodity) the commodity output in US Make Table.

6. Sum of each commodity’s output across all states must almost equal (\<= 1E^7, or \$10 million by commodity) commodity output in US Use Table.

Note: even if the threshold is met, track the difference for each commodity. Save result as a type of quality control check.

There are no failures.

| | q_state_sum - q_US_use | |--------|-----------------------:| | 111CA | -1.000e+06 | | 113FF | 3.000e+06 | | 211 | 3.000e+06 | | 212 | -2.000e+06 | | 213 | -2.000e+06 | | 22 | -2.000e+06 | | 23 | 3.000e+06 | | 321 | 3.050e-05 | | 327 | -5.000e+06 | | 331 | -4.000e+06 | | 332 | 2.000e+06 | | 333 | -2.000e+06 | | 334 | -6.000e+06 | | 335 | -4.000e+06 | | 3361MV | 1.000e+06 | | 3364OT | 2.000e+06 | | 337 | -1.000e+06 | | 339 | 5.000e+06 | | 311FT | -4.000e+06 | | 313TT | -1.000e+06 | | 315AL | 3.000e+06 | | 322 | 2.000e+06 | | 323 | 7.000e+06 | | 324 | 3.000e+06 | | 325 | -4.000e+06 | | 326 | 2.000e+06 | | 42 | -4.000e+06 | | 441 | 3.000e+06 | | 445 | 1.000e+06 | | 452 | 1.000e+06 | | 4A0 | 3.000e+06 | | 481 | 1.000e+06 | | 482 | 3.000e+06 | | 483 | 2.000e+06 | | 484 | -4.000e+06 | | 485 | 1.000e+06 | | 486 | 3.000e+06 | | 487OS | -1.000e+06 | | 493 | 3.000e+06 | | 511 | 3.050e-05 | | 512 | -3.050e-05 | | 513 | -2.000e+06 | | 514 | -6.000e+06 | | 521CI | 1.000e+06 | | 523 | -2.000e+06 | | 524 | 4.000e+06 | | 525 | 0.000e+00 | | HS | -4.883e-04 | | ORE | -3.000e+06 | | 532RL | 3.000e+06 | | 5411 | -2.000e+06 | | 5415 | 3.000e+06 | | 5412OP | 5.000e+06 | | 55 | -1.000e+06 | | 561 | -2.000e+06 | | 562 | -1.000e+06 | | 61 | -4.000e+06 | | 621 | 2.000e+06 | | 622 | 2.000e+06 | | 623 | 1.000e+06 | | 624 | -9.160e-05 | | 711AS | -3.000e+06 | | 713 | -1.000e+06 | | 721 | -3.000e+06 | | 722 | 2.441e-04 | | 81 | 3.000e+06 | | GFGD | -1.221e-04 | | GFGN | 2.441e-04 | | GFE | 3.000e+06 | | GSLG | -2.441e-04 | | GSLE | 1.000e+06 | | Used | -1.000e+06 | | Other | -1.000e+06 |

7. All cells that are zero in US Make table must remain zero in state Make tables. Find zero values in US Make table.

There are no failures.

8. Sum of each cell across all state Use tables must almost equal (\<= 5E6, or \$5 million) the same cell in US Use table. This validates that Total state demand == Total national demand.

Note: failures associated with ‘F050 - Imports’ are acceptable. Because state imports are not directly derived from US imports, a gap in imports between state sum and national total is reasonable.

8.1 State Use tables (checking absolute differences)

There are 2 failures, and they are

| Commodity | Industry/Final Demand | Absolute Diff | Validation | AbsDiffPortioninNationalTotals | |:----------|:----------------------|--------------:|:-------------------------|-------------------------------:| | 324 | F050 | -5e+06 | abs(result) \< tolerance | 0.0000828 | | 513 | F050 | 9e+06 | abs(result) \< tolerance | -0.0566038 |

8.2 State Domestic Use tables (checking absolute differences)

There are no failures.

8.3 State Use tables (checking relative differences)

There are 9 failures, and they are

| Commodity | Industry/Final Demand | Relative Diff | Validation | US | StateSum | |:----------|:----------------------|--------------:|:-------------------------|-----------:|------------:| | 212 | F050 | -0.001 | abs(result) \< tolerance | -1.890e+09 | -1888094527 | | 22 | F050 | 0.001 | abs(result) \< tolerance | -2.674e+09 | -2678000000 | | 487OS | F050 | 0.001 | abs(result) \< tolerance | 3.043e+09 | 3046986748 | | 513 | F050 | -0.057 | abs(result) \< tolerance | -1.590e+08 | -150000000 | | 521CI | F050 | -0.022 | abs(result) \< tolerance | -4.500e+07 | -44000000 | | 523 | F050 | -0.053 | abs(result) \< tolerance | -5.700e+07 | -54000000 | | 562 | F050 | -0.016 | abs(result) \< tolerance | -1.850e+08 | -182000000 | | 711AS | F050 | -0.002 | abs(result) \< tolerance | -1.312e+09 | -1309000000 | | GFE | F050 | -0.005 | abs(result) \< tolerance | -3.920e+08 | -390000000 |

8.4 State Domestic Use tables (checking relative differences)

There are no failures.

9. Check if commodity output from two-region Make and Domestic Use are almost equal (relative difference \<= 0.01).

There are no failures.

10. If SoI commodity output == 0, SoI2SoI ICF ratio == 0

There are no failures.

11. SoI and RoUS interregional exports >= 0, interregional imports >= 0

There are no failures.

12. SoI net exports + RoUS net exports == 0

There are no failures.

13. Check row sum of SoI2SoI \<= state commodity supply. Row sum of RoUS2RoUS \<= RoUS commodity supply.

There are no failures.

14. Value in SoI2SoI and RoUS2RoUS can be negative only when the same cell is negative in national Use table

There are no failures.

15. SoI interregional imports == RoUS interregional exports, or difference \<= 0.001

There are no failures.

16.1. Total state commodity supply == state demand by intermediate consumption, plus final demand (except imports and international trade adjustment) + Interregional Exports + Export Residual. Difference must be \<= 0.001.

There are no failures.

16.2. Total SoI and RoUS commodity supply (output) == SoI and RoUS demand (domestic intermediate consumption + ITA + Export Residual).

There are no failures.

17. Number of negative cells in SoI2SoI, SoI2RoUS, RoUS2SoI and RoUS2RoUS \<= Number of negative cells in national Use table

There are no failures.