The Federal Deposit Insurance Corporation (FDIC) supplies data for insured commercial banks, by state or other...

 

Transcribed Image Text:

The Federal Deposit Insurance Corporation (FDIC) supplies data for insured commercial banks, by state or other area. In the data, the cases are the 50 states, the District of Columbia, Guam, and Puerto Rico. Bank assets, interest-bearing deposits, and equity capital are given in billions of dollars. Click to download the data in your preferred format. CSV Excel JMP Mac-Text Minitab PC-Text R SPSS TI Crunchlt! We are interested in describing how assets are explained by total interest-bearing deposits and total equity capital. Consider the log transformation for all variables. Run the regression using the log-transformed variables and report the coefficients of the least-squares equation of the form = b + b₁x1 + b₂x2, where x₁ is the log-transformed interest-bearing deposit and x₂ is the log-transformed equity capital. (Use decimal notation. Give your answers to four decimal places.) bo = b₁ = You run a multiple regression with 64 cases and three explanatory variables. Software output gives MSE= 37.3. What is the estimate of the standard deviation o of the model? Provide your answer for the standard deviation estimate s with precision to two decimal places. S= A1 4 Arizona. 5 Arkansas 6 California 7 Colorado 1 StateTemitory 2 Alabama 3 Alaska <> 12 Georgia 13 Guam A 14 Hawaii 15 Idaho 8 Connecticut 9 Delaware 10 District of Columbia 11 Florida 16 linois 17 Indiana 18 lowa 19 Kansas 20 Kentucky 21 Louisiana 22 Maine 23 Maryland 24 Massachusetts 25 Michigan 26 Minnesota 27 Mississippi 28 Missoun 29 Montana 30 Nebraska 31 Nevada 32 New Hampshire 33 New Jersey 34 New Mexico 35 New York 36 North Carolina 37 North Dakota 38 Ohio 39 Oklahoma 40 Oregon 41 Pennsylvania 42 Rhode Island 43 South Carolina 44 South Dakota 45 Tennessee 46 Texas X ✓ fx StateTerritory 47 Utah 48 Vermont 49 Virginia 50 Washington 51 West Virginia 52 Wisconsin 53 Wyoming 54 Puerto Rico 55 56 B с D E F Assets. IntBearingDep Equity Ln(Assets) Ln(IntBearingDep) 261.8 6.4 0.8 24.4 97.7 756.7 63 111.2 1067.3 34.4 5.56758085 1.85629799 2.7 3.19458313 13.5 4.58190156 92.1 6.62896687 6.3 4.14313473 12.8 4.71133038 145.8 6.97288737 0.1 0.18232156 20.3 5.27811466 36.4 5.74396426 0.2 0.87546874 5.2 3.97781075 0.7 1.82454929 55.8 6.20334491 11.1 4.55282371 9.1 4.42723898 8.1 4.2527718 6.7 4.08933202 10.9 16.2 9.2 4.33990171 3 3.28466357 4.9 3.70376807 39.7 5.96665943 8.8 4.3719763 7.9 4.29728541 4.550714 5.0689042 4.1 3.53805656 7.8 4.30541553 17.5 5.39408199 1.2 2.39789527 17.2 5.00125813 1.3 2.58776404 120.4 6.91194648 242.6 7.61751373 2.9 3.36037539 314 8.03171038 12.3 4.74406218 4.9 3.4436181 29.9 5.50938834 18.2 4.88809094 4.9 3.58629287 316.7 8.06896671 16.3 4.87213922 $5.5 6.21280648 78.3 6.48356596 0.5 1.58923521 92,4 6.59537059 9.8 4.34510328 3.6 3.38777436 13.5 4.72650247 0.9 2.11625551 8.5 4.13356528 1.2 196 312.3 2.4 53.4 6.2 494.4 94.9 83.7 70.3 59.7 76.7 26.7 40.6 390.2 79.2 73.5 94.7 159 34.4 74.1 220.1 11 148.6 13.3 1004.2 2033.5 28.8 3077 114.9 31.3 247 132.7 36.1 3193.8 130.6 499.1 654.3 4.9 731.7 77.1 29.6 112.9 8.3 62.4 143 2.8 12 64.9 380.9 42 67.2 608.3 0.7 124.9 193.6 31 1.6 32 3.5 6259 287.8 60.6 55.8 45.2 37.9 46.1 17.2 24.2 244 44.4 47.1 55.3 100.1 19.9 47.4 179.3 7.6 92.9 8 603.3 1057.2 19.5 1655.1 68 17 159.2 72.1 22.9 1779.8 G Ln(Equity) 4.96284463 3.538056564 1.029619417 0.22314355 2.48490665 0.993251773 4.172847624 2.602689685 5.942536873 4.522874943 3.737669618 1.840549633 4.207673248 2.549445171 6.410668181 4.98223582 -0.356674944 -2.30258509 4.827513417 3.010620886 5.265794175 3.594568775 0.470003629 -1.60943791 3.465735903 1.648658626 1.252762968 -0.35667494 5.662265794 4.021773869 4.104294893 2.406945108 4.021773869 2.208274414 3.811097087 2.091864062 3.634951112 1.902107526 3.83081295 2.219203484 2.844909384 1.098612289 3.186352633 1.589235205 5.497168225 3.681351188 3.793239469 2.174751721 3.852273001 2.066862759 4.012772909 2.388762789 4.606169686 2.785011242 2.990719732 1.410986974 3.858622229 2.054123734 5.189060381 2.862200881 2.028148247 0.182321557 4.531523646 2.844909384 2.079441542 0.262364264 6.402414585 4.790819533 6.963379183 5.491413997 2.970414466 1.064710737 7.411616709 5.749392986 4.219507705 2.509599262 2.833213344 1.589235205 5.070161273 3.39785848 4.278054044 2.901421594 3.131136911 1.589235205 7.484256277 5.757954954 4.394449155 2.791165108 5.521060838 4.016383021 6.105462651 4.360547603 1.131402111 -0.69314718 6.158037747 4.526126979 3.795489189 2.282382386 2.901421594 1.280933845 4.257030144 2.602689685 1.757857918 0.10536052 4.278054044 2.140066163 81 249.9 448.3 3.1 472.5 44.5 18.2 70.6 5.8 72.1 H The Federal Deposit Insurance Corporation (FDIC) supplies data for insured commercial banks, by state or other area. In the data, the cases are the 50 states, the District of Columbia, Guam, and Puerto Rico. Bank assets, interest-bearing deposits, and equity capital are given in billions of dollars. Click to download the data in your preferred format. CSV Excel JMP Mac-Text Minitab PC-Text R SPSS TI Crunchlt! We are interested in describing how assets are explained by total interest-bearing deposits and total equity capital. Consider the log transformation for all variables. Run the regression using the log-transformed variables and report the coefficients of the least-squares equation of the form = b + b₁x1 + b₂x2, where x₁ is the log-transformed interest-bearing deposit and x₂ is the log-transformed equity capital. (Use decimal notation. Give your answers to four decimal places.) bo = b₁ = You run a multiple regression with 64 cases and three explanatory variables. Software output gives MSE= 37.3. What is the estimate of the standard deviation o of the model? Provide your answer for the standard deviation estimate s with precision to two decimal places. S= A1 4 Arizona. 5 Arkansas 6 California 7 Colorado 1 StateTemitory 2 Alabama 3 Alaska <> 12 Georgia 13 Guam A 14 Hawaii 15 Idaho 8 Connecticut 9 Delaware 10 District of Columbia 11 Florida 16 linois 17 Indiana 18 lowa 19 Kansas 20 Kentucky 21 Louisiana 22 Maine 23 Maryland 24 Massachusetts 25 Michigan 26 Minnesota 27 Mississippi 28 Missoun 29 Montana 30 Nebraska 31 Nevada 32 New Hampshire 33 New Jersey 34 New Mexico 35 New York 36 North Carolina 37 North Dakota 38 Ohio 39 Oklahoma 40 Oregon 41 Pennsylvania 42 Rhode Island 43 South Carolina 44 South Dakota 45 Tennessee 46 Texas X ✓ fx StateTerritory 47 Utah 48 Vermont 49 Virginia 50 Washington 51 West Virginia 52 Wisconsin 53 Wyoming 54 Puerto Rico 55 56 B с D E F Assets. IntBearingDep Equity Ln(Assets) Ln(IntBearingDep) 261.8 6.4 0.8 24.4 97.7 756.7 63 111.2 1067.3 34.4 5.56758085 1.85629799 2.7 3.19458313 13.5 4.58190156 92.1 6.62896687 6.3 4.14313473 12.8 4.71133038 145.8 6.97288737 0.1 0.18232156 20.3 5.27811466 36.4 5.74396426 0.2 0.87546874 5.2 3.97781075 0.7 1.82454929 55.8 6.20334491 11.1 4.55282371 9.1 4.42723898 8.1 4.2527718 6.7 4.08933202 10.9 16.2 9.2 4.33990171 3 3.28466357 4.9 3.70376807 39.7 5.96665943 8.8 4.3719763 7.9 4.29728541 4.550714 5.0689042 4.1 3.53805656 7.8 4.30541553 17.5 5.39408199 1.2 2.39789527 17.2 5.00125813 1.3 2.58776404 120.4 6.91194648 242.6 7.61751373 2.9 3.36037539 314 8.03171038 12.3 4.74406218 4.9 3.4436181 29.9 5.50938834 18.2 4.88809094 4.9 3.58629287 316.7 8.06896671 16.3 4.87213922 $5.5 6.21280648 78.3 6.48356596 0.5 1.58923521 92,4 6.59537059 9.8 4.34510328 3.6 3.38777436 13.5 4.72650247 0.9 2.11625551 8.5 4.13356528 1.2 196 312.3 2.4 53.4 6.2 494.4 94.9 83.7 70.3 59.7 76.7 26.7 40.6 390.2 79.2 73.5 94.7 159 34.4 74.1 220.1 11 148.6 13.3 1004.2 2033.5 28.8 3077 114.9 31.3 247 132.7 36.1 3193.8 130.6 499.1 654.3 4.9 731.7 77.1 29.6 112.9 8.3 62.4 143 2.8 12 64.9 380.9 42 67.2 608.3 0.7 124.9 193.6 31 1.6 32 3.5 6259 287.8 60.6 55.8 45.2 37.9 46.1 17.2 24.2 244 44.4 47.1 55.3 100.1 19.9 47.4 179.3 7.6 92.9 8 603.3 1057.2 19.5 1655.1 68 17 159.2 72.1 22.9 1779.8 G Ln(Equity) 4.96284463 3.538056564 1.029619417 0.22314355 2.48490665 0.993251773 4.172847624 2.602689685 5.942536873 4.522874943 3.737669618 1.840549633 4.207673248 2.549445171 6.410668181 4.98223582 -0.356674944 -2.30258509 4.827513417 3.010620886 5.265794175 3.594568775 0.470003629 -1.60943791 3.465735903 1.648658626 1.252762968 -0.35667494 5.662265794 4.021773869 4.104294893 2.406945108 4.021773869 2.208274414 3.811097087 2.091864062 3.634951112 1.902107526 3.83081295 2.219203484 2.844909384 1.098612289 3.186352633 1.589235205 5.497168225 3.681351188 3.793239469 2.174751721 3.852273001 2.066862759 4.012772909 2.388762789 4.606169686 2.785011242 2.990719732 1.410986974 3.858622229 2.054123734 5.189060381 2.862200881 2.028148247 0.182321557 4.531523646 2.844909384 2.079441542 0.262364264 6.402414585 4.790819533 6.963379183 5.491413997 2.970414466 1.064710737 7.411616709 5.749392986 4.219507705 2.509599262 2.833213344 1.589235205 5.070161273 3.39785848 4.278054044 2.901421594 3.131136911 1.589235205 7.484256277 5.757954954 4.394449155 2.791165108 5.521060838 4.016383021 6.105462651 4.360547603 1.131402111 -0.69314718 6.158037747 4.526126979 3.795489189 2.282382386 2.901421594 1.280933845 4.257030144 2.602689685 1.757857918 0.10536052 4.278054044 2.140066163 81 249.9 448.3 3.1 472.5 44.5 18.2 70.6 5.8 72.1 H