The Federal Deposit Insurance Corporation (FDIC) supplies data for insured commercial banks, by state or other...
Fantastic news! We've Found the answer you've been seeking!
Question:
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
Expert Answer:
Related Book For
Business Statistics For Contemporary Decision Making
ISBN: 978-1118749647
8th edition
Authors: Black Ken
Posted Date:
Students also viewed these banking questions
-
5. Consider the subspace W of V(3, 3) you described in Question 2. (i) What is the dimension of W? (ii) Find eight different bases for W. (iii) Find four sets of vectors, each having cardinality 2,...
-
Using software, conduct a one-way analysis of variance (ANOVA) F-F-test at a significance level of a=0.05a=0.05 to determine if the mean weight for Hispanic women of age 36 to 45 for four regions of...
-
The Federal Deposit Insurance Corporation (FDIC) releases data on bank failures. Following are data on the number of U.S. bank failures in a given year and the total amount of bank deposits (in $...
-
Write code in MATLAB (Radionuclide) (half-life) U-238 4.468 x 10 years U-235 703.8 x 10 years Mo-99 67 hours Tc-99m 6.04 hours Given the formula, where is the decay constant used in , calculate the...
-
Gerald wants to determine the required return on a stock portfolio with a beta coefficient of 0.5. Assuming the risk-free rate of 6 percent and the market return of 12 percent, compute the required...
-
Devour, Inc., is considering a change in its cashonly sales policy. The new terms of sale would be net one month. Based on the following information, determine if Devour should proceed or not....
-
Carmen Estrada and Paula Jeter agree to form a partnership on June 1 of the current year. The partnership assumes the assets and liabilities of Carmens existing business. Paula invests cash equal to...
-
Baich Transport Company divides its operations into four divisions. A recent income statement for Koslov Division follows. Required a. Should Koslov Division be eliminated? Support your answer by...
-
The distribution process takes precisely 6 seconds per gift bag, and the average arrival rate of individuals is 9 people per minute. Using the M/D/1 queuing model, determine
-
Fractional composition in a tetraprotic system. Prepare a fractional composition diagram analogous to Figure 9-4 for the tetraprotic system derived from hydrolysis of Cr3+: Cr3+ + (H2O) Cr(OH)2+ +...
-
Case: Managing Patient Wait Times at a Family Clinic You have a job assisting the Medical Director at a Family Medical Clinic in New York City. The Medical Director is concerned about the long wait...
-
1) Divide 45a + 12 by 3 2) Divide - 5a + 10a by -5 3) Divide 6x - 12x by x 4). Divide ak - bk by k 5) Divide 3x-9x + 15x3 by 3x
-
Mike is an up-and-coming sports gear designer. He is currently finishing a range of innovative rugby kits that he wants to market. Mike has capital to spend on employing marketing companies to market...
-
You have decided to place $167 in equal deposits every month at the beginning of the month into a savings account earning 17.36 percent per year, compounded monthly for the next 7 years. The first...
-
Norton Inc. could improve its current ratio of 2 by: Multiple Choice purchasing inventory on credit. selling merchandise on credit at a profit. writing off an uncollectible receivable. paying a...
-
Wind born Company has 10,000 shares of cumulative preferred 3% stock, $50 par and 50,000 shares of $30 par common stock. The following amounts were distributed as dividends: 20Y1 $30,000 20Y2 12,000...
-
Lawrence Company purchased a machine for $950,000 on 1/1/21, and depreciated it by the straight-line method using an estimated useful life of eight years with no salvage value. In 2024, Lawrence...
-
Prove the following D,(cos x) = - sin x (Hint: Apply the identity cos(A + B) = cos A cos B sin A sin B)
-
Suppose you are using a completely randomized design to study some phenomenon. There are five treatment levels and a total of 55 people in the study. Each treatment level has the same sample size....
-
One of the earliest applications of the Poisson distribution was in analyzing incoming calls to a telephone switch-board. Analysts generally believe that random phone calls are Poisson distributed....
-
In problem 12.10, you were asked to develop the equation of a regression model to predict the number of business bankruptcies by the number of firm births. Using this regression model and the data...
-
In what terms are standard variable overhead application rates (SR) usually stated? a. Per dollar b. Per direct labor hour c. Per unit of product d. Per month
-
The gross profit on the interim income statement of a firm using standard costs is computed as: a. Sales less cost of goods sold at standard b. Sales less cost of goods sold at standard plus net...
-
The formula [(Actual Price Standard Price) X Actual Quantity] can be used to calculate which cost variance? a. Variable overhead volume b. Labor efficiency c. Materials efficiency d. Materials price
Study smarter with the SolutionInn App