Discuss Illinois funding status. How is Illinois compared to other states? ( Illinois is identified as IL on the table) For Illinois the average total
Discuss Illinois funding status. How is Illinois compared to other states? ( Illinois is identified as IL on the table)
For Illinois the average total assets is 14433541.33; The average total liabilities is 26084608.57; Average of funding ratio is 0.594634559; Average of funding status (under/over funded) is 11651067.17
This is the table from the both pictures, use this table to answer the question and states to compare to Illinois
| Row Labels | Average of Total Assets | Average of Total Liabilities | Average of Funding Ratio | Average of Funding status (Under/Over Funded) |
| AK | 3842062.826 | 5757998.739 | 0.737990098 | 1915936.348 |
| AL | 10152368.45 | 13433840.22 | 0.802505882 | 3281118.815 |
| AR | 8390572.557 | 10171151.52 | 0.821305092 | 2015151.515 |
| AZ | 7325286.233 | 9474386.462 | 0.783750588 | 2149323.405 |
| CA | 35432885.14 | 43545835.28 | 0.847207054 | 8112950.262 |
| CO | 8673356.146 | 12575350.24 | 0.7765825 | 3901993.965 |
| CT | 6265086.479 | 11113112 | 0.74736052 | 4848019.15 |
| DC | 2243078.265 | 2566514.125 | 1.030534788 | -102530.0417 |
| DE | 3545638.179 | 3701380.102 | 0.921735294 | 155741.9624 |
| FL | 41909111.69 | 44402214.65 | 0.842382988 | 2493309.789 |
| GA | 17285128.13 | 20172376.15 | 0.761089737 | 2892219.602 |
| HI | 11513048.24 | 17971995 | 0.664647059 | 6458958.529 |
| IA | 11790770.39 | 13921277.55 | 0.849822711 | 2130507.224 |
| ID | 10296729.41 | 11559723.53 | 0.893058824 | 1278900 |
| IL | 14433541.33 | 26084608.57 | 0.594634559 | 11651067.17 |
| IN | 10242946.16 | 16275341.58 | 0.674896251 | 6032395.418 |
| KS | 6896214.791 | 10114889.92 | 0.857235294 | 3218675.071 |
| KY | 6997418.965 | 11315036.87 | 0.680191176 | 4317617.89 |
| LA | 4226394.158 | 6410442.765 | 0.759350729 | 2184033.346 |
| MA | 14966034.08 | 22180428.3 | 0.684569684 | 7216394.203 |
| MD | 10300617.17 | 13564876.65 | 0.806583824 | 3264259.502 |
| ME | 5204697.765 | 6638621.117 | 0.880529412 | 1433923.352 |
| MI | 13026549.01 | 17498595.86 | 0.804229894 | 4462511.129 |
| MN | 7351969.531 | 8901430.462 | 0.825676106 | 1549779.931 |
| MO | 6501231.757 | 7934081.3 | 0.810187395 | 1433744.522 |
| MS | 20191279.94 | 30252302.35 | 0.687764706 | 10061022.41 |
F G A B B C D E 3 Row Labels - Average of Total Assets Average of Total Liabilities Average of Funding Ratio Average of Funding status (Under/Over Funded) 4 AK 3842062.826 5757998.739 0.737990098 1915936.348 5 AL 10152368.45 13433840.22 0.802505882 3281118.815 6 AR 8390572.557 10171151.52 0.821305092 2015151.515 7 AZ 7325286.233 9474386.462 0.783750588 2149323.405 8 CA 35432885.14 43545835.28 0.847207054 8112950.262 9 CO 8673356.146 12575350.24 0.7765825 3901993.965 10 CT 6265086.479 11113112 0.74736052 4848019.15 11 DC 2243078.265 2566514.125 1.030534788 -102530.0417 12 DE 3545638.179 3701380.102 0.921735294 155741.9624 13 FL 41909111.69 44402214.65 0.842382988 2493309.789 14 GA 17285128.13 20172376.15 0.761089737 2892219.602 15 HI 11513048.24 17971995 0.664647059 6458958.529 16 IA 11790770.39 13921277.55 0.849822711 2130507.224 17 ID 10296729.41 11559723.53 0.893058824 1278900 18 IL 14433541.33 26084608.57 0.594634559 11651067.17 19 IN 10242946.16 16275341.58 0.674896251 6032395.418 20 KS 6896214.791 10114889.92 0.857235294 3218675.071 21 KY 6997418.965 11315036.87 0.680191176 4317617.89 22 LA 4226394.158 6410442.765 0.759350729 2184033.346 23 MA 14966034.08 22180428.3 0.684569684 7216394.203 24 MD 10300617.17 13564876.65 0.806583824 3264259.502 25 ME 5204697.765 6638621.117 0.880529412 1433923.352 26 MI 13026549.01 17498595.86 0.804229894 4462511.129 27 MN 7351969.531 8901430.462 0.825676106 1549779.931 28 MO 6501231.757 7934081.3 0.810187395 1433744.522 29 MS 20191279.94 30252302.35 0.687764706 10061022.41 Question 1 Question 2 Question 3 data 1-Pension Data data 2 - Income Data Sheet7 node File Home Insert Draw Page Layout Formulas Data Review fx View Help Pivot Table Analyze Design Define Name E3 Trace Preceder Use in Formula Fa Trace Depende Name Manager E Create from Selection FRemove Arrova Insert Function AutoSum Recently Financial Logical Text Date & Lookup & Math & More Used Time - Reference Trig Functions Function Library Defined Names B3 X Average of Total Assets E F G A B 29 MS 20191279.94 30 MT 3526790.813 31 NC 23835239.53 32 ND 1693098.503 33 NE 2838529.116 34 NH 5239449.162 35 NI 27969871.25 36 NM 10490671.88 37 NV 12189322.24 38 NY 49427237.6 39 OH 29361246.15 40 OK 5179124.736 41 OR 50819976.47 42 PA 18977939.54 43 RI 2586248.722 44 SC 13675674.71 45 SD 7272299.49 46 TN 11502165.52 47 TX 22211558.04 48 UT 8964305.313 49 VA 18295176.89 50 VT 1392734.485 51 WA 6918690 52 WI 28552321.1 53 WV 4070478.735 54 WY 5640674.985 55 Grand Total 15513054.77 Question 1 Question 2 D 30252302.35 0.687764706 4653162.109 0.767318775 24082669.81 0.972693878 2302123.193 0.777794118 3489681.634 0.732404 8411802.745 0.646 39301675.78 0.748332575 13990687.32 0.772923529 16455774.83 0.741823529 55620940.03 0.849830503 38607447.28 0.773495627 7869283.935 0.77628 55863129.41 0.925549383 25703601.05 0.712125161 4343610.923 0.617054791 19942919.44 0.740735294 7455230.366 0.972235294 12170115.58 0.927112866 26057780.53 0.851696144 10249083.25 0.874210611 23445517.55 0.806604767 1839633.909 0.799688591 6396700 1.138796337 28682251.26 0.983026 6646907.088 0.635556913 6670582.569 0.862894118 19661782.65 0.800539449 Question 3 data 1-Pension Data 10061022.41 1126371.297 247430.2573 609027.6091 650972.5183 3172353.583 11271522.34 3500018.381 4266453.486 6193694.383 9257667.7 2690162.532 5043152.941 6725663.97 1755542.181 6267244.735 182930.8763 667950.0547 3846238.162 1273287.938 5150340.666 446899.4236 -515532.0988 129930.22 2544634.235 1029907.583 4098152.343 Sheet7 + data2 - Income Data F G A B B C D E 3 Row Labels - Average of Total Assets Average of Total Liabilities Average of Funding Ratio Average of Funding status (Under/Over Funded) 4 AK 3842062.826 5757998.739 0.737990098 1915936.348 5 AL 10152368.45 13433840.22 0.802505882 3281118.815 6 AR 8390572.557 10171151.52 0.821305092 2015151.515 7 AZ 7325286.233 9474386.462 0.783750588 2149323.405 8 CA 35432885.14 43545835.28 0.847207054 8112950.262 9 CO 8673356.146 12575350.24 0.7765825 3901993.965 10 CT 6265086.479 11113112 0.74736052 4848019.15 11 DC 2243078.265 2566514.125 1.030534788 -102530.0417 12 DE 3545638.179 3701380.102 0.921735294 155741.9624 13 FL 41909111.69 44402214.65 0.842382988 2493309.789 14 GA 17285128.13 20172376.15 0.761089737 2892219.602 15 HI 11513048.24 17971995 0.664647059 6458958.529 16 IA 11790770.39 13921277.55 0.849822711 2130507.224 17 ID 10296729.41 11559723.53 0.893058824 1278900 18 IL 14433541.33 26084608.57 0.594634559 11651067.17 19 IN 10242946.16 16275341.58 0.674896251 6032395.418 20 KS 6896214.791 10114889.92 0.857235294 3218675.071 21 KY 6997418.965 11315036.87 0.680191176 4317617.89 22 LA 4226394.158 6410442.765 0.759350729 2184033.346 23 MA 14966034.08 22180428.3 0.684569684 7216394.203 24 MD 10300617.17 13564876.65 0.806583824 3264259.502 25 ME 5204697.765 6638621.117 0.880529412 1433923.352 26 MI 13026549.01 17498595.86 0.804229894 4462511.129 27 MN 7351969.531 8901430.462 0.825676106 1549779.931 28 MO 6501231.757 7934081.3 0.810187395 1433744.522 29 MS 20191279.94 30252302.35 0.687764706 10061022.41 Question 1 Question 2 Question 3 data 1-Pension Data data 2 - Income Data Sheet7 node File Home Insert Draw Page Layout Formulas Data Review fx View Help Pivot Table Analyze Design Define Name E3 Trace Preceder Use in Formula Fa Trace Depende Name Manager E Create from Selection FRemove Arrova Insert Function AutoSum Recently Financial Logical Text Date & Lookup & Math & More Used Time - Reference Trig Functions Function Library Defined Names B3 X Average of Total Assets E F G A B 29 MS 20191279.94 30 MT 3526790.813 31 NC 23835239.53 32 ND 1693098.503 33 NE 2838529.116 34 NH 5239449.162 35 NI 27969871.25 36 NM 10490671.88 37 NV 12189322.24 38 NY 49427237.6 39 OH 29361246.15 40 OK 5179124.736 41 OR 50819976.47 42 PA 18977939.54 43 RI 2586248.722 44 SC 13675674.71 45 SD 7272299.49 46 TN 11502165.52 47 TX 22211558.04 48 UT 8964305.313 49 VA 18295176.89 50 VT 1392734.485 51 WA 6918690 52 WI 28552321.1 53 WV 4070478.735 54 WY 5640674.985 55 Grand Total 15513054.77 Question 1 Question 2 D 30252302.35 0.687764706 4653162.109 0.767318775 24082669.81 0.972693878 2302123.193 0.777794118 3489681.634 0.732404 8411802.745 0.646 39301675.78 0.748332575 13990687.32 0.772923529 16455774.83 0.741823529 55620940.03 0.849830503 38607447.28 0.773495627 7869283.935 0.77628 55863129.41 0.925549383 25703601.05 0.712125161 4343610.923 0.617054791 19942919.44 0.740735294 7455230.366 0.972235294 12170115.58 0.927112866 26057780.53 0.851696144 10249083.25 0.874210611 23445517.55 0.806604767 1839633.909 0.799688591 6396700 1.138796337 28682251.26 0.983026 6646907.088 0.635556913 6670582.569 0.862894118 19661782.65 0.800539449 Question 3 data 1-Pension Data 10061022.41 1126371.297 247430.2573 609027.6091 650972.5183 3172353.583 11271522.34 3500018.381 4266453.486 6193694.383 9257667.7 2690162.532 5043152.941 6725663.97 1755542.181 6267244.735 182930.8763 667950.0547 3846238.162 1273287.938 5150340.666 446899.4236 -515532.0988 129930.22 2544634.235 1029907.583 4098152.343 Sheet7 + data2 - Income Data
